Forum Discussion

JenJessel's avatar
JenJessel
New Contributor III
2 years ago

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...
Cubes
  • JackLacava's avatar
    JackLacava
    2 years ago

    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's avatar
JackLacava
Honored Contributor
2 years ago

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.