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 Properties (see below). 

U8#Acct_Text3:V#Annotation

 

 

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.

  • JenJessel's avatar
    JenJessel
    New Contributor III
    2 years ago

    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's avatar
    JackLacava
    Honored Contributor
    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.

    • JenJessel's avatar
      JenJessel
      New Contributor III
      2 years ago

      Thank you.  I added to the account formula like you said and it is now working.

      • grillin7's avatar
        grillin7
        New Contributor II
        12 months ago

        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