- OneStream Community
- Forums
- Reporting
- Drill back vs Drill down
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023
12:00 PM
- last edited on
05-23-2023
05:48 AM
by
JackLacava
What is the difference between 'drill down' and 'drill back' functionality? is it just the matter of different names refering to the same function? thank you.
Solved! Go to Solution.
- Labels:
-
Cube View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023 12:07 PM
'Drill down' stands for drilling down the dimensional hierarchies.
'Drill back' drills from a data cell (normally in a cube) back to the source data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-07-2023 02:10 PM
I have a slight correction, Christian.
'Drill down' gets you to the base data that resides in OneStream. This includes not only the dimensional hierarchies, but it also refers to pre-transformed stage data. This is source data from either a direct connection to an external database or a source file.
'Drill back' ONLY exists when OneStream has a direct connection to an external database. It's defined as querying data that does NOT exist (ie. hasn't been loaded) into OneStream. Drill back is NOT possible when loading source files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023 12:07 PM
'Drill down' stands for drilling down the dimensional hierarchies.
'Drill back' drills from a data cell (normally in a cube) back to the source data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-07-2023 02:10 PM
I have a slight correction, Christian.
'Drill down' gets you to the base data that resides in OneStream. This includes not only the dimensional hierarchies, but it also refers to pre-transformed stage data. This is source data from either a direct connection to an external database or a source file.
'Drill back' ONLY exists when OneStream has a direct connection to an external database. It's defined as querying data that does NOT exist (ie. hasn't been loaded) into OneStream. Drill back is NOT possible when loading source files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-10-2023 04:21 AM
In an OS environment, Chul's definition is of cause more precise, my answer was more generic.
