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.
Hi Yan,
This is what we're using for values, formatting the cell to be red when it's not zero:
We also use this to call out intercompany accounts on a different CV:
Maybe the issue is in the formatting of the conditional request? Hope the above are useful.
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
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.
Lee, Thank you!
Just tried this approach and it worked like a charm!
Hi Nicole/Lee and All,
Need some help here pls. In cube view i needs to populate NM where there is "NODATA", i did played around with cellformat formula (see screenshot) still no success. Please help.
Thanks..Sandeep S
