04-06-2022 11:18 AM - last edited on 05-24-2023 12:24 PM by JackLacava
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).
04-06-2022 11:29 AM
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
04-06-2022 11:40 AM - edited 04-06-2022 11:40 AM
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!
04-06-2022 11:51 AM
Hi Mustafa,
I am a bit confused, do you want to suppress the months after March or have some rows showing zero or blank?
04-07-2022 04:13 AM
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.