Drill Through Grid Interaction in Spotlight

When you perform a drill through from a model view, you can interact with the resulting Drill Through report in the following ways:

• Drag and drop a single column, a range of columns, or multiple columns to reorder them

• Adjust the width of a single column, a range of columns, or multiple columns

• Turn filters on or off

• Sort column data in ascending or descending order

• Select the code, name and label display for members

In Practice

1. Open a view by navigating to Analyze > Data and selecting a view.

2. Click the Drill Through icon as shown below. The Drill Through report is displayed.

   

   

3. Select a column or columns to reorder and drag and drop as shown in the image below.

   

4. Sort the column in ascending or descending order.

   

5. Turn filters on or off.

   

6. Display dimension members by code, name or label (the default is set to label which is name+code). If you change the default to code in the Reporting module, for example, and save then the setting is retained when accessed via Spotlight. You cannot save the setting from Spotlight.

   

7. Adjust column width as needed.

   

8. Select to display or hide specific columns.

   

   For information on Doc Ref, Lines, and Sublines, see Dynamic Reports: Enhanced Drilling on Dynamic Report Output

Important Details:

• Data is displayed in the same currency and formatted as loaded or upon input into the application for QTD and YTD or multi-currency calculations in Drill Through reports,

• Subline amounts are stored in local currency and currency conversions do not exist.

• Calculated members, calculations, and Excel formulas, are not supported in Drill Through reports.

• All template types are supported except for Template based HR, Actual Data Template, and Initiative templates.

• Drill Through is not supported with Multiple POV on a cell.