Post reply

DimDate - How to set Week of Month / Week Of Year in Calendar Hierarchy

  • April 16, 2012 at 9:44 am

    #145232

    Hi All ,

    I have created DimDate dimension and able to setup Calendar Hierarchy. Now to the Calendar Hierarchy if i add week of month and week of year to Calendar Hierarchy this will not give correct result.

    Is my approach in setting the week Hierarchy is Correct ?. Please help me

    i am attaching images for references. Let me know any other information is required here !

    ~Vineet

  • April 17, 2012 at 7:03 am

    #1474698

    Vineet,

    What is the key attribute of "Week Of Month"?

    Chris

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

  • April 18, 2012 at 3:20 am

    #1475210

    key attribure of Week Of Month is collection : (Week Of Month,Month,Year)

    [Dim Date].[Calendar Hierarchy].[Week Of Month]

    WHERE (StrToMember('[Dim Date].[Date].&[2012-03-23T00:00:00]&[03]&[1]&[2012]') :

    StrToMember( '[Dim Date].[Date].&[2012-03-31T00:00:00]&[03]&[1]&[2012]'))

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

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