Drilling Capabilities
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Drilling Capabilities

  • Dark
    Light
  • PDF

Article summary

  • Drill down – hierarchical drill - expand a line on the report to see data for lower level members in the main/alternate/attribute hierarchy

  • Drill through – drill on a number into the transactional data or translational details that were loaded with Data Load Rules

In Practice: Drill Down

Time dimension data - For example, if you expand 2017, you can view data for the 4 quarters associated with 2017. If you expand each quarter you can view data for each month.

Variable data - If you expand a variable, such as @CURYR@, you can view data for the 4 quarters associated with the current year variable. You can expand the quarters to view data for each month.

Simple Rule in a Report Set

- For example, you define a line as follows:

sum({4010 - Gross Sales , 4020 - Royalties , 4030 - Indirect Sales , 4100 - Intercompany Sales - Mfg})

You can drill down to view data for 4010, 4020, 4030, and 4100.

Or, let's say you define a line as follows:

sum({@CURMTH@ , @CURMTH-1@ , @CURMTH-2@ , @CURMTH-3@ , @CURMTH-4@})

You can drill down to view data for the current month and the previous 4 months.

Note:
A rule represents data elements in the cube similar to rules created in Excel (similar to cells, rows, and columns). Report Sets are built using rules.

In Practice: Drill Through

You have Net Income on the row and Aug-17 on the column. Click the number and drill to the daily transactional or translations data. This works only if the data was loaded with Data Load Rules.

You have Net Income on the row and @CURMTH@ on the column. Click the number and you can drill to the daily transactional or translations data if loaded via Data Load Rules.

You have Net Income on the row and sum({@CURMTH@ , @CURMTH-1@ , @CURMTH-2@ , @CURMTH-3@ , @CURMTH-4@}). When you drill through, you can view the transactional or translations data for the current month and the previous 4 months.

You have ([Account].&[1068],[Department]. &[101],[Project].&[565]) on the row defined using the Multiple dimension option in Report Sets and MTD on the column. You can drill to the daily transactional or translations data.

Drill-through displays values from the beginning of the year to the current period when YTD or QTD are applied.

Values displayed in the drill-through pop-up window are applicable for all periods, from either the beginning of the current fiscal year or the period selected during report design. For example, if current month is set to September, drill-through displays the values from January until September if YTD is the Measure applied.

The columns for transactional or translation drill through data can be sorted in the pop-up window.

Note:
Drill through will work if both the row and column use simple rule definitions. If multi-dimensional rules are defined using the Advanced Rule page, the system will not automatically translate the rule to a simple rule definition, and drill through is not opened until you manually convert the advanced rules into simple rules.

Was this article helpful?