PM07414: [UPG] #!SECURITY IS DISPLAYED INSTEAD OF VALUES WHEN CREATE A AGGREGATE CALCULATION (USING CUBE WITH CUSTOM VIEW, APEX)

APAR status

• Closed as program error.

Error description

• PRE-CONDITION THAT THIS DEFECT OCCURS
  - Using a Power Cube as Datasource
  - Security is implemented in the Transformer model
  - Using views with APEX
  - A user belongs to multiple views, at least to two views with
  different APEX for the same dimension
  - using a aggregate calculation (default roll-up from
  datasource), in Analysis Studio this can be a total column for
  multiple member
  - Sample:
    --> To views for Dimension Sales Territory: Americas, Central
  Europe
    --> Apex on Americas for view Americs
    --> Apex on Central Europe for view Central Europe
    --> Americas is the parent member of Mexico
    --> Central Europe it the parent member of Switzerland
    --> User is assigned to both views
  
  PRODUCTS AFFECTED
  - IBM Cognos 8 BI Report Studio 8.4.1 (Refresh Pack 1)
  - IBM Cognos 8 BI Analysis Studio 8.4.1 (Refresh Pack 1)
  
  UPGRADE ISSUE - THIS ISSUE COULD NOTE BE REPRODUCED USING
  - IBM Cognos 8 BI 8.2 SP3
    -> C8BISRVR_UPDATE_version=C8BISRVR-AW-ML-RTM-8.2.46.4-0
    -> RSVP_version=RSVP-AW-ML-RTM-8.2.1265.0-0
  - IBM Cognos 8 BI 8.3 FP5
    -> C8BISRVR_UPDATE_version=C8BISRVR-AW-ML-RTM-8.3.86.6-0
    -> RSVP_version=RSVP-AW-ML-RTM-8.3.935.0-0
  - IBM Cognos 8 BI 8.4 FP2
    -> C8BISRVR_UPDATE_version=C8BISRVR-AW32-ML-RTM-8.4.29.13-0
    -> RSVP_version=RSVP-AW32-ML-RTM-8.4.2382.7-0
  
  DESCRIPTION (Analysis Studio)
  Years in the columns, 2 measures in the rows
  CTRL+Click the member Mexico, Switzerland and nest it (as one
  set) to the rows (right to the measures). A Total column will be
  displayed with #!Security
  
  DESCRIPTION (Report Studio)
  A calculation with the expression
  aggregate(currentMeasure within set [set(Mexico, Switzerland)])
  Will return
  #!Security
  

Local fix

• >> For Analysis Studio <<
  - place the dimension into the crosstab instead of using member
  - select the member, click the summarize icon and select sum
  
  >> For Report Studio <<
  - Use a total calculation instead of aggregate
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Cognos 8 BI 8.4.1 User using cubes with APEX as Datasource   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG8 BI ANALY S

• Fixed component ID

  5724W12AS

Applicable component levels

• RA10 PSN

     UP