none
Report with parameters in ssrs with OLAP cube data

    Question

  • Hello,

    I have written the follwoing MDX in a report:

    SELECT NON EMPTY { [Measures].[Sales] } ON COLUMNS,
    NON EMPTY { [Dim Date].[Date Hierarchy].[Month].select
    {} on 0,
    [Dim Date].[Date Hierarchy].[Month] on 1
    from
    [Cube][" & Parameters!From.Value & "] :[Dim Date].[Date Hierarchy].[Month].[" & Parameters!To.Value & "] } ON ROWS FROM [Cube]

    The available values of the parameters From and To are taken from the following mdx:

    select
    {} on 0,
    [Dim Date].[Date Hierarchy].[Month] on 1
    from
    [Cube]

    The values of tthe Month memeber of the DateHierarchy are: January 2009, Febryuuary 2009,...,Januray 2010 etc.

    When i run the first MDX i get nothing as a result. Is there something wrong with the from to expression that io have written?

    Thnaks in advance,

    Andreas

    Thursday, May 10, 2012 10:09 AM

Answers