Hi TheJonG
Thank you for the feedback. Below is a sample export of the cube view, and yes, I'm using V#Annotation to retrieve the string. The sections highlighted in green should display the same Entity Groups as in Actual and Forecast.
Not totally sure but I do think the GetDataCell is messing it up. Instead of using a GetDataCell with the CVR functions you could use a UD8 dynamic calc instead and replicate the logic there. Then you can do an If Statement on one the POV members of the third column and have it return the text for that column only. If this isn't clear, paste in a screenshot of the third column member filter and I can try to give you an example script.
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?
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:
