Dynamic Cubeview based on scenario
I am trying to build a cubeview wherein if i select actual scenario the comparative scenario come Budget Forecast and PY whereas if i select my comparison scenario is PY Fcst or PY. Is there a way wi...
Forum Discussion
Hi Shub,
you can use an XFBR business rule for that, this rule returns a string that you can use for your scenario column setting. In the parameters you can provide your selected scenario (e.g. |WFScenario|) and then make an if statement to return the scenario string. Another option is to use a memberlist that you can make dynamic as well.
and how to do it with memberlist without using business rule.. I am not sure how to use memberlist to make dynamic for example whe i use Actual the scenario comes actual then vs Fcst vs Bud and vs PY... whereas for Bud it should be only vs PY
