Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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.

1. In SAS Management Console, expand Application Management ► Configuration Manager.
2. Right-click on Web Report Studio 4.2, and select Properties.
3. In the Properties dialog box, click the Advanced tab.
4. On the Advanced tab, click Add.
5. In the Define New Property dialog box, complete these steps:
1. For the Property Name, enter com.sas.iquery.strategies.sas.oma.olapv2.
2. For the Property Value, enter DEBUG.
6. 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