Hi Mustafa,
I think you are looking for syntax below. That will give you all prior periods inclusive the active period you working with.
Peter
Um..basically I want to selectively over-ride the intersection for specific rows (after March 2022)
and then have it show either a blank or zero.
we have forecasted data reported in that same cube view that needs to show future periods.
I'm not sure OS has such functionality - but worth a try!
So then maybe something like:
S#Actual:T#WF.AllPriorInYearInclusive, S#Forecast:T#WF.AllNextInYear
What this will do is show you all your actual values to date (April) and then show your forecasted data for the rest of the year.
Hi Mustafa,
I am a bit confused, do you want to suppress the months after March or have some rows showing zero or blank?
