Dynamic Text in manually added columns

[SANA11]

Hi all, 

Can anyone assist me? I'm facing an issue while creating a financial statement with a five-year strategic plan. The data is coming into SAC from a BW Live Query, and all the modeling is done in BW. I have five columns with data coming from BW, namely Business Plan 2025, Business Plan 2026, Business Plan 2027, Business Plan 2028, and Business Plan 2029. These columns were used to derive five additional columns manually in SAC by adding new columns and hiding the original ones. However, the new columns have an issue—once the text is added, it does not update when the fiscal year changes. How can I make the text dynamic so that the headings adjust automatically based on the selected fiscal year? If the fiscal year changes from 2025 to 2026, the Business Plan headings should update accordingly, starting from 2026 to 2030.I attempted to create an input control and link it to dynamic text, but it isn't working. please assist if we can do it by scripting 

[N1kh1l]

@SANA11 

calculated measures could have dynamic descriptions based on input controls.

But if input controls are not an option. You could use scripting to read the description from the original measures and store it in 3 variables. Later you could use these variables to bind dynamic text and super impose it over your table columns to create a visual illusion.

Hope this helps !

Nikhil

[JBARLOW]

You beat me to it 🙂 input control or text boxes

[SANA11]

appreciating your response @nikhil Here is a screenshot of the calculated column "Business Plan 2025."

The column is calculated by summing the Outlook and Business Plan 2025 values from the BW Query, which is currently hidden. This column has been derived by applying a simple summation formula. The heading for this column is part of a dimension labeled as "Category."

However, the category columns are the original ones that have been replaced with manually created columns. If the dimension is used to generate dynamic text, the original column reappears. Therefore, the goal is to make it dynamic based on the fiscal year dimension.