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

 

Use of presentation Variable across Dashboard page and subject area in Prompt

 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
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 another prompt and select variable prompt this time

 
7) Do the setting as shown below, in user input select the choice list, in choice list value select
    All column values and then click on select column(select desired column you want)
 
8) Pass the presentation variable created earlier and save it

    
9) Now pull both the prompt on same Dashboard page or we can pulled it on different page also


10) Select one of the Date and click on apply button the other prompt will also change with
       selected Date in prompt one as default value