Drill through for department level reporting

OSAdmin
Valued Contributor
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 2

TonyToniTone
Contributor II

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.    

marisolbritton
New Contributor III

Hi!  Do you happend to have any documentation on this? trying to set up a drill down report from a quick view.