Dynamic Year

Previous Member

We have a year selection on a screen. Based on this selection, the data gets filter..

We have Columns like Current Year Budget, Prior Year Budget, Prior Prior Year Budget.

For eg: If i have year selected as 2020.

Then columns are 2020 Bugdet, 2019 LE, 2018 Actuals.....

I want to make the year part dynamics across the screen.

For Current Year, i am using @Year

Not sure what to use for Prior Year, and Prior Prior Year.

I have used these in both labels & dataview.

Please advise.

Find more posts tagged with

Accepted answers

All comments

Previous Member

Hi GAURAV SINHA,

have you tried using a 'year' cube? Then you could use a layout on the labels. For the prior year you should be able to use the 'previous year' function

BR, Ray

Previous Member

Great Idea.

I am trying to achieve this in a dataview. So is there anyway i can make cube header dynamic in dataview?

Previous Member

To my knowledge the header depends on the name of the cube and the column axis value. If I understand correctly you won't have a column axis and so only static column names.

You could hide the column headers in the settings of the dataview

and put labels on top. I wouldn't recommend that because then the width of the columns can't be changed interactively.

BR, Ray