PM86101: DYNAMIC CUBE SECURED MEASURES EXPOSED IN VIRTUAL CUBE

APAR status

• Closed as fixed if next.

Error description

• A Virtual Dynamic Cube will expose all measures from the Base
  cubes when one of the base cubes does not have security
  applied.??Base Cube 1 has some measures say Purchase and Amount.
   Permissions is granted to the Purchase measures for the
  Purchasing group.??Base Cube 2 is similar to Base Cube 1 with
  additional Purchase and Amount measures.  Again, permissions is
  granted to the Purchase measures for the Purchasing
  group.??These cubes are combined into Virtual Cube 1.?Purchasing
  User accessing Virtual Cube 1 will see all the Purchase measures
  but none of the Amount Measures.  This is as expected.??Base
  Cube 3 has Quantity measures and does not have security applied.
   Purchasing user accessing this cube will be able to see all the
  Quantity measures.  This is expected.??Combine Virtual Cube 1
  and Base Cube 3 into a new Virtual Cube and Purchasing user
  accessing this cube will see all the Purchase, Amount and
  Quantity Measures.??They should not see the Amount Measures.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users who have access to Secured Virtual Dynamic Cubes.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels