Hi Mark,
You can read literal value parameters inside a dynamic calc.
I will suggest using Difference Between Columns in the Cube view itself rather than having a parameter inside a dynamic calc.
In the above example I am using Difference Between Columns CVC to get the difference between the scenarios. The Column names are self-explanatory you can setup your cube view like shown above. This approach is dynamic and works similarly just like a dynamic calc but will be easier to maintain. In your case you can replace Difference Between Columns CVC with Column Better/Worse CVC [GetDataCell(BWDiff(CVC(Col1), CVC(Col2))):Name(BetterWorse Difference)] rest everything will remain the same.
Thanks, Omkareshwar
Archetype Consulting
Hi Omkareshwar,
Thanks for the response.
Literal parameters won't work as I'm looking to try pass user prompt parameters to the UD8 calc.
And the reason I don't want to do the formula as a cube view formula, is because I use the result to generate status indicators like the ones below:
The indicator is determined using a business rule based on the outcome of the variance. I would like to have a single formula for both the variance column and the status indicator to ensure that they are always consistent.
The only way that would work is if I was able to pass the result of a cube view calc to a business rule, which I don't think is possible.
If the UD8 route isn't possible, then I'll just create a business rule instead.
Regards,
Mark
