Unavailability of Key (Not Compounded) Attribute in BEx query

    Hi Experts,

    I have created web intelligence reports out of BEx queries.

    In that, I have used Key (Not Compounded) attribute of certain Master InfoObjects in the webi report display.

    I was able to get expected data in those columns in my report in our DEV environment.

    The same reports were migrated to PROD.

    After migration, when I refreshed the reports, am getting #SYNTAX error for all Key (Not Compounded) columns in the reports as these Not Compounded disappear from the query.

    Not sure why the Not Compounded attributes which were available in DEV were not present in PROD.

    I have compared the Properties at individual query level between DEV and PROD and found to be matching.

    Please advise if there is any setting to be done globally in BW side (InfoProvider/Cube level) to display them.

    Thanks in advance!

    Regards,

    Muthulakshmi Ramanathan

    Hi Experts,I have created web intelligence reports out of BEx queries.In that, I have used Key (Not Compounded) attribute of certain Master InfoObjects in the webi report display.I was able to get expected data in those columns in my report in our DEV environment.The same reports were migrated to PROD.After migration, when I refreshed the reports, am getting #SYNTAX error for all Key (Not Compounded) columns in the reports as these Not Compounded disappear from the query. Not sure why the Not Compounded attributes which were available in DEV were not present in PROD.I have compared the Properties at individual…

    Unavailability of Key (Not Compounded) Attribute in BEx query

    Very Helpfull

    User Rating: Be the first one !
    Add Comment
    1 Answer(s)

      Hi,

       

      which explains it. You comparing different versions and the item you are looking for is only coming with SP05

       

       

      regards

      Ingo Hilgefort

      Add Comment

        Hi,

         

        which explains it. You comparing different versions and the item you are looking for is only coming with SP05

         

         

        regards

        Ingo Hilgefort

        Add Comment

        Your Answer

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