Fact tables Fixed Assets

The fact table Fixed assets is part of the Datamart FIXASSET (Fixed assets) as a whole.
It contains elements coming from:

• fixed assets
• depreciation plans
• subsidies
• physical elements
• expenses.
  

These data are reorganized in order to allow a simple elaboration of the reports in the BI:

- some information deemed secondary is not transmitted,
- conversely, other information is precalculated,
- finally, the information is restructured if needed.

Activity codes

The volume of information displayed in the environment using the Infoview tool is quite substantial.
It is possible to hide useless information by setting to 'No'' the activity codes globally assigned to the dimensions concerned, or the activity codes only assigned to the given fields of the fact table or of the various dimensions.
The following activity codes are suggested:

• BIF1 - Insurance
• BIF2 - Vehicule
• BIF3 - Market value
• BIF4 - Impairment loss
• BIF5 - Book vs. Tax provision
• BIF6 - Revaluation
• BIF7 - Exceptional depreciation
• BIF8 - Fiscal reintegration
• BIF9 - VAT
• BIF10 - Budget
• BIF11 - Deferred

Description

To this fact table are linked:

Synchronization rules

These are the rules used to define the way the data are extracted from the database and the way the fact table is loaded. There are 3 for the Fixed assetsfact table:

• EXPENSES: Fixed assets expenses with LAYOUTFAS as source table (expenses)
• DEPRECEXE: Financial year depreciations with DEPREC as origin table (depreciation plans)

Update 8.0.0 and higher: 

• PHYELT: Physical elements with PHYELT as source table (physical elements)

The table fields can be loaded directly via a base field or their value determined via a calculation formula or the call result to a function.

Dimensions

These are database tables such as the country tables, sites, accounting codes.
Some dimensions are part of the Fixed assets module and others are common to all the modules (Company, Site, Analytical dimension types etc.) and can be linked to multiple fact tables. Links have been defined between these various dimensions.
When a field in a fact table is linked to a dimension, the corresponding link expression is defined in the fact table (Links tab). The dimension list linked to the fact table Fixed assets is given below.

From the Hierarchies

These are pre-defined grouping criteria, used to navigate in the report according to the required detail level, by grouping or zooming on the detail of the hierarchy criteria.
These hierarchies are defined for the Datamart. They are detailed below.

Predefined conditions

These are conditions that will be used as filter criteria in the report itself. They are defined for each fact tables.
It can either be, simple conditions using fields or constants, or conditions requiring values (conditions corresponding to queries to be entered in the reports).
Their list is given below.

Sub-classes

In the fact table, each field with the object type: Measure can be identified as belonging to a sub-class. Thanks to the BO Infoview tool, this classification is used to display this information grouped by sub-class in the Fixed assets environment.

 The sub-classes list linked to the fact table Fixed Assets is provided below.

Technical additions

• Dimensions list
• Hierarchy list
• List of the predefined conditions
• Sub-classes list (Indicators)

Dimensions list

Common dimensions

• Company - COMPANY
  Source table: COMPANY
  Update type: Incremental
  
• Site - FACILITY
  Source table: FACILITY
  Update type: Incremental
   
• Currency - CURRENCY
  Source table: TABCUR
  Update type: Incremental

Version 7.2 and higher:

• Geographic site - GEOFCY
  Source table: FACILITY
  Update type: Incremental

Dimensions of the Fixed assets module
 

• Asset - Accounting code - FASACCOD
  Source table: GACCCODE
  Update type: Cancels and replaces
   
• Assets - FASASSETS
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Assets - Insurance contract - FASASSUR
  Source table: FXDASSETS
  Update type: Incremental
   
• Depreciation plan - FASDEPREC
  Source table: IMPAIRM
  Update type: Cancels and replaces
   
• Assets - Asset disposal - FASISSUE
  Source table: FXDASSETS
  Update type: Incremental
   
• Assets - VAT - FASTVA
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Assets - Vehicules - FASVEH
  Source table: FXDASSETS
  Update type: Cancels and replaces
   
• Depreciation contexts - FISCYEAR
  Source table: FISCYEAR
  Update type: Cancels and replaces
   
• Subsidies - GRANTS
  Source table: GRANTS
  Update type: Incremental
   
• Subsidies - Collection - GRTCASH
  Source table: CASHING
  Update type: Incremental
   
• Expenses - LAYOUTFAS
  Source table: LAYOUTFAS
  Update type: Cancels and replaces
   
• Localization - LOCALIZAT
  Source table: LOCALIZAT
  Update type: Incremental
   
• Physical elements - PHYELT
  Source table: PHYELT
  Update type: Cancels and replaces
   

Hierarchy list

• FASANA1 - Analytical dimension 1

- Company
- Site
- Dimension 1
- Account no.
- Asset reference

• FASANA2 - Analytical dimension 2

- Company
- Site
- Dimension 2
- Account no.
- Asset reference

• FASIMPIAS - IFRS Allocation

- Company
- Site
- Accounting code
- IFRS account
- Asset reference

• FASIMPPCG - CoA Allocation

- Company
- Site
- Accounting code
- CoA account
- Asset reference

List of the predefined conditions

Sub-classes list (Indicators)

Sub-classes 

• Financial help
• Exceptional depreciations
• Asset - Insurances
• Asset - Free amounts
• Asset - Social/IFRS amounts
• Asset - Asset disposal
• Asset - Local taxes
• Asset - VAT
• Intra-group sales
• Expenditure
• Expense - Free amounts
• Expense - Subsidies
• Write-off
• Book vs tax
• Fiscal deferred
• Depreciation charges
• Plan variances
• Physical elements - Free amounts
• Fixed Assets
• Revaluations
• Fiscal reintegration