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 where is more than this is highlighted in red. My problem is that number is recorded in a paramenter but is not working, maybe in the image below is showing better than my explanation; could sombody knows how is the parameter format?

Thank you and best Regards

Mario G

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
    6 months ago

    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