Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago

Is it possible to return a string with CubeView GetDataCell Function

Hi everyone, We have a cube view with three rows structured as follows: Row1: E#Parent1.Children:U1#Member1 Row2: E#Parent1.Children:U1#Member2 Row3: Variance between two columns. To handle...
TheJonG's avatar
TheJonG
Icon for OneStream Employee rankOneStream Employee
12 months ago

You cannot pass a parameter into a UD8 dynamic calc so there is really no way to access the user selected parameters there. 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:

 

 

Cube View with BR reference:

 

Sridhar_M's avatar
Sridhar_M
Contributor
12 months ago

Hi TheJonG,

I attempted your BR reference approach, but I'm running into the same issue we encountered with GetDataCell, since we need to use GetDataCell to reference BR.