Configuring Reports for Report Manager

Any Excel based report can be added to the Report Manager and run from the Cubix menu ribbon, however, to get the most out of it you probably want to enable the report to work with run-time parameter values.

These allow you to set the report so that you can choose certain dimension members when you come to run it.

In the Report Manager you can choose which dimensions are selectable and even predetermine the parameter values to be passed. To complete the setup, in the report files themselves, you need to assign some cells with range names to receive the parameter values.

The range names should be defined with the same names as the Cubix dimensions. So the cell receiving the Entity value should be called Entity, the cell receiving the Time value should be called Time and so on. You can then use these range names in your report design as references for the Cubix formulas so that the data returned is based on the selected parameters.

*It may be a good idea to set up these parameter ranges in all your reports as a matter of course. You can choose whether to use them or not, but if you do later decide to add a report to the Report Manager, they will be already configured.