IBM Support

PM91904: Security model filter is not being honored for DMR models against dynamic query mode

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Within IBM Cognos Framework Manager, a modeller can restrict the
    data represented by query subjects in a project by creating
    security filters. These security filters can be embedded within
    the SQL of a Data Source Query Subject or defined as filter
    object on a Model or Data Source Query Subject.  These security
    filters are usually created using the Session Parameters via
    macro expressions in order to restrict the data based on the
    user who is running the report.  A defect has been introduced
    within the IBM Cognos BI 10.2.1 Dynamic Query Mode(DQM) where a
    Dimensionally Modelled Relational(DMR) model, which utilizes
    session parameters via macro expressions, to restrict the data
    may display data for another session parameter value.  This may
    result in a user being presented with data from another user
    that they do should not have access to.
    

Local fix

  • The following workaround is available for this defect: 1  On eac
    h of the dispatchers in the environment, locate and backup the c
    onfiguration/xqe/dmr.properties file. 2  Open the dmr.properties
     file using a text editor. 3  Locate the entry which reads:  blo
    ckingPrePlanSameMetaDataObjects=true 4  Change the true value to
     false.  When completed, the changed entry should read:       bl
    ockingPrePlanSameMetaDataObjects=false 5  Save the changes and c
    lose the file. 6  Stop and Restart the IBM Cognos BI Service.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 1 or Upgrade to IBM Cognos Business Intelligence 10.2        *
    * Refresh Pack 2                                               *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM91904

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-26

  • Closed date

    2013-09-10

  • Last modified date

    2014-11-27

  • 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

    COG REPORT STUD

  • Fixed component ID

    5724W12RS

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
27 November 2014