Forum Discussion

OS_Love's avatar
OS_Love
New Contributor III
2 months ago
Solved

Dynamic Calc

Hi, I am trying to use parameters that I select in a cube view to be used in a dynamic calculation. Can someone advise how to do that in a UD8 dynamic calc formula? Parameters are to select scenar...
Cube View
Parameters
Reports
  • Pierre_VISEA's avatar
    Pierre_VISEA
    2 months ago

    A dynamic calc only knows a POV and not parameters (it is a finance rule, you can only read Litteral parameters). Maybe you should use a getdatacell in which you perform a calculation which formula is given by a XFBR.

    For instance if you want to calculate ParemeterSc1 + ParemeterSc2, you can write : GetDataCell(XFBR(myBR,myXFBR,Sc1=|!ParemeterSc1!|,Sc2=|!ParemeterSc2!|)) and return "S#ParemeterSc1 + S#ParemeterSc2" from your BR

    Pierre

Pierre_VISEA's avatar
Pierre_VISEA
New Contributor
2 months ago

A dynamic calc only knows a POV and not parameters (it is a finance rule, you can only read Litteral parameters). Maybe you should use a getdatacell in which you perform a calculation which formula is given by a XFBR.

For instance if you want to calculate ParemeterSc1 + ParemeterSc2, you can write : GetDataCell(XFBR(myBR,myXFBR,Sc1=|!ParemeterSc1!|,Sc2=|!ParemeterSc2!|)) and return "S#ParemeterSc1 + S#ParemeterSc2" from your BR

Pierre