BW on HANA - Inventory Cube Optimized Cube issue

[former_member215766]

Hi All,

We have an inventory cube which works perfectly fine and we created a HANA optimized copy of the same cube. We sourced the Initialization from the original (non-HANA) cube, loaded data, and then we loaded the rest of the data from the corresponding DSOs (one for 2LIS_03_BF and one for 2LIS_03_UM).

In order to reconcile them, I opened both of them in BEx Analyzer. The original works perfectly fine, however the HANA optimized one, give me a error when entering the Fiscal Variant:

Error in BW: Time is not consistent.

Error reading the data of InfoProvider

Error while reading data; navigation is possible

I checked in RSDV and the validity dates are fine. When I check in RSRV I get the following errors when running "Test the partitioning column for InfoCube" and the "Consistency of time dimension for InfoCube". The return issues. If I try to repair the issues, I get the same error message.

An exception with the type CX_SY_DYNAMIC_OSQL_SEMA

Message no. RSRV000

Any clues?

[Prabhith]

Hi Busy waiting,

                       Please see if the following notes help you to solve the issue :

1999013 - RSRV - Initial key Figure Units in Fact Tables test results in exception

1953650 - RSRV - Fact tables and dimension tables of InfoCube results in exception error

BR