PI87619: IN CA 11.0.7, DYNAMIC CUBE NUMERIC MEASURES ARE SORTED ALPHABETICALLY AND NOT NUMERICALLY WHEN USED ON A DASHBOARD.

APAR status

• Closed as fixed if next.

Error description

• 1.     Publish the gosldw_sales from IBM Cognos Cube Designer
  11.0.7.
  2.     Open Cognos Analytics 11.0.7 on the browser.
  3.     Click on New option in the left side panel and select
  Dashboard.
  4.     Select any template and click OK.
  5.     In the side panel, click on the add icon beside Selected
  sources.
  6.     Select the gosldw_sales dynamic cube and click on
  Add.
  7.     Select month(numeric) and drag it to the dashboard. The
  months in number will load on the dashboard sorted
  alphabetically.
  8.     Click on the visualization with the numeric data on the
  dashboard.
  9.     Click on the  icon found on the top right corner of the
  box around the selected numeric data visualization.
  10.   This should open a window. Click on the three dots beside
  the numeric data name.
  11.   Choose the 'Sort' option.
  12.   Choose 'Sort ascending'. The numeric data is sorted
  alphabetically and will look like the attached
  image(Sort_Ascending.PNG).
  13.   Choose 'Sort descending'. The numeric data is sorted
  alphabetically and will look like the attached
  image(Sort_Descending.PNG).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytic 11.0.8.0                      *
  ****************************************************************
  

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

• RB07 PSN

     UP