Post reply

Help in Date Dimension/Hierarchy Design

  • November 22, 2013 at 6:57 pm

    #144655

    New to SSAS. I'm trying to design my date dimension but couldn't figure out why I cannot fix my hierarchy. TIA

    I have this table as basis for my dimension.

    I created a simple dimension and hierarchy below.

    When I browse, I get dates and weeks not falling on the correct year.

    If I remove the Fiscal Week, the dates fall into the correct Fiscal Year bucket. What am I doing wrong?

  • November 25, 2013 at 9:03 am

    #1668848

    It may be just me, but I can't see any images. Could you try attaching them?

  • November 25, 2013 at 12:19 pm

    #1668941

    Lempster (11/25/2013)

    It may be just me, but I can't see any images. Could you try attaching them?

    Attaching the pix....tnx.

  • November 25, 2013 at 2:33 pm

    #1668983

    Turned out it must have been the settings on my machine at work as at home I can see your original images fine - sorry!

    I will try and replicate your set up when I get time, but I'm thinking that it could be do to with your Dimension attribute ordering. What is your FiscalWeek attribute ordered by?. I don't know whether you've built a cube that uses this Date Dimension; if you have, do you get any warnings/errors relating to the Date Dimension when you process the cube?

    Regards

    Lempster

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply