Hello SAP Experts,
While trying to use Parent-Child Hierarchy from a calculation view analysis for MS-Office I am getting an error as follow:
(ERROR [S1000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;2048 column store error: search table error: [6991] Each predecessor (except the root node) must also appear as a successor.
In order to re-generate the error please follow the steps below:
- First, open calculation view containing a Parent-Child hierarchy in the analysis for MS office.
- Now when you will drag the Parent-Child hierarchy to the row you will notice the error mentioned above.
Please help me resolve this error.
Each and every Parent/Child node in the hierarchy must be shown in the final query result. The Parent/Child node table was doing the left-outer join inside the calculation view but some of the Parent/Child nodes were removed because of later joins. Therefore In order to resolve this error please move the left-outer join of the Parent/Child node table to the last steps of the calculation view which will prevent removal of Parent/Child nodes during other joins.