1907423 - Fixes on handling time type dimension for HANA MDX support

Symptom

Before applying this note, following issues may happen in BPC if HANA MDX is enabled on corresponding BPC models:

1. If the names of dimension members at the same level in time type dimension are in different orders when sorted in alphabetical order and sorted by year & base period, the reports may display wrong data due to wrong closing period calculation.

2. When displaying a report, if the time type dimension does not appear on row or column axis meanwhile the data region to be retrieved containing member formula calculation referring to a data region containing transaction data, the report display may fail with error.

Other Terms

Time type dimension, HANA MDX, Member sequence, Closing period

Reason and Prerequisites

Resolving HANA limitations

Solution

Upgrade to HANABPC 800 SP06 or apply the note to HANABPC 800 SP05 on Netweaver 730 platform.

Upgrade to HANABPC 801 SP03 or apply the note to HANABPC 801 SP02 on Netweaver 731 or Netweaver 740 platform.

Follow the manual implementation steps after applying the note.

In addition, if user has already defined master data of a time type dimension that meets the condition mentioned in point 1 in Symptom section, insert BPC environment level IMG parameter 'HANA_NUMERIC_TIME_INDEX' using transaction SPRO and set the parameter to value 'X' in order to adopt HANA MDX functionality correctly.

------------------------------------------------------------------------
|Manual Post-Implement.                                                |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   HANABPC                                          |
| Release 800          SAPK-80005INHANABPC - SAPK-80005INHANABPC       |
| Release 801          SAPK-80102INHANABPC - SAPK-80102INHANABPC       |
------------------------------------------------------------------------

Execute the steps below after applying this note:

1. Enter transaction code SM30.
2. In field 'TABLE/VIEW', fill in 'UJ0_PARAM_CHECK'.
3. Click on 'Maintain' button.
4. Click on 'New Entries'.
5. Fill in 'HANA_NUMERIC_TIME_INDEX' in 'Field Name' Column and 'CL_UJHANA_MODEL_NTI_CHECKER' in 'Reference to' Column.
6. Click on 'Save' button.

7. Enter transaction code SE91.
8. In 'Message Classes' enter 'BPC_UJHANA_MODEL_EXP'.
9. Click on the 'Change' button.
10. Create message with message number 406.
11. Enter the message 'Fail to roll back original HANA tables and models'.
12. Create message with message number 407.
13. Enter the message 'Invalid parameter value for HANA_NUMERIC_TIME_INDEX'.
14. Save the change.