Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
4 months 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...
Sridhar_M's avatar
Sridhar_M
Contributor

Hi TheJonG 

Here’s a screenshot of the Member filter for the text column, where UD8 is a dynamic member that retrieves the Entity group from the text property based on the Entity point of view.

I already attempted to add a U8 Member to replicate the GetDataCell logic, but I'm having trouble accessing the user-selected U1 members for Row1 and Row2 (U1#Member1 and U1#Member2, which are also user selections). Is there a way to retrieve those values in the Member formula? If so, could you please assist me with that?

 

TheJonG's avatar
TheJonG
Contributor III
3 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
    3 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.