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 Properties (see below).
U8#Acct_Text3:V#Annotation
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.
6 Replies
- JackLacava
OneStream Employee
Well, 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 IfDynamic 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.
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.
- JackLacava
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.
