Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
6 months ago

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...
Cube View
Parameters
  • MarioGV's avatar
    MarioGV
    5 months ago

    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

Nikpowar97's avatar
Nikpowar97
Contributor

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)

MarioGV's avatar
MarioGV
New Contributor III
5 months ago

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