Posted
by ngm
on Stack Overflow
See other posts from Stack Overflow
or by ngm
Published on 2010-03-31T08:32:49Z
Indexed on
2010/03/31
8:43 UTC
Read the original article
Hit count: 516
Is it possible to use SQL Server 2008 Analysis Services with data stored in Sybase Advantage Database Server? Either directly, or via SQL Server Integration Services.
© Stack Overflow or respective owner
as seen on SQL Blog
- Search for 'SQL Blog'
A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of…
>>> More
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation…
>>> More
as seen on ASP.net Weblogs
- Search for 'ASP.net Weblogs'
On a project I work on, we capture the queries that get executed on our Analysis Services instance (SQL Server 2008 R2) and use the table for helping us to build aggregations and also we aggregate the query log daily into a data warehouse of operational data so we can track usage of our Analysis databases…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi there,
I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took.
Like...
RequestID Time Taken
--------------------------
1 0
2 10
3 20
4 20
5 …
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and sets go (defined in the WITH clause). SSAS appears to ignore the Language of the specified members when…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali:
What's new in SSIS in Denali
Introduction to SSIS Projects in Denali
Parameters in SSIS In Denali
SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali…
>>> More
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
as seen on SQLIS
- Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice…
>>> More
