SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 36631: Passing values from an OLAP-based SAS® Web Report Studio report to prompts in a linked relational report

DetailsAboutRate It

Overview

For multidimensional crosstabulation tables, SAS Web Report Studio can pass the following values to a prompt in a target relational report:

  • values that are visible in the table.
  • group break or filter criteria, if the grouped or filtered data item is manually associated with the related prompt.

    Note: To pass group break or filter criteria, you must be using at least the second maintenance release for SAS® 9.2 (TS2M2).

The following two examples illustrate how visible values and applied filters are passed from an OLAP-based report.

Passing visible values

The following crosstabulation table is linked to a relational report that has a prompt for product category. Because the table is not drilled or expanded to show product categories, if you click the indicated cell, SAS Web Report Studio cannot pass values for product category to the linked report. In this case, the prompt window appears.

image label

The following crosstabulation table is expanded to display the Children Sports product category under the product group A-Team, Kids. If you click the indicated cell, then Children Sports is passed as the value for the prompt in the target report, and the prompt window is bypassed.

image label

Passing values for an applied filter

The following crosstabulation table is filtered to display information for Mexico and Canada.

image label

Although the Geo hierarcy is hidden in the table, the Geo.COUNTRY level is associated with the prompt for Country in the target report. As a result, if you click any cell, then SAS Web Report Studio passes Mexico and Canada as values to the prompt for Country in the target report.

image label

Passing group break values

For an example of passing group break values, see SAS Note 35642.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioMicrosoft Windows 2000 Advanced Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Server3.19.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.19.1 TS1M3 SP4
Microsoft Windows NT Workstation3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.19.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.19.1 TS1M3 SP4
Microsoft Windows XP Professional3.19.1 TS1M3 SP4
Windows Vista3.19.1 TS1M3 SP4
64-bit Enabled AIX3.19.1 TS1M3 SP4
64-bit Enabled Solaris3.19.1 TS1M3 SP4
HP-UX IPF3.19.1 TS1M3 SP4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.