• Step 1 : Download one of the models attached to this article (at the bottom of the page): DemoAbraxio_v2.pbit or DemoAbraxioBasic_v1.pbit
• DemoAbraxio_v2: If you were already using our previous model "v1", this new version allows you to also use the project/activity analytical axes (available in the model and in the "Budget Analysis" example tab)
• DemoAbraxioBasic_v1: Example without data transformation, with a model very close to that exposed by our APIs
  

• Step 2 : When opening the model, the Abraxio API URL is already populated, you still have to fill in the authentication elements specific to your environment ( click here to access the documentation on authentication at (API):
  

To use these files, your API access must have at least the dataset.finance.read and dataset.portfolios.read scopes.

• Step 3 :

When loading the data, you will need to check the box "Ignore privacy level controls for this file":

Error loading data

If you encounter the above error message when loading data, you must modify the confidentiality parameters in your file in the following configuration:

DemoAbraxio Model

This file loads and transforms the data retrieved from the Abraxio APIs to feed a model that allows advanced reporting (comparisons between financial years, orders and archives).

Example reports

• Budget analysis
  

• Choice of a budget year or an archive/decree
• The first 2 personalized analytical axes of the Finance module
  
• The first 2 personalized analytical axes of the Portfolios module
  

• Budget breakdown

• Comparisons

• Monthly comparisons

Description of the sample file data model

• Projects: List of projects with their qualifiers. These projects are linked to the financial years and archives/orders, so we find in this table one occurrence of project per financial year, archive or order containing it.
  
• ProjectsDimensionsValues: Detail of the values of the analytical axes of the projects
  
• ProjectsDimensionsDescription: Description of the analytical axes of the projects
  
• Budgets: List of budgetary years
• Snapshots: List of archives/orders, as well as an entry named "Budget" corresponding to the "current" budget of each financial year in order to build the advanced financial year/archive/orders selector in the "Comparisons" report example
• Lines: List of budget lines (which come from the budget for a financial year, from a decree, or from an archive)
• LinesSchedules: Monthly schedule associated with a budget line
• LinesDimensionsValues: Detail of the values of the analytical axes of a budget line
• BudgetDimensionsDescription: Description of the configuration of the analytical axes of a budget line

Update September 2024: the v2 model loads detailed values for the analytical axes of projects and offers filters on the first two axes configured in the “Budget Analysis” example.

DemoAbraxioBasic Model

This file loads a "raw" model (similar to the one exposed by the APIs) from the Abraxio APIs and provides some example reports.

Example reports

• Budget analysis
  

This report presents KPIs on your budget (build/run distribution, opex/capex, projects/activities) and the budget distribution by category of the CIGREF reference.

The available filters are:

• Choosing a budget year
• The first 2 personalized analytical axes of the Finance module
  
• The first 2 personalized analytical axes of the Portfolios module
  

• Budget breakdown

If you use one or more analytical axes broken down as a percentage on your budget lines, this report allows you to choose the financial year and select the analytical axis on which the report relates.

The report presents quality analysis KPIs (percentage of total budget allocated) and a detailed table of the breakdown by projects/activities.

• Monthly comparisons

This report allows you to compare your € and JxH budgets between different financial years to be selected on the left.

1. Analysis of orders
   

This report presents the same graphs as the budget analysis but covers the decrees/archives.

1. Budget approved and broken down
   

This report is the same as the budget breakdown but covers the orders/archives.

Description of the sample file data model

Here is the schema of the data model that powers the reports described above:

• Budgets: List of budgetary years
• Snapshots: List of archives/orders of a financial year
  

The model is then similar to detail the entire budget for a financial year or an archive/decree with the following tables (prefixed with Snapshots for the archives/decrees):

1. Projects: List of projects with their qualifiers. These projects are linked to the exercises.
   
2. ProjectsDimensionsValues: Detail of the values of the analytical axes of the projects
   
3. ProjectsDimensionsDescription: Description of the configuration of the analytical axes of the projects

• BudgetLines: List of budget lines
• BudgetLinesSchedules: Monthly schedule associated with a budget line
• BudgetLinesDimensions: Detail of the values of the analytical axes of a budget line
• BudgetDimensionsDescription: Description of the configuration of the analytical axes of a budget line