Key (Not Compounded) object not present for Nav Attr in webi query

    Hi,

    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?

    Regards,

    Muthulakshmi Ramanathan

    Hi,Scenario: A Navigational attribute is added to the Master data InfoObjectOutcome 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 objectOutcome in webi: Formula works properly; but the Key Figures in the report becomes #UNAVAILABLEIs there any way how we can have Key (Not Compounded) value to be displayed for the Naviagtional attribute as well which can be used…

    Key (Not Compounded) object not present for Nav Attr in webi query

    Very Helpfull

    User Rating: Be the first one !
    Reviewer Asked on November 2, 2016 in businessobjects bi-for-sap.
    Add Comment
    1 Answer(s)

      Hi,

       

      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.

       

      Eg:

      JAN     FEB

      TOTAL ASSETS

      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!

      Add Comment

        Hi,

         

        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.

         

        Eg:

        JAN     FEB

        TOTAL ASSETS

        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!

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.