Overview

SAS^® 9.2 introduced a new user interface for defining member-level security within a SAS^® OLAP cube. This interface enables you to point and click to define a security condition. However, if your condition begins the security at a level beyond the first user-defined level in the cube (see below for an example), the generated expression is incomplete and might result in errors or a traceback in the SAS^® OLAP Server log.

Example

For example, consider a dimension named Example, which has the levels, A, B, and C. Security is placed on the first member of the B level, which is A1.B1, granting access to the member and its descendants at the C level. This results in a security condition that looks like this:

   {[Example].[All Example],
    [Example].[All Example].[A1].[B1],
    Descendants([Example].[All Example].[A1].[B1])}

This condition would enable users to access only the All Example member because there is a break between the All Example member and the A1.B1 member. To provide the correct results, you would modify this expression to include the A1 member:

   {[Example].[All Example],
    [Example].[All Example].[A1],
    [Example].[All Example].[A1].[B1],
    Descendants([Example].[All Example].[A1].[B1])} 

Workaround

In order to use the cube in SAS^® Web Report Studio, you must manually modify the expression to add the missing levels as explained in the example. Otherwise, reports display "No values were returned for this table" for users who are affected by the security expression. The SAS OLAP Server log does not list any errors. There is no hot fix that resolves this issue in any release.

If you are using the cube in SAS^® Enterprise Guide with SAS 9.21, then you can apply the hot fix from the Hot Fix tab in this SAS Note. The hot fix resolves the SAS OLAP Server error, and the security is successfully applied even with a missing level. If you are using 9.2_M2 or later, then you do not need to apply the hot fix. The OLAP Server error is resolved and the security is correctly applied even with a missing level.

Operating System and Release Information

A fix for this issue for Base SAS 9.21 is available at: