PH40515: CA 11 ISSUE WHEN EXPANDING DIMENSION MEMBER IN DQM PACKAGE WHEN THERE ARE EMPTY STRING ENTRIES IN COLUMN ON DATABASE SIDE.

APAR status

• Closed as documentation error.

Error description

• Issue when expanding Dimension member in DQM package when there
  are empty string entries in column on database side:
  
  when user try to expand and see members under "CT undefined"
  users getting error:
  
  XQE-QRY-0406 At least one invalid member reference was
  encountered in the query
  "[Model_Name].[dimension_name].[dimension_name].[dimension_level
  _having_empty_string]->[all][]"
  
  After canceling error user try to expand and see members under
  "dimension_level_having_empty_string", which is from database
  table column where row entry in column has empty sting, user is
  not able to see members which have empty sting, click on and
  expanding dimension member does not provide expected list of
  items
  
  In Analysis studio when selecting and placing
  "dimension_level_having_empty_string" into rows and trying to
  expand, drill down, there is no option to drill down.
  
  Although if top parent member is added to the rows in Analysis
  studio and if expand action is performed from the top by right
  click on row header and selecting "Expand..." then members under
  "dimension_level_having_empty_string" which contain empty
  strings are getting listed and showing as available.
  
  This used to work in Cognos 10.2.2
  

Local fix

• Replacing, (populating), empty string for
  "dimension_level_having_empty_string" on database side with
  substitute string like for example "-1", resolves this issue and
  may present potential workaround.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The documentation should actively encourage users to not use *
  * columns or expressions that return null values, zero-length  *
  * strings, or strings containing spaces to construct a member  *
  * unique name.                                                 *
  *                                                              *
  * Instead, a non-null and non-zero length value should be used *
  * instead of those values.                                     *
  *                                                              *
  * For example, the expression coalesce ( C1 , 'ABC' ) would    *
  * return 'ABC' whenever C1 contains a null value.              *
  *                                                              *
  * For example case when char length (C1) = 0 then 'ABC' when   *
  * C1 = ' ' then 'ABC' else C1 end, would return 'ABC' if the   *
  * value of C1 is a zero length character string or one or more *
  * spaces                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Documentation updated
  

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