Interaction

The Interaction panel controls the drill-down features of cube. When this option is enabled, clicking on a cell in a cube will launch a report that shows all the records that contributed to that particular cell. You can customise the report using the report designer.

To enable drill-down, start by clicking "Generate default drill-down report". This will create a report file and populate it with information consistent with the cube. For example, the report must use the same data source as the cube it is related to. The name of the report and the predef that will show initially will be filled in for you. Check that the Enabled checkbox is ticked and you are done.

Open the cube, choose some dimensions and a measure and then click on a cell to see the report. You can decide what columns you want to view by default and create a new predef for them. Then just return to the cube designer and tell it to use the Predef you have just created instead of the default "onclick" one generated by the system.