Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

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

Answer Question   |  Jun 9 2008   6:15 PM GMT   |  asked by Sree1119
Hierarchy data, SSAS, SQL


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   |  Apr 8 2008   10:38 PM GMT   |  asked by SQL Server Ask the Experts
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 ?

View Answer   |  Jan 29 2008   11:44 AM GMT   |  asked by Sjors & Sjimmie
Cognos, SQL Server, SSIS


1 - 3 of 3
<<PREVIOUS 1 NEXT>>