Usage Note 39937: Enabling logging to capture selected filter values for a parent-level filter defined in an OLAP-based information map
Starting with SAS® 9.2, you can create parent-level filters in an OLAP-based information map that can be used by SAS® Web Report Studio. Sometimes, you might want to capture the values selected for the parent-level filter. In order to capture these values, you must enable a logging option in SAS® Management Console. Following are the steps.
- In SAS Management Console, expand Application Management ► Configuration Manager (► SAS Application Infrastructure).
- Right-click on Web Report Studio 4.x, and select Properties.
- In the Properties dialog box, click the Advanced tab.
- On the Advanced tab, click Add.
- In the Define New Property dialog box, complete these steps:
- For the Property Name, enter
com.sas.iquery.strategies.sas.oma.olapv2.
- For the Property Value, enter
DEBUG.
- Restart Remote Services and your Web application server for this change to be enforced.
After you have entered this property, follow the instructions in SAS Note 36728 to enable OLAP Server logging. When you run the query again, the OLAP Server log will contain an entry similar to the following that documents the values selected:
commandStmt= FILTERED_TOTAL ADD [PRDSALES] [GeoDim].[GeoDim].[GeoDim] '{Descendants([GeoDim].[All GeoDim].[GERMANY])} '
|
Operating System and Release Information
| SAS System | SAS Web Report Studio | Solaris for x64 | 4.2 | | 9.2 TS2M0 | |
| Linux for x64 | 4.2 | | 9.2 TS2M0 | |
| HP-UX IPF | 4.2 | | 9.2 TS2M0 | |
| 64-bit Enabled Solaris | 4.2 | | 9.2 TS2M0 | |
| 64-bit Enabled AIX | 4.2 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
*
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.
| Type: | Usage Note |
| Priority: | |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2012-09-07 14:44:16 |
| Date Created: | 2010-06-09 10:17:34 |
