12 Replies Latest reply on May 21, 2015 7:05 PM by Brad Welch

    Mdx Parameter

    Juan Pablo Caballeros

      Hi everyone!

      I was trying to create a dynamic TopCount connected to SQL Analysis Services.

      I have a parameter (Param_A) with the possible months values, and I also have created a calculated member (Member_A) that gives me the sales value for a specific month.

      What I want to do is to create a dynamic topcount of products by choosing the month on wich the topcount of sales will be calculated.

       

      So, Param_A will "feed" Member_A, so that an mdx expression could be built and then execute the query.

       

      But in the Calculated Members window I can't associate the parameter value with my MDX.

       

      Thanks!