Set default view to current date/Week/Month RRS feed

  • Question

  • Hi,
      I have the time dimension with the hierarchy as Year,Quarter,Month,Week and Date.
    The View has the amount sold as measure. The columns will have the dates for the week chosen in the timeline. Right now the user has to select the current week manually each time. The Cube will have data for the past weeks too. I want the view to  have the week default to the current week.
        How to achieve this in proclartiy. Please provide some samples if any.


    Wednesday, January 14, 2009 3:21 PM

All replies

  • Hello Arun,

    Here is a link to a forum entry that should give you what you need to achieve your objective:


    Please let us know if you have any questions.



    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 14, 2009 4:09 PM
  • Sorry Bob. I am not able to figure out how to use that in my query.

    Here is my mdx query generated by proclarity. This by default points to the 1st week of year 2009.
    How do dynamically change this to current week of the year.


    WITH MEMBER [Period].[Calendar Date].[All].[ Grand Total] AS
       'AGGREGATE(<<Children>> )', SOLVE_ORDER = 1000

     MEMBER [Item].[PRODUCT LINE DESC].[All].[ Grand Total] AS
        'AGGREGATE( <<Children>>)',
         SOLVE_ORDER = 1000

    SELECT NON EMPTY { { [Period].[Calendar Date].[All].CHILDREN },
                       ( [Period].[Calendar Date].[All].[ Grand Total] ) }
                       ON COLUMNS ,
           NON EMPTY { { [Item].[PRODUCT LINE DESC].[All].CHILDREN },
                      ( [Item].[PRODUCT LINE DESC].[All].[ Grand Total] ) }
                       ON ROWS 

    FROM [Sales]

    WHERE (
           [Sold To Customer].[Sold To Customer Hierarchy].[SOLD TO MARKET DESC].&[SA],
           [Item].[DSS BUSINESS UNIT DESC].&[BU1],
           [Period].[Period].[Acct Week].&[WK 1 2009],
           [Item].[PRODUCT FORM DESC].&[Solid],
           [Measures].[EST NET TONS QTY] )


    I tried to create a member as
     [Period].[Acct Week].[CurrentWeek]  as 'StrToMember([Period].[Period].[Acct Week].&[WK 1 2009])' 
      <<planning to use vba script to get the week and concatenate>>

    and use this member [Period].[Acct Week].[CurrentWeek]
    in the Where clause  instead of [Period].[Period].[Acct Week].&[WK 1 2009], But this condition does not succeed and all the dates in the period are returned instead of only the days of the week

    Wednesday, January 14, 2009 10:13 PM
  • As mentioned in the thread Bob references, you'll need to build a named set or member that will always resolve to the date you want.  Then select that set for the query in ProClarity, and when the query runs it will resolve the set to whatever the current week is, in this case.
    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, January 16, 2009 10:16 PM