Dynamic Column Header Name in SAP analytics Cloud

[former_member411491]

Hi Experts,

I want to change the name of Column as per report filter selection.

for example if column name is budget and i have 3 report filter 1. Current month 2. previous month 3. Upcoming month forecast. I want to change the column name as per filter selections.

1. Current month ( Column Budget------- > "Current Month name" Budget.

2. previous month ( Column Budget ---> "Previous Month" Budget.

3. Upcoming month forecast. ----> (Column Budget ---> "Future month" Forecast )

Any help ?

[JohnL]

Hi Sanjay,

We don't support those options currently.

However, have you looked at using the Forecast / Rolling Forecast features via the Cross Calculations dimension?

1. See Creating a Dynamic Forecast Layout

See also some webinars on the advanced planning features of SAC here:

https://wiki.scn.sap.com/wiki/display/BOC/Events+and+Webinar+Recordings+-+SAP+Analytics+Cloud
Search for 'planning' on the web page.

[Henry_Banks]

Hi,

there are some features around the use of 'dynamic texts' https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2018.7/en-US/0b34d65766584dd28281a169bea8b... have you tried making use of these ?

regards, H

[TammyPowlas]

Hello Sanjay - please see the comments from SAP's Jacob Stark in this improvement request: https://influence.sap.com/sap/ino/#/idea/142776/?section=sectionComments - S-user required

"Jacob Stark: Not sure if you noticed, but now you can do this-- With the chart title selected, click on the ... and see that you can now insert dynamic text into the title. Additional enhancements are also coming in the next wave (which you will most likely get within the week)-- Enjoy and let us know what you think!" (source: SAP Influence)