SSAS

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?

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

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

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 do...

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.

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 this in T-sql like an SP or a...

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.

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...

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?

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 ?