Forum Discussion

OS_Love's avatar
OS_Love
New Contributor III
14 days ago

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 scenario 1 and Scenario 2 and used them both in the UD8 dynamic calc .

Cube View
Parameters
Reports

1 Reply

  • Pierre_VISEA's avatar
    Pierre_VISEA
    New Contributor
    7 days 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