• Print |
• E-mail  |
• Bookmark

When you have member level security applied to a dimension with more
than one hierarchy and a calculated member is requested in the current
view, you may receive the following error message in the SAS OLAP Server
log:

   Formula error - Access to member is not allowed

With the following Query example:

   with MEMBER [Geography].[CM1] AS
     '([Geography].[All Geography].[Asia],[Measures].[OrdersCNT])'
        SELECT [Geography].[CM1] ON rows,
          [Measures].[quantitysum] ON columns
        FROM [orionCube]
        WHERE {[time].[yqm].[all yqm].[2000].[2000q1]}

suppose the Time dimension has three hierarchies, YMD_EU (default), YQM,
YMD. The member level security expression for the Time dimension should
give access to at least the defaultmember in each hierarchy.

   {[Time].defaultmember}<!--CONDITION-->
   {[Time].[YQM].defaultmember}<!--CONDITION-->
   {[Time].[YQM].[all yqm].[2000]}<!--CONDITION-->
      descendants([Time].[YQM].[all yqm].[2000].[2000q1],
                  [time].[yqm].[quarter],
                  self_and_after)<!--CONDITION-->
      {[Time].[YMD].defaultmember}

The <!--CONDITION--> string is used to separate the different
conditions in the member level security expression.


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014670

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014670

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :