OTBI Report subject area to include all shared category hierarchies of an item in our Report

Summary:

Need OTBI Report subject area to include shared category hierarchies of an item in our Report

Content (required):

We attempted to use the "Inventory - Inventory Transactions Real Time" subject area for our OTBI report creation. However, we were only able to retrieve the first level of category names, and the remaining levels were not found.

Could you kindly advise us in including all shared category hierarchies, in our report? Thank you!

Version (include the version you are using, if applicable):

PROD - instance (23A) 

Code Snippet (add any code snippets that support your topic, if applicable):

Eg :

Only one level is displayed in the Category name, not all levels. Currently, there are three levels available for this particular item.