OneStream Community

PatrickWWiggett · 04-04-2022

Hi All, Does anyone know of a formatting string that will allow us to edit the textcolor of writeable cells in a cube view? I could split out the columns so that we have locked and writeable cells seperately and then we edit the textcolor of all the ...

PatrickWWiggett · 04-07-2022

Hi,I don't know how to answer this question, but I was just curious about it.Why does the environment not lock the workflow period after certification? That way you can't edit any of the individual workflow steps after certifying. I am just curious t...

PatrickWWiggett · 04-07-2022

This script won't hide the data, but will allow you to edit the colour of your derived data:If (IsDerivedData = True) Then TextColor = TransparentYou can put that in your "Cell Format" for your applicable columns/rows.Not sure if that helps?

PatrickWWiggett · 04-07-2022

So then maybe something like:S#Actual:T#WF.AllPriorInYearInclusive, S#Forecast:T#WF.AllNextInYearWhat 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.

PatrickWWiggett · 04-07-2022

GetDataCell(CVC("Insert column name") + CVC("Insert column name"))This is a small script you can write in the actual cube view column member filter which will perform an on-the-fly calc.

PatrickWWiggett · 04-05-2022

Alternatively I sometimes use a separate column with the V#Annotation and then a unique metadata member which then returns the appropriate dimension/member property that you want:If api.View.IsAnnotationType() Then Return api.pov.UD1.NameElse Return ...

OneStream Community

User Statistics

User Activity

WriteableTextColor

Re: Prevent file import when the workflow step is certified without using a lock

Re: UD8 Dynamic rule to hide derived values. Does anyone have an example of this UD8 calc?

Re: How to suppress any future months values in CV?

Re: business rule BR for a column (e.g. K) to Accumulate what is in another column (in Cubeview)?

Re: Cube view column headers