Performance point filter question RRS feed

  • Question

  • Hi,

    I am trying to create a time filter in performance point dashboard based on the time hierarchy: [Calendar].[Hierarchy].[FiscalYear].[FiscalMonth].[FiscalWeek]. 
    I am currently using the following MDX expression to retrieve the hierarchy: EXISTS(descendants([Calendar].[Hierarchy]) ) This allows me to display the entire hierarchy but it defaultes to "All'. What I need the filter to do is default to the defaultmember  of  FiscalWeek(which is already set). So in other words, the filter should default at the defaultmember of FiscalWeek] but the user should be able to select a fiscal month or a filscal year if he wants to.
    Thank you for your time.

    • Moved by Raymond-Lee Monday, July 6, 2009 4:06 AM It should be a PerformancePoint question. (From:SQL Server Analysis Services)
    Wednesday, July 1, 2009 8:51 PM

All replies