none
Using hierarchy attribute in where clause! ERROR

    Question

  • Hi,

    I'm currently working on a report where I'm using a where clause in my MDX querry on the "ID" hierarchy, but also would like to show the ID in the report (table/matrix) in the ON COLUMNS part.

    As I read it is not possible to use a slicer in an axis hierarchy, so I used a workaround by putting the lower granularity (attribute) in the where clause. This workaround works in my MDX query BUT does not work when I convert the querry for my reporting! I get the same error again

    ON COLUMNSNON EMPTY

    {

           Filter(

                 NonEmpty(

                        [Wager].[Wager number].[Wager number],

                        [Measures].[Payment amount]

                 )

                 * [Date].[Date].[Date]

                 ,

                 [Measures].[Payment amount] > Cdbl(@PAR_Payment_Amount)

           )

           * [Point of sale].[POS default connection].[POS default connection]

    ...

    WHERE
    {
    [Point of sale].[Regional office].&[22]
    * {[Date].[Calendar - Bonus Program].[Invoice week].&[2014]&[06],[Date].[Calendar - Bonus Program].[Invoice          week].&[2014]&[07]}
           * {[Point of sale].&[10005397],[Point of sale].&[10005397]}
    }

    --> In my report MDQ query designer 

    WHERE

    {

           {StrToMember(@PAR_Regional_Office)}

           * StrToSet(@PAR_Year_Week)

           * {StrToSet(@PAR_ClientID)}

    }

    Any suggestions?

    Thursday, June 26, 2014 11:54 AM

All replies