Building simple Dimension - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Building simple Dimension

Author

Topic

cipriani1984
Constraint Violating Yak Guru

304 Posts

Posted - 2012-03-09 : 04:06:52

Hi,

I have a table,
id, year, month
1, 2012, jan
2, 2012, feb
3, 2012, march

Ive built a dimension in analysis services project in visual studio and just created a hierarchy:
Year > Month.

But when using the browser it looks like this:
2012 >
Feb
Jan
March

obviously sorting them by name, but ive set the key attribute which is the dateid and sorted the year and month by key and its still sorting by name.

Any ideas?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-09 : 11:54:00

where's the month number stored?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources