Overview

This sample shows you how to create a link that passes filter values from SAS BI Dashboard to an OLAP-based SAS Web Report Studio report.

In order for the SAS^® OLAP Server to resolve the report filter, the full OLAP path (unique name) of the filter value must be passed to SAS Web Report Studio. In an OLAP cube, the full path to a level is [Dimension].[Hierarchy].[All Member].[Level]. The following display is created from the sample Orion Star cube. In this example, the Customer Group display value is Orion Club Gold members. The Customer Group full OLAP path (unique name) is [Customers].[Customers].[All Customers].[Orion Club Gold members].

Note: Although you can create a new OLAP category data item in SAS^® Information Map Studio, this type of data item is treated as a measure. If you reference an OLAP category data item in an indicator data, you see an "unparseable number" error.

This sample is for advanced users. It assumes that you are proficient using SAS BI Dashboard, SAS Web Report Studio, and SAS Information Map Studio.

About the sample data and software versions

This sample was written using the following software versions:

• SAS BI Dashboard 4.31_M2
• SAS Web Report Studio 4.31
• SAS Information Map Studio 4.31

This example uses a SAS OLAP cube created from the Orion Star sample data.

About the sample steps

This sample shows you how to perform these steps:

1. Create an information map with a filter that is based on an OLAP cube.
2. Create a filtered report using the information map in Step 1.
3. Create a data table from an OLAP cube that includes the full OLAP path for the value that is used to link the dashboard to the report.
4. Create a dashboard that links to a filtered report.

The following sections review these steps.

Create an information map with a filter that is based on an OLAP cube

Using SAS Information Map Studio, create an information map that is based on the Orion Star cube. Include a prompted filter for Customer Group, and be sure to provide a default value. The following displays illustrate the process.

Create a filtered report using the information map

Use SAS Web Report Studio to create a filtered report based on the information map that you created previously. The following displays illustrate the process.

Create a data table from an OLAP cube that includes the full OLAP path

Create a data table from an OLAP cube that includes the full OLAP path for the value that is used to link the dashboard to the report. Here is sample code that you can use to create a data table from Orion Star.

Be sure to include PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME in the SQL query. Including PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME is required for the following tasks:

• retrieving the fields that are necessary to display values in the dashboard (MEMBER_CAPTION).
• linking to the report (MEMBER_UNIQUE_NAME).

These fields in the wrs.OrionStar_CustomerGroup table are needed for this example:

The following display shows the table created from the Orion Star cube:

Create a dashboard that links to a filtered report

Here are the created dashboard objects.

Note: The BID_WRS library reference must be pre-assigned for the pooled workspace server to use this library with the SQL source type.

Here are the specific steps for this task.

1. Create an indicator data for the spark table.



2. Create an indicator data for the year dynamic prompt. (This step is not required for the dashboard to link to the report.)



3. Create the spark table indicator that links to the filtered report.



Note: Be sure to use the displayed text for the prompt when defining the link to the report.



4. Create a year dynamic prompt to subset the spark table. (This step is not required for the dashboard to link to the report.)





5. Create the dashboard. (Using the dynamic prompt to filter the spark table is not necessary to link to a report. This functionality is included in this example to show that you can link to a report from a filtered indictor.)





6. Run the dashboard and link to the web report. Selecting a value for the year prompt filters the spark table.

The results

The following display shows that you can now click on a customer group in the spark table in order to display a report that is filtered by the selected customer group.

Additional documentation

For more information about creating cubes, see the SAS OLAP Server and SAS OLAP Cube Studio documentation pages.

For a list of available documentation for SAS BI Dashboard, see the SAS BI Dashboard documentation page.

For more information about SAS Web Report Studio, see the SAS Web Report Studio documentation page.

For more information about SAS Information Map Studio, see the SAS Information Map Studio documentation page.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information