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

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
1 year ago
Solved

Passing parameters into UD8 member

I am building a UD8 dynamic calc to bypass the limit of 4 cube view overrides. The calculation will read the referenced member (e.g. A#Net_Income:S#Actual) and return a different member intersection ...
Parameters
Reports
  • Henning's avatar
    Henning
    1 year ago

    Hi,

    when the time parameter in the cube view is selected, I assume this time also applies to the cell the UD8 member is used on (sounds like it here: "The UD8 member must read the time parameter used in the cube view.").

    So the selected time is part of the point of view (POV) for the dynamic member. That means that you can pull the time from the POV of each cell where the calculation is executed on using in your dynamic member formula:

    Dim TimeMbr as String = Api.Pov.Time.Name

    This also saves you the BRApi, which is to be avoided when possible as it impacts performance when executed too many times.

     

TheJonG's avatar
TheJonG
Icon for OneStream Employee rankOneStream Employee
1 year ago

My first thought is exactly what Henning mentioned - using the api.pov.time.name. Also it is not recommended to use the GetLiteralParameter Brapi call due to it not being user specific i.e. users can override the literal parameter and get inconsistent results.

That being said, you cannot pass a parameter into a UD8 dynamic calc. However, you can use a Finance Business Rule with a FinanceFunctionType of DataCell and pass parameters there. You can replicate the UD8 logic within there. Here is an example:

Finance Rule:

Calling the BR in the Cube View: