Report - Analysis
Choose the model from which you want to get the report and choose a report option.
Open workbook data or Consolidation
By choosing the option "Open workbook data or Consolidation" and press the button "Generate report" you will get the report includes all elements of IS2007 in this case.
You will see this consolidation result :
This is consolidation of all books.
Report cross information
By choosing the option "Report cross information" You will have the choice among eight types of schemes for your reports.
Report pivot table
By choosing the option "Report pivot table" You will have the opportunity to get the report of the elements you may indicate.
Visualizing information with Advanced Reports.
Consolidator Enterprise for Excel not only consolidates data -you can also use to make the most out of it and better analyze it by using a powerful reporting system that includes from Pivot Tables to cross sections at different levels.
In the right pane under Space of analysis data a structure will be loaded automatically.
This section will allow you to create different types of reports.
You can see in the circled area the same consolidation tree structure as in the left pane but with blank checkboxes by them, so you can select the books that will be part of the reports.
Scroll down the pane and you will see a section called Row Labels, which shows a number of items, from Units to Net Income/Unit . These items are created from the Template and the add-in has recognized them because they were colored using Consolidator Enterprise.
Continue scrolling down and you will see a section called Column Labels and shows the items January to December. These items are created from the Template and the add-in has recognized them because they were colored using Consolidator Enterprise.
Select the following items to generate reports:
You will get the following Pivot Table:
Another type of report is the cross section report. Included in this version are 8 sample report templates or forms to see how it operates.
In this example, click OK to work with the default option.
click on the Data Analysis item and click on the generate report button , as shown in the figure:
You will get the following Report:
If you want to save this selection of items for future reports, click on the Save button.
You have finished the example.
Some important restrictions should be taken into account: