Article ID: 927922 - View products that this article applies to.
This article describes how to use the Value property to pass a URL parameter from a ProClarity Dashboard Server dashboard to a Microsoft SQL Server Reporting Services report.
ProClarity Dashboard Server and SQL Server Reporting Services do not interpret an ampersand character (&) the same way. This difference prevents you from using the Value property to pass the URL parameter.
To identify an individual member, ProClarity Dashboard Server adds the "&" character to a Multidimensional Expressions (MDX) tuple. For example, the following MDX tuple expression identifies the member for a specific calendar month:
[Time].[Calendar].[Month].&However, SQL Server Reporting Services interprets the "&" character as a method to separate parameters that are sent in a URL. Therefore, SQL Server Reporting Services parses the URL and interprets the "&" character as a parameter separator instead of a member identifier.
To use the Value property to pass a URL parameter from a ProClarity dashboard to a SQL Server Reporting Services report, create a ProClarity Analytics Server (PAS)-based briefing book that references the member key as a measure. Then, use this book page to build a PAS results parameter in the dashboard. When you use this method, the member key is passed into the Web URL as a parameter to feed into the SQL Server Reporting Services report.
The following procedure illustrates how to create a new measure that references the member key property of the current member of the Time dimension.
Note If you add this new measure to a view, you provide a reference for a PAS results parameter. You can use this reference in the dashboard.
To do this, follow these steps:
To test the returned result, follow these steps in the ProClarity client.
After you publish the book, open Dashboard Studio to create a new parameter. This parameter will be of type PAS page result and will reference the newly created briefing book page. Save this parameter. In this example, assume that you save the parameter as "time." On the view that you use to reference the Reporting Services report, pass "&[[time.timekey]]" into the Web URL. For example, specify the following dashboard URL:
http://ServerName/ReportServer$InstanceName/Pages/ReportViewer.aspx?%2fSampleFolder%2fReportName&rs:Command=Render&[[time.timekey]].The member key is passed into the Web URL as a parameter to feed into the Reporting Services report.