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 with any business rule if i can do?
I would choose an XFBR but trying this without any coding is also fun.
an option could be to use a text property of the scenario, lets assume text1 is still free. In the scenario that you want to use as a comparison you can populate the text1 with the scenarios that it needs to be visible for. So in Budget Text1 you type Actual.
Then in your column selection you select first a column with your workflow scenario (assuming you work from the workflow) thus S#WF, in your second column you say S#Root.base.where(Text1 contains |WFScenario|) Since you use contains you can concattenate ActualBudgetForecast for a scenario that you want to have visible for all three. Samples of the Where clause are in the member filter builder:
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
