Search This Blog

Wednesday 2 January 2013

How change the column heading dynamically


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

No comments:

Post a Comment