PM87097: UNABLE TO CREATE CUBES IN BATCH USING OPTIONAL MULTI PROMPTS IN MODEL

APAR status

• Closed as fixed if next.

Error description

• A Transformer model based on a report datasource, which has
  optional multi prompts, successfully generates a cube when run
  in the Transformer GUI, but fails with errors when running
  Transformer in BATCH.??The Transformer log file has the
  following errors:??(TR0646) Column or filter 'Country' is based
  on reference '[Report].[Query1.0].[Country]' which cannot be
  found in package or report 'OMP'.??(TR0646) Column or filter
  'Retailer' is based on reference
  '[Report].[Query1.0].[Retailer]' which cannot be found in
  package or report 'OMP'.??(TR0646) Column or filter 'Quantity'
  is based on reference '[Report].[Query1.0].[Quantity]' which
  cannot be found in package or report 'OMP'.??(TR0649) One or
  more columns or filters cannot be found in datasource 'OMP~1'.
  [->OK]?
  

Local fix

• Generate cubes through the Transformer GUI rather than in Batch,
   but this is not feasible for this customer.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Production - Lots of cubes waiting to be built that are      *
  * required for business use.                                   *
  ****************************************************************
  * 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

• RA21 PSN

     UP