Search code examples
filterdatepickermdxiccube-reporting

Use date picker range as a filter in a MDX query

I created a report against the demo Sales cube. It includes a date picker with range (from & to) where the "on selection" event is named date window.
& a pivot table with a MDX query similar to this:

SELECT 
        [Time].[Calendar].[Day].[7 Jan 2005]
      : 
        [Time].[Calendar].[Day].[10 Jan 2005] ON 0
FROM [Sales];

I would like to replace the fixed dates in the query by the from and to in the date picker. How to do that?

Solution

  • As it is mentioned above, IcCube Date Picker widget returns valid MDX value for range. Here is demo report with described configuration.

    For more details check Date Picker's settings and Pivot Table's mdx settings.