All,
We have created an universe based on a BEx query. The Universe contains Org Unit Hierarchy which has 13 levels. We have developed around 8 reports with this 13 level Org Unit Hierarchy a month ago and it was working fine. But for the last 2 days, we got below issues:
1) I am getting an error "Error at MDDataSetBW.GetCellData. Systems error in programm CL_RSR_MDX_BXML_FLATTENING and form ASSIGN_COMP-02 (WIS 10901)".
2) If I don't get the above error, I used to get data values jumped in columns, for example., Gender values are also seen in Line of Business or in Ethnicity, etc.,
3) Sometimes we don't get error like point 1 and 2, but the key figure numbers varies. for eg., if I run the WebI report without Org unit 13 level Hierarchy I get total employees as 20,000. If I add the hierarchy levels I get total employees as 11,000.
Looks like Hierarchy is creating issues in the report. Somehow I get one of the above three issues in the reports.
Below are the steps we have followed:
1) Gone through some SAP OSS Notes like 1440912, 1432162. All these notes suggest to have package as SAPKW70107. And our BW environment has this support package - SAPKW70107
2) I have created a new universe on top of the same BEX query and created a new report, still we see the issues.
We were testing these reports for the past 1 month, but we haven't get these issues that time. We are very close to our UAT(next week) and we got the issues now.
BO Environment: Version12.3.2 Build: 753
Let me know if any one got these issues and steps to resolve.
Thanks in advance,
Jai