Skip to Content
avatar image
Former Member

Dynamic header for report columns

Hi All,

We have a requirement in BEx report, wherein need to have dynamic header in the output for same attribute of 2 characteristics.

Eg. 0EMPLOYEE has "Address Line" as one of the attributes and 0PERSON as well has "Address Line" as one of the attributes.

User when he wants to drill down based on 0EMPLOYEE wants to have the column header as Office Address Line and when drills down based on 0PERSON wants  to have the column header as Home Address Line.

Please advise,

Regards,

Sunil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 30, 2014 at 07:27 PM

    Hi Sunil,

    As I understand you requirement correctly.

    0EMPLOYEE - 0PERSON  -- >   1


    0SOMEINFOOBJECT  - 0PERSON  -- >   2



    As you said that user drill down the 0PERSON object from both Infoobjecgs , in that case you might be 0PERSON made it as Navigational attributes,


    So, you can change description in report level as per your requirement ? please let me know if I not understand your requirement correctly.


    Regards,

    Nanda


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Nanda,

      Thanks for your response.

      The drill down info object for both 0EMPLOYEE and 0PERSON is "Address Line".

      We have made "Address Line" info object as Navigation attribute, both in 0EMPLOYEE and 0PERSON. Users say, they don't wish to have the "address line" in the initail display of the report output and rename description in the BEx query. Because, only during ad-hoc analysis they wish to do a drill down and expect the description appropriately as "Office Address Line - when try to look in the attributes for 0EMPLOYEE" and "Home Address Line - When they try to look in the attributes for 0PERSON"


      We can achieve this by having separate info objects and back end changes; we are looking if we can get this at the BEx report level.


      Thanks Again!!


      Regards,

      Sunil

  • avatar image
    Former Member
    Jan 01, 2015 at 04:34 AM

    Hi,

    Change the infoobject 0EMPLOYEE. Go to attribute and change the Navigational attri Description of "Address Line" as "Office Address Line".

    Change the infoobject 0PERSON. Go to attribute and change the Navigational attri Description of "Address Line" as "Home Address Line".

    In the query you will get the Description of respective Nav Attr desired.

    Or in query you can change the description of 0EMPLOYEE_ADDRESSLINE & 0PERSON_ADDRESSLINE as required.

    Regards,

    Sucheta

    Add comment
    10|10000 characters needed characters exceeded