pass olap parameters thru url

• Christina Tabet

  SSC Enthusiast

  Points: 172

  More actions

  October 19, 2005 at 8:28 am

  #111102

  hi. i have a report based on a cube and want to pass parameters to it through url. the parameters are in the form of uniquenames.

  how do i do that?

  thanks

• Phil.Nicholas

  SSCrazy

  Points: 2147

  More actions

  October 20, 2005 at 3:50 am

  #598601

  change the mdx query to a string & you have to build up the mdx by inserting your dimension names.

   

  e.g. "select measure on axis(0), [dim].[" & param1.value & "] or axis 1 from mycube"

   

  param 1 can come from another mdx query, similar to above which returns all members of the dimension level you need...

  
  Phil Nicholas