Forum Discussion

SimpleLove's avatar
SimpleLove
New Contributor III
7 months ago

Does OneStream have smartlist type of data type?

Hello OneStream Expert:

We are going to to convert one Hyperion Planning application to OneStream Application. In Hyperion application we have SmartList type of Datatype, for example we have an Account Member call 

Display_Flag

1, Yes

2. No

In web form, it will display Yes or No and data will be saved to Essbase as 1 or 2.

But I cannot find the SmartList type of Datatype in OneStream for me to display Yes or No in the Cubeview. I wonder what kind of solution can be applied. Thank you in advance.

User Interface
  • Henning's avatar
    Henning
    7 months ago

    Hi, based on your explanations, I think the Combo Box Cell Type in a cube view is what you need.

    With this, data such as 1, 2, etc. will be stored in the cube but text (as per parameter definition) will be displayed in the cube view.

    You can also use V#Annotation, but that works a little differently.

  • Henning's avatar
    Henning
    Valued Contributor II
    7 months ago

    Hi, based on your explanations, I think the Combo Box Cell Type in a cube view is what you need.

    With this, data such as 1, 2, etc. will be stored in the cube but text (as per parameter definition) will be displayed in the cube view.

    You can also use V#Annotation, but that works a little differently.

    • Henning's avatar
      Henning
      Valued Contributor II
      7 months ago

      And another obvious solution is using dynamically calculated members. That might just as well be the easier solution. With those, you can check the flags in your database or a text field (or wherever else) and return a "Yes" or "No" on V#Annotation.

      The documentation on this starts here:

      Create Dynamic Calculations (onestream.com)