Adding MDX Parameterization

  • Article

In the MDX query created in Step 1, add parameter tags using the [$paramName] syntax. The ReportRender object treats these parameters as macros.

For more information about the available parameters, see Analysis/Reporting Schema.

Step 2

MDX Query =

"SELECT {[Measures].[Visits], [Measures].[Requests]} ON COLUMNS,

  [$TopCount]({[Referrer].[Referrer Domain Name].members}, [$TopCount],

  [Measures].[Visits]) ON ROWS

** FROM** [Web Usage]

** WHERE** ([$SiteName])"


All rights reserved.