Monday, December 1, 2014

Change the column heading dynamically

Today will see how to change the column heading dynamically. Please follow below steps.

Log into the Business Intelligence analytics with the link.Click on New-> Dashboard Prompt and Select the column prompt -->Select the Column Calendar Date from Sample Sale Lite subject area --> Set the presentation variable Date and save it, Check Screen shots.












Then go for report creation click New--> Analysis --> Drag the column field to display on the reports
Click on right most button of field and select column property


















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










Save the report and pulled it on Dashboard page and select the date from prompt.The column heading will change according to value select in the prompt







I hope you understand. Bye ! Take Care !
Thanks and Regards
Rakesh Patil

No comments:

Post a Comment