Skip to Content
0
Former Member
Dec 05, 2008 at 05:04 PM

Error getting hierarchies for dimension

222 Views

Hello:

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.

4.Hit OK.

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

-Thank you