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