0

Sending Parameters to a URL of a Data Discovery (formerly bioXL) Book

The following article explains how to send parameters to a URL from an external application.
This is a simple example of opening a URL and passing the cube parameter named “Manufacturer”:

A normal bioXL report URL without any parameters should look like this:

http://PYRAMID_URL/default.aspx?bookid=ff8b56b7-93ea-4cd2-82ee-2682cab438a3|ispasFalse|reporte36b2411-8b1f-46da-9971-1f7a1e0d9d8b|ws0|wsb0|isDisabledAnalyticsTrue|isDashboardPanelOnTrue

To open the same report with a parameter named “Manufacturer”, an expression should be added to the end of the URL (marked in green):

http://PYRAMID_URL/default.aspx?bookid=ff8b56b7-93ea-4cd2-82ee-2682cab438a3|ispasFalse|reporte36b2411-8b1f-46da-9971-1f7a1e0d9d8b|ws0|wsb0|isDisabledAnalyticsTrue|isDashboardPanelOnTrue|expr=%3CM%3E%5BManfucaturer%5D.%5BManufacturer%5D.%26%5B103%5D%3C/M%3E

The expression in the URL includes characters that were encoded according to HTML URL encoding standards.

Examples:

• “&” is encoded to “%26”
• “[“ is encoded to “%5B”
• “]” is encoded to “%5D”
• ”<” is encoded to “%3C”
• ”>” is encoded to “%3E”

 

The original expression before replacing encoding characters is based on the standard MDX syntax:

 |expr=<M>[Manfucaturer].[Manufacturer].&[103]</M>

Attached is a screenshot of the report opened via URL after sending the non-default parameter “ESICS” to the Manufacturer slicer.

 

For a more information on how to build a URL with parameters, please refer to our online help that can be found here: http://help.pyramidanalytics.com/client5/en/Content/CMS/Parameteriz...

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 yr agoLast active
  • 640Views
  • 1 Following