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
Solved
Text Values in Cubeview
Looking for help to display Text data in a cube view. I'm using the member filter below which works for every account type EXCEPT DynamicCalc. Account Type set under Settings in the Member Proper...
From what I can see, the engine will execute Dynamic Calcs in the usual order (i.e. Account first, then Flow, then UD1, etc etc). As soon as it finds a Stored Item, even one containing only comments, it executes that and stops.
In your case, you have a formula in the Account that probably returns a number; that is executed first, and nothing else gets a chance. Since the view is an annotation, that means you get a NoData cell (as documented in the Design guide). Your UD8 formula is never executed.
If you have a Dynamic account formula, you have to place any support for Annotation views in that formula.
Yes, my DynamicCalc is pulling back the result of my formula. I am also looking for it to pull back the text data in Text3. I am using the following formula in UD8. This formula works in pulling back the data in the Text 3 field for all accounts types except a DynamicCalc Account type.