RE: 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?
Create a variable with Qualification as Measure with your Formula. Use this variable in the block, instead of formula applied directly in the block. It should work.
I believe the corresponding Dimension is used beside this Variable which is of Measure type.
G/LText123 16360111 250 1205
G/LText456 17856945 700 1425
Here, Month is the Column Header of the crosstab,
G/L Account Text is the First Row Header (Eg: G/LText123),
G/L Key is Second Row Header (Eg:16360111) and
[Revenue] in the body.
i have used Replace() function in my case like Replace([G/L Account Key];”YAIN/”;””). Replaced the Text YAIN/ with empty space.
Hope it helps!