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
Hi Mark, not sure if it helps now, but i manage to pass a parameter using this:
Dim scen As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,False,Nothing,"Default.mbl_Scenario")
Cheers
