Forum Discussion

DDrider's avatar
DDrider
New Contributor III
3 months ago

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
    3 months 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
Contributor III
3 months 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: