I have a master data object 0PROFIT_CTR into which I've loaded hierarchies. The user wants this to be available in a query which is based on a cube that has 0PROFIT_CTR as a navigational attribute of another object. I am thinking of creating an infoset with the cube and 0PROFIT_CTR master data object (and a new query on top of it). Will this work? Or is there a better way to provide the profit center hierarchy since 0PROFIT_CTR exists in the cube, although only as a navigational attr.
Also, Profit center is compounded to Controlling area. In the cube, I have 0COSTCENTER which is also compounded to Controlling area. In the Infoset, can I link the Infoobject with the Infocube through Controlling area?