The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OS_Love
5 months agoNew Contributor III
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...
- 5 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
5 months agoNew Contributor
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
Related Content
- 6 months ago
- 5 months ago
- 3 years ago
- 4 years ago