Home > OLAP Module > How to Set Up a Report
How to Set Up a Report in the OLAP Module ?
Open the Connector.
Right-click and Add Connection. (Connects to the data you wish to interrogate).
Add the connection details.
Add Data Container/s. (Published through your Data Connection describing what information you are going to have access to, when building your cube).
A Data Expression/s – the fields within your data container. Note: In many instances, particularly where Sage Intelligence Reporting ships solution sets for specific install bases, the first steps would already be in place. If this is the case, then start here at the next step.
Generate the Cube report you have created in your OLAP Module and this will create a new instance (or refresh an existing instance) of your .cub file.
Using the Sage Intelligence Reporting Report Manager, create a new Cube Report and use the cube you created in your OLAP Module as the data source for the report.
Select Cube report.
- Enter a name for the cube report.
Once the report is set up you would run this report which would render the data for your cube into Microsoft Excel just as a standard Sage Intelligence Reporting report would be run.
Finally, using Microsoft Excel as your cube browser allows you to use a Pivot Table to drag and drop the fields defined in your cube to view the same data in various ways. If you get to a point where a specific layout that you have created serves a specific need in your business and you want to keep this layout, you can do this by creating and linking your Microsoft Excel layout with the report in the Sage Intelligence Reporting Report Manager. Each time you run this report after doing a create and link process, your most recent layout will automatically be displayed when you re-run the report.
