Saturday 28 January 2012

How change the column heading dynamically

We can change the column heading dynamically by passing the presentation variable in column heading, to achieve this follows following steps

1) Log into the Business Intelligence analytics with the link 
    http://Machine_name:port/analytics
    The port will be 7001 if OBIEE install with simple install option with default port
    configuration or it will 9704 if OBIEE is install with enterprise option default port configuration

2) Click on New-> Dashboard Prompt


          





















3) Select the column prompt

  






















4) Select the Column Calendar Date from Sample Sale Lite subject area

 






















5) Set the presentation variable Date and save it

 




















6) Then go for report creation click New-> Analysis

  






















7) Pulled the column field to display on the reports









8) Click on right most button of field and select column property











9) On column properties dialog box navigate over column format and select check box Customize heading.              Set the presentation variable @{Date} in column heading

















10) Save the report and pulled it on Dashboard page and select the date from prompt















11) The column heading will change according to value select in the prompt

 

2 comments:

  1. Hi Rhishikesh,
    I have tried your solution, it is working if I use the table view but not in case of Graphs. Can you suggest me any alternative for that.

    Anshul

    ReplyDelete
  2. If we want to get grand total as the dynamic header what is the process..

    ReplyDelete