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
Filter Cost Centers without Data in Books
I created a Reporting book with a loop on CC's. Is there a way I can filter the Tabs without data in the Report?
I am planning to implement and test the options listed below but I also wanted to ch...
Hi TauseefBozai: both ideas should work. I think your option one sounds better to me from an ease-of-maintenance standpoint. Although I would suggest you use a standard Member Filter with a Where clause expansion filtering on the Text property (i.e. X#YourParent.Base.Where(Text1 = 'Value') ) in your Loop component.
That said, a few other options:
- Since your list of cost centers is static you could simply specify the list of values in a parameter and reference that directly; the benefit of this is that it does not require metadata maintenance
- If you need a dynamic selection of cost centers that have data, there are ways to generate the list on the fly, but it requires custom business rules. This is what we use.
Hi TauseefBozai: both ideas should work. I think your option one sounds better to me from an ease-of-maintenance standpoint. Although I would suggest you use a standard Member Filter with a Where clause expansion filtering on the Text property (i.e. X#YourParent.Base.Where(Text1 = 'Value') ) in your Loop component.
That said, a few other options:
- Since your list of cost centers is static you could simply specify the list of values in a parameter and reference that directly; the benefit of this is that it does not require metadata maintenance
- If you need a dynamic selection of cost centers that have data, there are ways to generate the list on the fly, but it requires custom business rules. This is what we use.
Hi would you be able to share or explain the custom business rule logic used to supress book tabs without data? I have a similiar problem but a text1 won't work for me. I want to only loop through Employees that have data.