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
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.
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.
3 Replies
HenningOneStream Employee
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
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:
https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Cube%20Views/Create%20Dynamic%20Calculations.html?Highlight=dynamiccalc
Henning: Thank you so much for providing this great solution.
