Forum Discussion
Solved
Conditional Formatting in CubeView in the "annotation" or other "Text" cell
I would like to apply conditional formatting to a Cube View column that contains "Annotation", "Variance Explanation" or other textual data.
I have tried IsNoData and "CellAmount" conditions, but ...
If you set the UD8 to Return a 1 if an explanation or 0 if not required.
Then set up a Delimited List Parameter where 1, 0 are the values and your Explain / Not Required text strings are the Display items.
Then set your CV column up to use this Combo Box as follows, note Modify Data = False means the cell will not allow drop down.
The cell value in the Cube View will display as Explain / Not Required but the cell amount will actually be 1 / 0 allowing you to perform conditional formatting.
Thank you, Nicole!
The row I am trying to apply conditional formatting to has View dimension set to V#Annotation so it has text in the cells instead of numbers. I tried the "CellAmount" condition and it does not work. I also tried "IsNoData" with no success. Basically I want to change the background of the cells with "Explain --->" text in them.
If (CellAmount = "Explain --->") Then
BackgroundColor = Yellow
End If
If (IsNoData <> True) Then
BackgroundColor = Yellow
End If
Hi,
How is the cell getting "Explain --->" in it to begin with? Is that text based on something that you could use for your conditional formatting (ie. Var % column >100)?
I am using a UD8 member with the member formula. Formula checks that both amount and percent variances exceed specific thresholds and if they do, places "Explain --->" in the V#Annotation for that account.
I am thinking I will have to add similar checks in the CubeView Extender BR and apply formatting that way.
CubeExtender does it only for a report. I don't think it'll do that on "Data Explorer." Keep that in mind when you go ahead with it.
Hi,
I would submit a OS support ticket and ask if any of the conditions for the conditional formatting can be used with text. I assume CellAmount is only for numbers but I wonder what the restriction on IsNoData is and what the explanation is regarding why it's not working. Maybe try IsDerivedData = True instead of IsNoData, though that's just a guess.
Hi Yan, did you come across a solution for this that did not require an Extender BR? I am in a similar situation where I need the conditional formatting to evaluate a text cell similar to yours which contains "Explain --->".
Unfortunately no: the only approach that seems to be available is the Extender business rule.
