SQL Server Performance Forum – Threads Archive
2 members in same level of dimensionI studied at The DW Toolkit (Kimball),a kind of time dimension: 2003
… 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