Use Analytical Drill-Through

Author: Kepion Product Team

Introduction

One of the types of drill-through that Kepion supports is cube level drill-through, or analytical drill-through.

Example

Simply right-click on a read-only cell and select Drill-through (Analytical) to start analyzing that cell’s data.

The CUBE DETAILS tab is selected when you first open the Drill-through window. You can drag and drop different slicers into the analysis design region. To view the data, click on the Drill-through button.

Here is an example of the data that gets returned on the RESULTS tab.

• The information section at the top shows the value of the selected cell, and the scope that contributes to the number.
• The last column Percent gives you the ratio of the value on the same line to the value of the selected cell.
• The returned data-set is ordered by Percent from largest to smallest.

You can go back and forth between the CUBE DETAILS tab and the RESULTS tab to analyze your numbers. If you want to save the default drill-through slicers, navigate to the Form in the MODELER. Under the Edit mode, drag and drop the slicers to the DEFAULT region, and click Save. Once saved, the default slicers will be shared with other users.