Hello @shannkar and welcome to B B.
I recategorized your post to the server administration category as it is not really about developing with the SDK but creating a report against the SAP provided universe over the CMS. I didn’t want to categorize it to report writing either because it has more to do with deciphering what the SAP developers created.
I don’t have a clear answer for you. What I have found is that using Query Builder helps me to better understand the relationships between the data to figure out which Relationship tier in the universe contains the data I’m looking for. From there is seems to be a matter of experimentation to get the information you want. The universe is not intuitive in any way.
In fact, if you are just looking for a quick one report check for a Crystal Report data source, using Query Builder may be your best option.