Reg:Problem with SSAS
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]

Answer Question   |  March 31, 2012  2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005

Changing date fields in SQL Server Analysis Services
In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

Answer Question   |  July 22, 2009  6:08 PM
SQL Server Analysis Services, SSAS

How well does SSAS run under virtualization? Any special considerations?
How well does SSAS run under virtualization? Any special considerations?

Answer Question   |  June 23, 2009  3:31 PM
Microsoft virtualization, Microsoft Virtualization Chat 5/14, SQL Server Virtualization, SSAS, SSAS Virtualization

Monitor SQL Server 2000 Analysis Services Cubes
I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to [...]

Answer Question   |  March 26, 2009  12:08 AM
SQL Server 2000, SQL Server 2000 Analysis Services, SQL Server Analysis Services, SQL Server business intelligence, SSAS

Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Answer Question   |  March 10, 2009  6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task

How to enable a trace for SQL Server Analysis Services using T-SQL?
Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do [...]

Answer Question   |  December 2, 2008  9:27 AM
SQL Profiler, SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server administration, SQL Server Analysis Services, SSAS, SSAS 2005, T-SQL

How to generate MDX query from cube?
hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.

Answer Question   |  August 4, 2008  7:16 PM
MDX Query, SSAS

Help needed for date dimension which is not rolled up properly.
I’m new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year – smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname – Varchar (Eg: Tuesday), quarter -int(Eg: 1) I build a dimension using [...]

Answer Question   |  June 9, 2008  6:15 PM
Hierarchy data, SQL, SSAS

Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?
Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

Answer Question   |  April 9, 2008  10:38 PM
SQL Server Analysis Services, SQL Server data warehousing/business intelligence, SSAS

Microsoft SSAS with Cognos Front End
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?

Answer Question   |  February 8, 2009  11:44 AM
Cognos, SQL Server, SSAS, SSIS