SQL Server Performance

2 members in same level of dimension

Discussion in 'Analysis Services/Data Warehousing' started by johnny_bigu, Jul 6, 2004.

  1. johnny_bigu New Member

    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?
  2. Raulie New Member

    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.
  3. Hemanth New Member

    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

Share This Page