Key (Not Compounded) object not present for Nav Attr in webi query
Scenario: A Navigational attribute is added to the Master data InfoObject
Outcome in webi: Does not display the Key (Not Compounded) object for the Navigational attribute; Only Key and Text objects are displayed unlike the Master data object has Key, Key (Not Compounded) and Text objects.
Workaround which I followed: Use SUBSTR function to separate the Key (Not Compounded) value from the Key object
Outcome in webi: Formula works properly; but the Key Figures in the report becomes #UNAVAILABLE
Is there any way how we can have Key (Not Compounded) value to be displayed for the Naviagtional attribute as well which can be used in the BO report?