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
OSAdmin
OneStream Employee
5 years agoDrill through for department level reporting
Originally posted by Priya Gnanabhaskar
We have created a department level report which shows all expenses pertaining to a department in our actuals cube. This report consolidates the balances across all our legal entities for each department [e.g. IT]. The expectation is to create a drill through report that shows all the data loaded from the GL across all entities. In the current drill through the user has to drill through each entity to see the transactions loaded from GL.
Is there any way to achieve this drill through?
2 Replies
- TonyToniTone
OneStream Employee
Drill Down is out of the box functionality that allows a user to drill down from a specific intersection from within a Cube View to source data records stored in Stage. This functionality gives the end user flexibility on what they want to drill down on.
As a potential solution to leverage for this request, OneStream provides a set of reporting Dashboards located in MarketPlace called XFS Application Reports (RPTA). In this reporting package, there are a variety of Import Detail reports that tie back source GL members to OneStream target members. The Import Detail (All Dims) report groups source GL members by specific OneStream target members.
- marisolbrittonNew Contributor III
Hi! Do you happend to have any documentation on this? trying to set up a drill down report from a quick view.
Related Content
- 7 months ago
- 2 years ago
- 2 years ago