Data Dump - Too large for Cube View
Hi All,
I was hoping to brainstorm a solution to a problem. Our auditors have requested a mapping of base-level data to the aggregated, financial statement line item data that appears in our financ...
Forum Discussion
Your auditor sounds...bad. I'd push back on their request and have them narrow down what exactly they are hoping to test.
To answer your question an OneStream Report Book with a Loop component, your entity list, and a standard report can replace your report+macro process.
Reference Materials:
Henning's suggestion on FDX's is also solid. If that's too granular, then a more basic Data management export might suffice as well.
Thanks for the feedback. I currently have a report book set up with loops, but each entity gets exported as a tab, so the book ends up with 200+ tabs that don't clearly show the aggregated picture. It's not clear from the reference materials if the tabs can then combined into one single tab; is that functionality that's available?
I might be missing something. As part of your Member Filter for the Loop, the aggregate would be E#YourTopEntity? Such as:
E#YourTopEntity.Member.Base
