IBM Support

PM80460: COGNOS BI 10.2 CROSSTAB REPORT AGAINST TM1 DATA SOURCE GIVES UNXPECTED RESULTS AND BEHAVIOR WHEN REFRESHING PROMPT SELECTION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Cognos BI 10.2 crosstab report has three prompt controls, value
    prompt and two tree prompts. Prompts represent members from
    different dimensions in a TM1 cube. Each prompt object has
    corresponding detail filter in crosstab query. When report is
    run and desired prompt value selected from first prompt (single
    value drop down prompt) xtab report automatically refreshes ok
    and show correct result set. However, when further selections
    from tree prompts are made and report is refreshed using button
    control, xtab shows unexpected results:??  1) Filter context
    defined in first prompt is lost and report shows members outside
    the 1st filter context on row edge.  ?  2) Filter context for
    second prompt is not applied and report shows members outside
    the 2nd filter context on row edge.?  3) First of the measure
    column shows empty values for members that are within the
    context of 2nd filter. 2nd column still shows values for all
    members.??When report is opened in Report Studio and order of
    the detail filters in a crosstab query is changed to correspond
    order of the prompt control manifestation, context of the 1st
    filter is applied in a report and values in a first measure
    column are shown. However, after selecting second available
    option only from 2nd prompt (tree prompt) and refreshing report,
    this selection does not get applied correctly and row edge shows
    members that belong to the context of earlier slection in 2nd
    filter.??Tested in:?- Windows Server 2008 64bit.?- Cognos 10.2
    typical installation ?- TM1 10.1.1 FP 1 64 bit?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM Cognos TM1 10.2                        *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM80460

  • Reported component name

    COG VIEWER

  • Reported component ID

    5724W12CV

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-11

  • Closed date

    2013-09-12

  • Last modified date

    2013-09-12

  • 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 VIEWER

  • Fixed component ID

    5724W12CV

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRGH9","label":"Cognos Viewer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 September 2013