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
Solved
Is it possible to pass a parameter to a UD8 dynamic calc member?
Hi all I currently have a UD8 member to do a simple variance to actuals formula, but I was wondering if it is possible pass parameters to the UD8 member formula that this could be more dynamic? ...
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
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
Just wanted to say a big thank you for posting this solution. It's helping me out a ton!
🤩
