Skip to main content
A
allanaklepko
Newcomer
April 5, 2023
Solved

Drill back vs Drill down

  • April 5, 2023
  • 2 replies
  • 0 views

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.

Best answer by ChristianW

'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.

2 replies

C
OneStream Employee
ChristianWOneStream EmployeeAnswer
OneStream Employee
April 5, 2023

'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.

    C
    OneStream Employee
    chulOneStream Employee
    OneStream Employee
    April 7, 2023

    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.

      C
      OneStream Employee
      ChristianWOneStream Employee
      OneStream Employee
      April 10, 2023

      In an OS environment, Chul's definition is of cause more precise, my answer was more generic.

        Terms & ConditionsAccessibility statement