02-08-2023 04:44 PM - last edited on 05-03-2023 09:05 AM by JackLacava
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
Solved! Go to Solution.
02-09-2023 11:59 AM
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.
02-09-2023 03:32 AM - edited 02-09-2023 12:09 PM
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 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.
02-09-2023 10:51 AM
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.
02-09-2023 11:59 AM
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.
02-12-2023 02:29 PM
Thank you. I added to the account formula like you said and it is now working.
01-22-2024 10:43 AM
Hello JenJessel.
How are you?
I have the same issue, can you share with me how did you solve it? please
I have the following:
Return api.Data.GetDataCell("A#TotalSales2 - A#TotalPrimeCost2")
thank you
01-22-2024 11:08 AM