Setting Up Financial Consolidation Model

Return to the Financial Consolidation Model Overview

The Financial Consolidation model is a prebuilt, configurable Jedox application that includes an OLAP database, reports, Integrator procedures, and settings. It is available in the Jedox Marketplace.

Installing the Financial Consolidation model from the Jedox Marketplace

  1. In Jedox Web, open the Marketplace panel. Select "Install" for the Financial Consolidation model.
    Note: for models that are already installed locally, the user will be shown an “Open” button, which will open the model’s reports.

  2. The Install Package wizard shows the mandatory and optional packages for the model:

    The model comes with the extension package Financial Consolidation - Sample Data, which is selected for installation by default. This package contains dimension elements and figures for demonstration and education purposes. This sample data extension package is optional and can be turned off. Without the sample data, the model is ready to be configured to customer-specific needs, but before configuration, cubes and reports will mostly appear empty and may display errors.
    Click “Next >>”.

  3. The next page shows the license agreement for this package. The acceptance of the license agreement is mandatory to continue with the installation. Select “I accept the agreement” and click “Next >>”.

  4. The last wizard page shows a summary of the packages selected for installation and the chosen action (install, upgrade, or uninstall). Click “Finish” to start the installation procedure

  5. During installation, the wizard prompts for the OLAP database name:


    Accept the default database name or enter any other database name. If the database does not exist prior to the installation, it will be automatically created and populated with all database objects (such as dimensions, cubes, rules, etc.) that come with the installed packages. If the database does already exist, any missing database objects will be automatically created. If any of these objects already exist (e.g. because the same or another model sharing the same objects has been installed previously on that database), the creation of that object is skipped without any error. Multiple models installed on the same OLAP database can share their configuration and benefit from integration between cubes.

    The name of the OLAP database for a model is saved in the model setting system.database. For more information, see Models (Platform)

Repairing an installed model

An installed model that has been damaged can be repaired with the Repair Package wizard, which essentially performs an uninstallation followed by an installation on the same database.

  1. Export all added or modified files in the Models file group in Report Designer. The update will completely remove and replace the file group. Repeat for added or modified elements in Scheduler and Integrator. Added database objects and data in the OLAP database will remain, unless they are part of the packages being updated.
  2. In Jedox Web, open the My Models panel. Right-click on the Financial Consolidation model and select “Repair”.
  3. The Repair Package wizard shows the packages to be repaired with status “Repair”. Click “Next >>”.
  4. The last wizard page shows a summary of the packages selected for repair and the action "Repair". Click “Finish”.
  5. Restore the files, tasks, and projects saved in step 1. For modified web reports, such as //Models/Financial Consolidation/Configuration Reports/StylesheetFinancialConsolidation.wss, restore only a single file at a time using import or drag-and-drop. Do not restore multiple files or import a *.pb file, because this procedure would recreate the restored files with a new internal ID, thus breaking the links between multiple web reports.

Uninstalling the Financial Consolidation model

  1. In Jedox Web open the My Models panel. Right-click on the Financial Consolidation model and select “Uninstall”.
  2. The Change Package wizard shows the packages to be removed with status “Uninstall”. Click “Next >>”.
  3. The last wizard page shows a summary of the packages selected for uninstallation and the action "Uninstall". Click “Finish”.
  4. The above procedure removes the model from Reports, Report Designer, Scheduler, Integrator, and Administration Settings. However, the OLAP database is not removed. If the database is not used by other models and all data contained in it can be removed, then the database can be removed manually. To do so, open the Modeler panel, right-click on the database, and select “Delete …”.

Updated September 25, 2024