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.
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.
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.
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.
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.
04-10-2023 04:21 AM
In an OS environment, Chul's definition is of cause more precise, my answer was more generic.