Skip to main content
Contributor
Apr 6, 2022 3:18 PM UTC

How to suppress any future months values in CV?

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). 

Mustafa_A_0-1649258109452.png

 

 

4 replies

Newcomer
Apr 6, 2022 3:29 PM UTC

Hi Mustafa,

 

I think you are looking for syntax below. That will give you all prior periods inclusive the active period you working with.

 

PeterFu_0-1649258885031.png

Peter

 

Contributor
Apr 6, 2022 3:40 PM UTC

 

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! 

 

Newcomer
Apr 6, 2022 3:51 PM UTC

Hi Mustafa,

 

I am a bit confused, do you want to suppress the months after March or have some rows showing zero or blank?