We have an issue when trying to create an Universe based on a Bex query. Specifically when we have 0MATERIAL object which has hierarchy attached to it.
If we remove the 0MATERIAL object it all works fine.
On BW side we did fix all the SID issues.
Here are the detailed steps
1.Create a Query in Bex
2.Query has 0MATERIAL info object that has hierarchy attached to it.
3.Create a Universe in BOJ,
u2013 Input connection parameters
u2013Select the Bex query as the data source.
Error in BOJ:
u201CError getting hierarchies for dimension 0MATERIAL (Cube 0SD_C03/TEST_123): See RFC trace file or SAP system log for more detailsu201D
SAP gateway RFC trace file is 15 mb but the main information of the error is
"CL_RSR_HIERARCHY_BUFFER and form INCLREAD_DB"
Can anyone please share their experience in this situation