Tuesday 4 March 2014

Dynamic Column Headers OBIEE 11g

1. Create one presentation variable. e.g. Date - Use following screenshots as guidelines.



2. Create one dashboard level prompt. Calendar Date. Select Set a variable as presentation variable and give Date as the variable name.


3. Create one sample analysis, add date column on which you want to prompt and change the column heading.


4. Apply filter as "is prompted" to that date column.

5. Go to column properties of that date column.

6. Select "Custom Heading" and make it as, Selected : @{Date} - here Date is the presentation variable name.

7. Save it and drag it to the dashboard to test.


8. Change the prompt value and see column heading is as per the prompt value. e.g. If you have selected, 6/28/2012 then the column heading will be Selected : 6/28/2012

You are done. :-)





1 comment:

  1. Thanks For sharing this Superb article.I use this Article to show my assignment in college.it is useful For me Great Work.

    ReplyDelete