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

Error getting hierarchies for dimension



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


Can anyone please share their experience in this situation

-Thank you