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
m_b_b_15
1 year agoNew Contributor III
Create Parameters for Member Filters...where to start?
Hi, I am creating a report for our auditors that takes the IC accounts and their elimination "Plug" account throughout the Origin dimension. I don't want to create a bunch of separate reports for AP/...
- 1 year ago
I am sure there are many ways to tackle this. One approach would be to use a text property on the accounts to tag the accounts you want grouped together, with the same text field.
for example, tag your IC A/R accounts (including related plug) with Text1 = ICAR, tag your IC A/P accounts (including its related plug) with Text1 = ICAP, and so on.
Then in your parameter set up a delimited list such as this, again just an example:
Then in your cube view use that parameter in a Where clause like this:
When the user runs the cube view they will be prompted to select which group of intercompany accounts they want to see. Once they select, that is used in the WHERE clause on the cube view to pull back only those accounts.
Again, this is one approach. I am sure there are many other approaches.
m_b_b_15
1 year agoNew Contributor III
Thanks Teresa - how would I go about creating a custom group so that would be reflected in the drop down? For example, I want IC Receivable, IC Payable, and IC_Plug in each of the rows and the user would just select "AP_AR_Elim" and see these 3 accounts eliminating throughout the hierarchy. I don't want to run it for each account separately.
Related Content
- 2 years ago