Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

Drill 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

  • 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's avatar
    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.