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.
JackLacava
OneStream Employee
OneStream EmployeeWell, Dynamic calcs will show what Dynamic calcs will return 😅 The actual member formula has to check whether the view is an annotation one (i.e. all the text-based ones like VarianceExplanation, Footer, etc) and return text accordingly. Example largely taken from snippet "UD8 Text1 as Annotation":
'This dynamic reporting member will show the Text1 property of each Entity as an Annotation
If api.View.IsAnnotationType(api.Pov.View.MemberId) Then
'Return the Entity's Text1 setting for this text-based View member
Return api.Entity.Text(1)
Else
'Return a NoData Datacell
Return api.Data.CreateDataCellObject(0.0,True, False)
End If
Dynamic calcs don't store any values and don't have any default behaviour, they have to manually take care of everything in the formula - aggregations, annotation support, etc etc.