The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

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 reporti...
Cube View
PeterFu's avatar
PeterFu
Contributor II
4 years ago

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

 

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

 

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! 

 

  • PatrickWWiggett's avatar
    PatrickWWiggett
    New Contributor III
    4 years ago

    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.

  • PeterFu's avatar
    PeterFu
    Contributor II
    4 years ago

    Hi Mustafa,

     

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