PM78248: AUTO GENERATED PROMPT FOR VARIABLE IN ELSE STATEMENT IS DISPLAYED IN DQM

APAR status

• Closed as fixed if next.

Error description

• Customer's report uses following expression in query.??if (?A? =
  'a') then ([] = ?B?) else ([] = ?C?)??In prompt page,
  conditional block for ?A? is used. In conditional block for ?A?
  = 'a', prompt for ?B? is included and conditional block for ?A?
  = 'aa' includes pPrompt for ?C?.?In CQM, it works as expected
  (No auto generated prompt is displayed.)?In DQM, after "finish"
  button is clicked on prompt page, auto generated prompt for ?C?
  is displayed in case ?A? = 'a'??DQM Report should work same as
  CQM.??With SQL syntax definition, "then" clause should evaluated
  when condition met only, and "else" condition should evaluated
  when condition have not met only. In MDX syntax definition, it
  allows "then" clause only, not also "else".?
  

Local fix

• If prompt for ?C? with default value  is inserted in conditional
   block for ?A? = 'a', auto generated prompt is not displayed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Customer can't create necessary minimum prompt.              *
  * To workaround the issue, dummy prompt is necessary. It makes *
  * additional work for report creator to keep paying attention  *
  * for maintenance of report.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1  or Upgrade to IBM Cognos Business Intelligence 10.2  *
  * Fix Pack 1 or IBM Cognos Business Intelligence 10.1.1 Fix    *
  * Pack 3                                                       *
  ****************************************************************
  

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

• RA21 PSN

     UP