Skip to Content

Dynamic Column Header Name in SAP analytics Cloud

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 27 at 09:51 AM

    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)


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27 at 10:53 AM

    Hi,

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


    regards, H

    Add comment
    10|10000 characters needed characters exceeded

  • May 01 at 03:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded