Solved
cell format in CV using parameter
hi Team; I've a cube view showing accounts than need to highligh in red when overlap a number dependig the FxRate, I created an Finance BRule searching for a specific rate and multiply be a number wh...
Forum Discussion
I am not sure but can u try writing a XFBR and use the function (Parameter should be a literal parameter value)
Return BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,False,Guid.Empty,"Default.prm_Name") and the call the same in the CV
Not sure it will work but can u give it a shot.
(I hope u have tried using hardocoding and u are getting the expected formatting due to that)
I created an XFBR using the funcion GetLiteralParamenterValue and the way to call the function in a cube view is:
If (CellAmount > XFBR(LCI_XFBR_GetParam, GetVarianceValue)) or (CellAmount < -XFBR(LCI_XFBR_GetParam, GetVarianceValue)) Then
BackgroundColor = Red, TextColor = Snow
end if
and the XFBR is simple:
thank you for your help and I hope could be useful for somebody else.
Regards
Mario G