ContributionsMost RecentMost LikesSolutionsWriteableTextColor 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 ...SolvedRe: Prevent file import when the workflow step is certified without using a lock 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 individu...Re: UD8 Dynamic rule to hide derived values. Does anyone have an example of this UD8 calc? This script won't hide the data, but will allow you to edit the colour of your derived data: If (IsDerivedData = True) Then TextColor = Transparent You can put that in your "Cell Format" for yo...Re: How to suppress any future months values in CV? 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 foreca...Re: business rule BR for a column (e.g. K) to Accumulate what is in another column (in Cubeview)? 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. ...Re: Cube view column headers 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.IsAn...Re: Cube view column headers Have you tried using the different levels in the member filter builders? These allow you to use different dimensions. Re: WriteableTextColor Thanks Bharti, we came right using this idea. Re: WriteableTextColor Hi Bharti, Thanks for this. However I am trying to have separate textcolors. One for cells where a user is not able to input data, and the other for cells where they can (Writeable cells). Any id...
