2 members in same level of dimension | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

2 members in same level of dimension

I studied at The DW Toolkit (Kimball),a kind of time dimension: 2003
Jan
1
2

31
Feb
1

Q1

Q4
Week1
Week2
… You see month, quarter and week in same level, with differents trees. How to build it in Analysis Services?
I really dont think is makes for good design practice, but you can accomplish this by treating the Quarter as a "member property" which can appear at any level in the hierarchy.
Dear Biju, Assuming you have a date filed in your table while designing the cube you can use the dimension wizard and create this field as a time dimension. and using a date you specify to be the starting date in the wizard it will calculate the Week. Try this out and let me know how it goes. Hemanth
]]>