As the title mentions -
I have these months (Apr, May, Jun) that we haven't reported any numbers. How can I suppress the values within Cube view?
I want this to be dynamic that if current reporting month is April 2022, then suppress all the future months from then onwards (show zero or blank).
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.
