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
