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
Build member list in one stream
Hi, Can we build a list in One stream. I believe there is functionality in HFM but not sure if we can replicate.
Henning
OneStream Employee
OneStream EmployeeHi, yes you can.
E.g. in the documentation, here...
https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Financial%20Model%20Guides/Examples%20of%20Key%20Functions.html?Highlight=memberlist
... or here:
https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Financial%20Model%20Guides/Finance%20Function%20Types.html?Highlight=memberlist
There are also some questions that have been answered in this forum when you use either "memberlist" or "member list" as a search phrase,
Since you are already familiar with HFM, I assume the above will get you started.
List is kind of like alternate roll up in HFM which can be used smartview, business rules, form etc.
- Henning
That sounds like member lists in OneStream.
"A custom list of members for use in Cube Views and other areas." (from the Finance Function Type link I posted earlier)
Here you can find an example how to call a member list in a cube view report (see section "Cube View Member Filter Syntax"):
https://documentation.onestream.com/1375907/Content/Design%20and%20Reference/Cube/Commonly%20Used%20Member%20Filter.html?Highlight=memberlist%20cube%20viewIn OneStream you can do a lot of thing in many different ways. You can also create lists using XFBR rules and use those in many many places (rules, reports, dashboards, etc.). Additionally, you can use parameters as well, and more. Depending on the use case, each option might present its own unique advantages.
Thanks Henning! This is not I am asking but the way one stream is, you got to use dashboard to use most of the function if it will be dynamic.
Cant use in ad-hoc.