0GL_account hierarchy load successfully but Not showing in Bex Query in BW Modeling tool.

[SwatiYadav_12]

Hello everyone,

I am excited to share my first article with you.

I was doing a development on 0GL_Account hierarchy node in Bex Query in BW Modeling tool I've come across a strange issue that needs addressing. Here's the problem and solution.

I am sharing this solution in the hope that it will be helpful😊

problem

In RSH1 are able to see the levels of 0GL_Account hierarchy but while creating a Bex query hierarchy contains some levels and not all are visible to restrict and some GL accounts are appearing under a dimension (like REST_H) that are not available to restrict in Bex query.

Solution

window> preferences > BW modeling > Query designer

Change the maximum number of levels as per your requirement.

Refer below SAP note for your reference.

https://userapps.support.sap.com/sap/support/knowledge/en/2933554

Thanks & Regards,

Swati 

[RaymondGiuseppi]

You posted in Q&A area, so this is not a blog 🤔

• SAP Community/Products and Technology/Technology/Technology Q&A

• SAP Community/Products and Technology/Technology/Technology Blogs by Members