Cubes data guide

Introduction

Data cubes are an essential tool for the multidimensional analysis. This means that you can structure data with a view to facilitating analysis requests. They play a crucial role in creating interactive and dynamic reports along with dashboards, enabling you to display and explore complex data sets from multiple standpoints.

This guide will facilitate the use of Cubes to create reports and dashboards and provide a global vision of accessible data.

Prerequisites

Before you begin, ensure your development environment is configured correctly. You will need to activate or request the activation of certain privileges to be able to use the Cubes and their data:

• Manage Cube Privileges: Activate authorisations.

Cube Data Access Privilege Management: Activate rights for controlled access.

List of available cubes

Here is an ordered list of the different cubes available in our system, listed in alphabetical order:

• Accreditations

• Accredited users

• Badges

• Budget envelopes

• Commands

• Community follow up

• Curriculum

• Employee badges

• Establishments

• Evaluations

• Evaluation sessions

• External content

• External contents follow up

• Financial report

• Forecast plans

• Initial training

• Interview answers

• Interviews

• Interview needs

• Jobs

• Job-skills links

• Objectives

• Paths

• Presence of tutors on a session

• Professional projects

• Purchases

• Questions related to Adaptive Learning

• Quiz

• Recommendations

• Registrations

• Registrations for external contents

• Registrations on the curriculum

• Registrations to evaluations

• Registrations to a session

• Registrations on hold

• Registrations on hold for a curriculum

• Registration requests

• Resources

• Resource catalogue

• Sessions

• Skills

• Skills diagnostic with Adaptive Learning

• Special reports

• Specific requests

• Structures

• Trainings

• Training evaluations

• Training locations

• Training-skills links

• Training ratings

• Training costs

• Training needs

• Training requests

• Training sessions

• Training session costs

• Users

Cubes structure

Creating a report begins with a crucial step: choosing the cube on which to run the query. This choice determines the data table to be used for the analysis.

In the application, the Analysis section allows you to create various types of report (tables, radars, histograms, etc.) based on dimensions and values.

• A dimension is a categorisation element in a dataset, such as ‘learner’, ‘date’ or ‘institution’. String properties are represented by dimensions.

• When the chosen dimension represents an object, for example ‘User’, the data displayed is the name of this object.

However, choosing an object as the dimension or choosing the name of the object as the dimension (‘Full name’) is not entirely equivalent in the report: 2 entities with the same name will be considered as different entities in the first case, and as the same entity in the second case.

A value, on the other hand, is a property on which calculations can be performed (sum, average, minimum, maximum, etc.). For example, the number of times a user has registered for a session is a value, because it can be added together to obtain the total number of registrations. Numerical properties are therefore represented by values.

Please note that some cubes or dimensions mentioned in this document may not be visible in the client application, as some data is linked to specific licence keys.

Purchases

This cube provides an overview of purchases.

You can generate these types of reports:

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Payment

• Debitor

• Seller

• Articles

• Purchaser

Payment data axis

This data axis contains the following elements:

• Creation date

• ID

• Name

• Amount

• Currency

• Payment status

• Purchaser email address used to manage purchases

Debitor data axis

This data axis contains the following elements:

• Debitor name

• Debitor type

Seller data axis

This data axis contains the following elements:

• Management domain

• Creation date

• Name of the person who created the seller

• Seller name

• Seller email

Articles data axis

This data axis contains the following elements:

• Purchase procedure

• Availability start date

• Availability end date

• Article name

• Article amount

• Article currency

• Beneficiary:

  • Beneficiary name

  • Beneficiary type

Purchaser data axis

This axis contains the cube elements Users (described in the Users section) under the name Purchaser.

Badges

This cube offers a perspective on badges.

You can generate these types of reports:  

• Table

• Pivot table

• Table with hierarchy

It comprises a single data axis:

• Badge

Articles data axis

This data axis contains the following elements:

• ID

• Name

• Description

• Active

• Automatic attribution

• Type

• Management domain

Collaborator badges

This cube provides an overview of collaborator badges.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Badges des users

• Badges

• User

User badges data axis

This data axis contains the following elements:

• ID

• Attribution date

• Last modification date

• Level

Badges data axis

This axis contains the Badges cube elements (described in the Badges section).

User data axis

This axis contains the User cube elements (described in the Users section).

Training needs

This cube enables you to extract data on provisional training needs, providing detailed statistics on planned training within a forecast plan.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Need

• Manager's opinion

• Manager's arbitration

• Forecast plan

• Requested training

• Users concerned

• Requester

• Training

• Beneficiaries

• Registrations

• Registrations on hold

• Registrations requests

• Costs

Need data axis

This data axis contains the following elements:

• ID

• Management domain

• Import code

• Priority

• Type

• Desired date

• Description

• Legal typology

• Qualification

• Strategic axis

• Need transformation date

• Cancellation date

• Called

• Organisation mode

• Desired quarter

• Origin

• Text 1 (optional)

• Text 2 (optional)

• Text 3 (optional)

• Text enumeration 1 (optional)

• Text enumeration 2 (optional)

• Text enumeration 3 (optional)

Manager opinion data axis

This data axis contains the following elements:

• Manager opinion

• Manager opinion justification

• Text 4 (optional)

• Text enumeration 4 (optional)

Manager arbitration data axis

This data axis contains the following elements:

• Arbitration axis

• Justification

• Arbitration by

• Arbitration date

• Origin

• Text 5 (optional)

• Text enumeration 5 (optional)

Forecast plan data axis

This axis contains the Forecast plan cube elements (described in the section forecast plan).

Requested training data axis

This data axis contains the following elements:

• Training identified

• Title

• Need category

• Desired training provider

• Desired training location

• Estimated duration

• Theme

• Cost

• Collaborator cost

User concerned data axis

This data axis contains the following elements:

• Beneficiaries identified

• Number of beneficiaries

• Grade

• Socio-professional categories

• Type of contract

• Total cost

Requester data axis

This axis contains the Users cube elements (described in the Users section) under the name Requester.

Training data axis

This axis contains the Training cube elements (described in the Training section).

Beneficiary data axis

This axis contains the Users cube elements (described in the Users section) under the name Beneficiary.

Registration data axis

This axis contains the cube elements Registrations (described in the section Registrations).

Registration on hold data axis

This axis contains the Pending Registrations cube elements (described in the section Pending registrations).

Registration request data axis

This axis contains the Registration request cube elements (described in the section Registration request).

Costs data axis

This data axis contains the following elements:

• Costs per learner

• Global need costs

• Cost per nature:

  • Cost name

  • Nature of cost

  • Amount of cost

  • Import code

Interview needs

This cube enables you to extract information relative to training needs identified during an interview.

You can generate these types of report :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Training needs expressed in the interview

• User

• Training

• Need

Training data axis needs brought up during interview

This data axis contains the following elements:

• ID

• Name

• Description Type

• Priority

• Opinion

• Comment

User data axis

This axis contains the Users cube elements (described in the Users section).

Training data axis

This axis contains the Training cube elements (described in the Training section).

Need data axis

This axis contains the Training need cube elements (described in the Training needs section) under the name Need.

Training needs viewed from the catalogue

This cube is not directly accessible to clients, but is integrated in other cubes as part of another axis.

It comprises the following data axes:

Need:

• Training plan

• Manager opinion

• Arbitration manager

• Requested training

• Users concerned

• Costs

Need data axis

This data axis contains the following elements:

• ID

• Management domain

• Import code

• Priority

• Type

• Desired date

• Description

• Legal typology

• Qualification

• Strategic axis

• Need processing date

• Creation date

• Organisation mode

• Desired quarter

• Origin

• Text 1 (optional), Text 2 (optional), Text 3 (optional)

• Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional)

Training Plan data axis

This data axis contains the following elements:

• Name of the plan

• Plan management domain

• Start of the plan

• Plan end

• Start collaborator requests

• End collaborator requests

• Start manager requests

• End of manager requests

• Start arbitration

• End of plan

• Description of the  plan

Manager opinion data axis

This data axis contains the following elements:

• Manager opinion

• Justification of manager’s opinion

• Text 4 (optional), Text enumeration 4 (optional)

Manager arbitration data axis

This data axis contains the following elements:

• Arbitration status

• Justification

• Arbitrated by

• Arbitrated on

• Origin

• Text 5 (optional), Text enumeration 5 (optional)

Requested training data axis

This data axis contains the following elements:

• Training identified

• Title

• Need category

• Training provider desired

• Desired training location

• Estimated duration

• Theme

• Cost

• Employee cost

Users concerned data axis

This data axis contains the following elements:

• Beneficiary identifies

• Number of beneficiaries

• Grade

• Socio-professional category

• Type of contract

• Total cost

• Structures:

  • Structure

  • Id Structure

  • Code structure

  • Managers

  • Structures per level:

    • Structure level 0, Structure level 1, Structure level 2, Structure level 3, Structure level 4, Structure level 5, Structure level 6, Structure level 7, Structure level 8, Structure level 9

• Establishments:

  • Establishments

  • Establishments Id

  • Establishments Code

  • Managers

  • Establishments per level:

    • Establishments level 0, Establishments level 1, Establishments level 2, Establishments level 3, Establishment level 4, Establishments level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

• Projects

  • Projects

  • Id Project

  • Code Project

  • Managers

  • Projects per level:

  • Project level 0, Project level 1, Project level 2, Project level 3, Project level 4, Project level 5, Project level 6, Project level 7, Project level 8, Project level 9

• Teams

  • Teams

  • Team ID

  • Team Code

  • Managers

  • Teams per level:

    • Teams level 0, Teams level 1, Teams level 2, Teams level 3, Teams level 4, Teams level 5, Teams level 6, Teams level 7, Teams level 8, Teams level 9

• Referent group

  Referent groups

  • Referent Group Name ID

  • Referent group code

  • Managers

• Jobs

  • Jobs

  • Id Job

  • Code Job

  • Jobs per level:

    • Job level 0, Job level 1, Job level 2, Job level 3, Job level 4, Job level 5, Job level 6, Job level 7, Job level 8, Job level 9

• Costs:

  • Cost per learner

  • Cost global of the besoin

  • Cost per nature:

    • Cost name

    • Nature of the cost

    • Amount of cost

    • Import code

Financial report

This cube enables you to extract information on financial reports for training sessions, allowing you the possibility to generate detailed financial statistics for each session.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• Session

• Report

Session data axis

This axis contains the Session cube elements (described in the Session section).

Financial report data axis

This data axis contains the following elements :

• Result

• Total cost

• Total orders

• Remainder to finance

Resource catalogue

This cube enables you to extract data on resource consultations performed by users in the catalogue of resources.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• Resource

• Publication in the catalogue

• Publication in the back office

• User

Resource data axis

This data axis contains the following elements:

• Name of the resource

• Regrouping code

• Code

• Type of resource

• Name in the plan

• Type of element

• State of progression

• State of success

• Estimated duration in minutes

• Description

• Name of the person who created the resource

• Language

• Author

• Difficulty

• Keywords

• Subjects

• Used for AI

Publication to the catalogue data axis

This data axis contains the following elements:

• User destination

• Destination group

• Privilege

Publication in the back office data axis

This data axis contains the following elements:

• User destination

• Group destination

• Privilege

User data axis

This axis contains the Users cube elements (described in the Users section).

Commands

This cube enables you to extract data on orders relating to the financial statements for training sessions. It facilitates the production of statistics on expenditure incurred during sessions, corresponding to the purchases made for each session.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Point cloud

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Command

• Invoice

• Amount

• Supplier

• Accounting

• Session

Command data axis

This data axis contains the following elements:

• Name

• Code

• Number

• Cost nature

• Start date

• End date

• Comment

Invoice data axis

This data axis contains the following elements:

• Number

• Invoice received

• Reception date

• Invoice date

Amount data axis

This data axis contains the following elements:

• Price excl. tax

• VAT amount

• Cost incl. tax

Supplier data axis

This data axis contains the following elements:

• Supplier name

• Supplier phone

• Company registration number

• Zip code

• Supplier city

Accounting data axis

This data axis contains the following elements:

• Lot number

• Payment date

Session data axis

This axis contains the Session cube elements (described in the Session section).

Skills

This cube provides data relative to skills provided by users.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• User Skills

• User

• Skill

User data axis skills

This data axis contains the following elements:

• Skill ID

• Skill name

• Level (former calculation)

• Validation

• Validation comment

• Self-postioned comment

• User

• Modification date

• Action type

• Is the current skill

• Is favorite

• Self-positioned level

• Validated level

• Name of the person who validated

• Validation date

• Diagnostic level

• Diagnostic date

• Collaborator job

User data axis

This axis contains the Users cube elements (described in the Users section).

Skill data axis

This axis contains the cube elements Skill (described in the Skills section).

External content

This cube provides an overview of external contents.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• External content

• Appreciation

External contents data axis

This data axis contains the following elements:

• Id

• Name

• Themes

• Platform

• Duration in minutes

• Average mark

Appreciation data axis

This data axis contains the following elements:

• Average mark

• Number of opinions

• The number of people with the mark 5

• The number of people with the mark 4

• The number of people with the mark 3

• The number of people with the mark 2

• The number of people with the mark 1

Training costs

This cube enables you to extract data linked to costs entered for training for information purposes. It is used to create a potential training budget.

You can generate these types of reports:

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Name of the formation

• Cost

• Supplier

Cost data axis

This data axis contains the following elements:

• ID

• Name

• Nature

• Price excl. tax

• Type

Supplier data axis

This data axis contains the following elements:

• Supplier name

• Supplier type

• Supplier telephone

• Company registration number

• Zip code

• Supplier city

Training session costs

This cube enables you to extract data linked to costs on training sessions. It is used to generate statistics on revenues generated by sessions. Revenues are the costs of a session, whether collective or individual.

In the case of canceled but billed registrations, these costs are recovered.

Salary-type costs (learner, tutor) move up in this cube.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Session/Session

• Session code

• Registration

• Invoice

• Supplier

• Compatibility

Session class data axis

This data axis contains the following elements:

• ID

• Name

• Start date

• End date

Session code data axis

This data axis contains the following elements:

• Cost name

• Cost nature

• Order form number

• Comment

• Origin of the entrance

• Duration in time

• Scheduled

• Price excl. tax

• Invoiced

• Invoice date

• Import code

Registration data axis

This axis contains the cube elements Registrations (described in the section Registrations).

Invoice data axis

This data axis contains the following elements:

• Number

• Invoice received

• Reception date

• Invoice date

Supplier data axis

This data axis contains the following elements:

• Supplier name

• Supplier type

• Supplier phone

• Company registration number

• Zip code

• Supplier city

Accounting data axis

This data axis contains the following elements:

• Lot Number

• Payment date

• Text 1 (optional)

• Text 2 (optional)

• Text 3 (optional)

Curriculum

This cube enables you to extract data linked to curriculum. We find a record for each curriculum of the system in a table.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bar

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Curriculum

• Registration

• Administrative

• Theme

• Publication in the catalogue

• Training provider

Curriculum data axis

This data axis contains the following elements :

• ID

• Name

• Code

• Regrouping code

• Language

• Management domain

• Training provider

• Education level required

• Diploma achieved

• Targeted jobs

• Estimated time in hours

• Import code

• Creation date

• Modification date

• Description

• Specification condition

• Detailed program

• Objective

• Learning mode

• Text 1 (optional)

• Text 2 (optional)

• Text 3 (optional)

• Text 4 (optional)

• Text 5 (optional)

• Text 6 (optional)

• Text 7 (optional)

• Text 8 (optional)

• Text 1 enumeration (optional)

• Text 2 enumeration (optional)

• Text 3 enumeration (optional)

• Text 4 enumeration (optional)

• Text 5 enumeration (optional)

• Text 6 enumeration (optional)

• Text 7 enumeration (optional)

• Text 8 enumeration (optional)

• Text decimal 1 (optional)

• Text decimal 2 (optional)

• Text decimal 3 (optional)

• Published to the LXP

Registration data axis

This axis contains the Registrations cube elements (described in the Registrations section ).

Administrative data task

This data axis contains the following elements :

• Eligible under an individual training entitlement

• CPF code

• Training manager

• Administrative manager

• Validation type

• Imputable

• Training category action

• Organisation mode

Theme data axis

This data axis contains the following elements :

• Theme

• Theme level 0

• Theme level 1

• Theme level 2

• Theme level 3

• Theme level 4

• Theme level 5

• Theme level 6

• Theme level 7

• Theme level 8

• Theme level 9

Catalogue Publication data axis

This data axis contains the following elements :

• Destination user

• Destination group

• Privilege

Specific requests

This cube enables you to extract data linked to specific requests.

You can generate these types of reports :

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Requester

• Beneficiaries

• Request information

• Request status

• Cancellation

• Responding manager

• Responding provider

• Responding training manager

• Responding establishment manager

• Information on the response

• Information on the payment

• Requested training

• Proposed training

• Selected session

• Requested session

• Information on the processing

Requester data axis

This data axis contains the following elements:

• Name (Requester)

• First name (Requester)

• Structures (Requester)

  • Structure (Requester)

  • ID

  • Structure level 0 (Requester)

  • Structure level 1 (Requester)

  • Structure level 2 (Requester)

  • Structure level 3 (Requester)

  • Structure level 4 (Requester)

  • Structure level 5 (Requester)

  • Structure level 6 (Requester)

  • Structure level 7 (Requester)

  • Structure level 8 (Requester)

  • Structure level 9 (Requester)

Responder data axis

This data axis contains the following elements :

• Name (Responder)

• First name (Responder)

• Structures (Responder)

  • Structure (Responder)

  • ID

  • Structure level 0 (Responder)

  • Structure level 1 (Responder)

  • Structure level 2 (Responder)

  • Structure level 3 (Responder)

  • Structure level 4 (Responder)

  • Structure level 5 (Responder)

  • Structure level 6 (Responder)

  • Structure level 7 (Responder)

  • Structure level 8 (Responder)

  • Structure level 9 (Responder)

Question data axis

This data axis contains the following elements:

• Name of the question

• Created on (date)

Response data axis

This data axis contains the following elements:

• Contents of the response

• Responded on (date)

Registration requests

This cube is used to extract the list of training session registration requests. There is a record for each request.

Some information concerning the request process is consolidated on the request (validation date, user who validated the request, etc.).

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It is composed of the following data axes:

• ID

• Requester

• Beneficiary

• Request information

• Request status

• Cancellation

• Responding manager

• Responding provider

• Responding training manager

• Responding establishment manager

• Information on the response

• Information on the payment

• Requested training

• Proposed training

• Selected session

• Chosen training

• Requested session

• Information on provider processing

• Organizational response processed by

Requester data axis

This axis contains the Users cube elements (described in the Users section) under the name Requester.

Beneficiary data axis

This axis contains the Users cube elements (described in the Users section) under the name Beneficiary.

Information request data axis

This data axis contains the following elements:

• CPF

• Type of individual

• Quarter requested

• Year requested

• Theme

• Reason for the request

• Professional objectives

• Organisation mode

• Desired provider

• Desired location

• Estimated cost per person

• Requested duration

• Name of the requested training

• Description of the requested training

• Number of overnight stays

• Comment

Request status data axis

This data axis contains the following elements:

• Creation date

• Validation date

• Request status

• Origin of the request

• Registration date

• Registration time

• Description

Cancellation data axis

This data axis contains the following elements:

• Cancellation reason

• Cancellation comment

Responding manager data axis

This axis contains the Users cube elements (described in the Users section) under the name Responding manager.

Responding provider data axis

This axis contains the Users cube elements (described in the Users section) under the name Responding provider.

Responding training manager data axis

This axis contains the Users cube elements (described in the Users section) under the name Responding training manager.

Responding establishment manager data axis

This axis contains the Users cube elements (described in the Users section) under the name Responding establishment manager.

Information on the response data axis

This data axis contains the following elements:

• Manager validation date

• Manager comment

• Provider reception date

• Provider validation date

• Training manager validation date

• Training manager comment

• Establishment validation date

• Provider comment

• Reason for refusal

Information on the payment data axis

This data axis contains the following elements:

• Total registration cost

• Payment means

Requested training data axis

This axis contains the Training cube elements (described in the Training section) under the name Requested training.

Proposed training data axis

This axis contains the Training cube elements (described in the Training section) under the name Proposed training.

Selected session data axis

This axis contains the Training cube elements session (described in the Training section session) under the name Selected session.

Chosen training data axis

This axis contains the Training cube elements (described in the Training section) under the name Chosen training.

Requested session data axis

This axis contains the Training cube elements session (described in the Training section session) under the name Requested session.

Information on the provider data axis

This data axis contains the following elements:

• Request status

• Information request date

• Date of information reception

• Information request date

• Date provider information received

• First reminder date

• Second reminder date

• Internal comment

• Public comment

• Date of the first proposition

• Start planning date

• Time period of the first proposition

Organizational response processed by data axis

This axis contains the Users cube elements (described in the Users section) under the name Organizational response processed by.

Skills diagnostics with Adaptive Learning

This cube can be used to improve skills analysis by making adjustments to dates and labels, and by integrating new indicators for a more complete and accurate analysis of employee skills.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Skill diagnosis

• Collaborator

• Skill

Skill diagnosis data axis

This data axis contains the following elements:

• ID of the skill

• Skill name

• Collaborator name

• Skill evaluation modalities

• Type of diagnostic

• Is the latest diagnostic

• Self-positioning level

• Date of auto positioning

• Employee comment on auto positioning

• Level validated

• Validation manager date

• Name of the person who validated the skill

• Comment of the person who validated the skill

• Level evaluated by questionnaire

• Date questionnaire taken

• Employee job at the moment of the self-positioning

• Employee job at the moment of the validation (by the manager or by the quiz)

Organizational response processed by data axis

This axis contains the Users cube elements (described in the Users section) under the name Employee.

Skill data axis

This axis contains the cube elements Skills (described in the section Skills).

Jobs

This cube gives an overview of the jobs on the platform.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Job

• Job parent

• Job level 0

• Job level 1

• Job level 2

• Job level 3

• Job level 4

• Job level 5

• Job level 6

• Job level 7

• Job level 8

• Job level 9

• Related Job

• Attachments

• Members

• Managers

Job data axis

This data axis contains the following elements:

• Job ID

• Job code

• Job name

• Management domain

• Job creation date

• Job modification date

• Name of the person who created the job

• Name of the person who modified the job

• ExternalId

• Nature of the job

• Status of the job

• Type of job

• Objectives

• Job context

• Conditions of access

• Responsabilities

• Adaptives Learning activated

• Job Alias

Data Axes: Job parent, Job level 0, Job level 1, Job level 2, Job level 3, Job level 4, Job level 5, Job level 6, Job level 7, Job level 8, Job level 9, Job connexe

It's important to emphasise that the job follows a tree structure, where each Axis groups together the elements of the job mentioned above.

Attachments data axis

This data axis contains the following elements:

• ID of the attachments

• Name of the attachment

• ExternalId

• Url of the attachment

• Size of the attachment

• data axis  Members

This axis contains the Users cube elements (described in the Users section) under the name Members.

Managers data axis

This axis contains the Users cube elements (described in the Users section) under the name Managers.

Interviews

This cube enables you to extract data linked to interviews conducted by people in the system.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Interview

• Employee at the time of creating the interview

• Employee

• Manager

• HR

• Interview model

• Cancellation

Interview data axis

This data axis contains the following elements:

• ID

• Name

• Creation date

• Name of person who created the interview

• Modification date

• Name of the person who modified the interview

• Validity date

• Cancellation date

• Status of the interview

Employee when the interview is created data axis

This data axis contains the following elements:

• Employee at the moment of the creation of the interview

• User form

  • ID

  • Full name

  • Last name

  • First name

  • Name used

  • First name used

  • Née

  • Immatriculation

  • Civility

  • Categories

  • Sex

  • Date of birth

  • Age

  • Entry date

  • Departure date

  • Job title

  • Job entry date

  • Email

  • Type (optional)

  • Text 1 (optional), Text 2 (optional), Text 3 (optional), Text 4 (optional), Text 5 (optional), Text 6 (optional), Text 7 (optional), Text 8 (optional)

  • Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional), Text enumeration 4 (optional), Text enumeration 5 (optional), Text enumeration 6 (optional), Text enumeration 7 (optional), Text enumeration 8 (optional)

  • Date 1 (optional), Date 2 (optional), Date 3 (optional)

  • Type of work contract

  • Work contract type

  • Work time

  • Work time rate

  • Coefficient

  • Level of responsibility

  • Grade

  • Historisation date

• Structures:

  • Structure, Structure level 0, Structure level 1, Structure level 2, Structure level 3, Structure level 4, Structure level 5, Structure level 6, Structure level 7, Structure level 8, Structure level 9

• Establishments:

  • Establishment, Establishment level 0, Establishment level 1, Establishment level 2, Establishment level 3, Establishment level 4, Establishment level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

• Projects:

  • Project, Project level 0, Project level 1, Project level 2, Project level 3, Project level 4, Project level 5, Project level 6, Project level 7, Project level 8, Project level 9

• Domains:

  • Domain, Domain level 0, Domain level 1, Domain level 2, Domain level 3, Domain level 4, Domain level 5, Domain level 6, Domain level 7, Domain level 8, Domain level 9

Employee data axis

This axis contains the Users cube elements (described in the Users section) under the name Employee.

Manager data axis

This Axis of data contains the elements of the Employee at the time of the creation of the interview Axis of data mentioned above.

RH data axis

This data Axis contains the elements of the Employee at the time of the creation of the interview data Axis mentioned above.

Interview model data axis

This data axis contains the following elements :

• Name

• Code

• Description

• data axis  Cancellation

• This data axis contains the following elements:

  • Interview status

  • Cancellation motive

  • Description

Budget envelopes

This cube enables you to extract data linked to training envelopes (forecast plan). There is a recording for each envelope.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Envelope

• Forecast plan

• Structure

• Establishment

• Project

• Team

• Job

• data axis envelope

• This data axis contains the following elements :

  • ID

  • Name

  • Management domain

  • Amount

  • Nature

  • Theme

  • Import code

Forecast plan data axis

This axis contains the cube elements forecast plan (described in the section forecast plan).

Structure data axis

This data axis contains the following elements :

• Structure

• Id Structure

• Code structure

• Managers

• Structures per level:

  • Structure level 0, Structure level 1, Structure level 2, Structure level 3, Structure level 4, Structure level 5, Structure level 6, Structure level 7, Structure level 8, Structure level 9

Establishment data axis

This data axis contains the following elements :

• Establishment

• Id Establishment

• Code Establishment

• Managers

• Establishments per level:

  • Establishment level 0, Establishment level 1, Establishment level 2, Establishment level 3, Establishment level 4, Establishment level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

Project data axis

This data axis contains the following elements :

• Project

• Id Project

• Code Project

• Managers

• Projects per level:

  • Project level 0, Project level 1, Project level 2, Project level 3, Project level 4, Project level 5, Project level 6, Project level 7, Project level 8, Project level 9

Team data axis

This data axis contains the following elements :

• Team

• Id Team

• Code Team

• Managers

• Teams per level:

  • Team level 0, Team level 1, Team level 2, Team level 3, Team level 4, Team level 5, Team level 6, Team level 7, Team level 8, Team level 9

Job data axis

This data axis contains the following elements :

• Job

• Id Job

• Code Job

• Managers

• Jobs per level:

  • Job level 0, Job level 1, Job level 2, Job level 3, Job level 4, Job level 5, Job level 6, Job level 7, Job level 8, Job level 9

Establishments

This cube enables you to extract data linked to establishments.

You can generate these types of reports:  

• Table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Establishment

• Manager

• Member

• Establishment parent

• Establishment level 0

• Establishment level 1

• Establishment level 2

• Establishment level 3

• Establishment level 4

• Establishment level 5

• Establishment level 6

• Establishment level 7

• Establishment level 8

• Establishment level 9

Establishment data axis

This data axis contains the following elements:

• Establishment ID

• Establishment Code

• Establishment Name

• ExternalId

• Phone number

• Mobile number

• Short number

• Fax

• Address

• Zip code

• City

• Country

Responsable data axis

This axis contains the Users cube elements (described in the Users section) under the name Manager.

Member data axis

This axis contains the Users cube elements (described in the Users section) under the name Member.

data axis: Establishment Parent, Establishment level 0, Establishment level 1, Establishment level 2, Establishment level 3, Establishment level 4, Establishment level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

This data axis contains the following elements :

• Phone number

• Mobile number

• Short number

• Fax

• Address

• Zip code

• City

• Country

Evaluations

This cube enables you to extract evaluations-related data. There is a record for each evaluation.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Evaluation

• Publication in the catalogue

• Quiz

Evaluation data axis

• This data axis contains the following elements :

• ID

• Name of the evaluation

• Code

• Regrouping code

• Themes

• Language

• Management domain

• Category

• Targeted jobs

• Import code

• Evaluation cancellation date

• Description

• Objective

• Tokens

• Price per trainee

• Text 1 (optional), Text 2 (optional), Text 3 (optional)

• Text 1 numbering(optional), Text 2 numbering(optional), Text 3 numbering(optional)

• Number decimal 1 (optional), Number decimal 2 (optional), Number decimal 3 (optional)

• Date 1 (optional), Date 2 (optional), Date 3 (optional)

• Page layout:

  • Name

  • User title displayed

  • Code

  • Language

  • Priority

  • Domain

Evaluation data axis

This data axis contains the following elements:

• User recipient

• Group recipient

• Privileges

Quiz data axis

This data axis contains the following elements :

• Quiz

• Id Quiz

• Quiz name

• Code

• Regrouping code

• Difficulty of the quiz

Training evaluations

This cube enables you to extract data related to training assessments. Information on assessment quizzes and registrations for these assessments are data retrieved by this cube.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Responder

• Step of the process

• Session

• Class

• Learner

• Evaluation

Responder data axis

This axis contains the Users cube elements (described in the Users section) under the name Responder.

Process step data axis

This data axis contains the following elements:

• Quiz

• Name of the quiz

• Code

• Regrouping code

• Step name

• Type of step

• Actor role

• Registration start date

• Registration end date

Process step data

This data axis contains the following elements:

• Quiz

• Quiz name

• Code

Session data axis Session

This axis contains the Training cube elements session (described in the Training session section) under the name Session.

• Session data axis

• This data axis contains the following elements :

  • Session

  • Session Id

  • Name

  • Start date

  • End date

  • Location

  • Room

  • Equipment

  • Tutor

Learner data axis

This axis contains the cube elements Registrations (described in the section Registrations) with the learner.

Evaluation data axis

This data axis contains the following elements:

• Follow up:

  • Progression status

  • Success

  • Answer start date

  • Answer end date

  • Description

• Question:

  • Question

  • Id question

  • Question asked

  • Name of the question

  • Code of the question

  • Type

  • Axe

  • Section

• Question (studio):

  • Question (studio)

  • Id question (studio)

  • Question asked (studio)

  • Name of the question (studio)

  • Code of the question (studio)

  • Type (studio)

  • Axis (studio)

  • Section (studio)

• Answer:

  • Answer

  • Score achieved

  • Comment

• Score global:

  • Score achieved

  • Maximum quiz score

  • Normalised score achieved

  • Normalised score

• Score per axis:

  • Axis

  • Score achieved

  • Minimum score

  • Maximum score

  • Normalised achieved score

• Score per section:

  • Section

  • Score achieved

  • Minimum score

  • Maximum score

  • Normalised achieved score

Trainings

This cube enables you to extract data linked to training. There is a recording for each training course.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Training form

• Administrative

• Theme

• Catalogue publication

• Publication in the back office

• Main training provider

• Training providers

• Appreciation

Training form data axis Fiche Training

This data axis contains the following elements :

• ID

• Name

• Code

• Regrouping code

• Mandatory training

• Exclude from the 6-year review

• Training available on the mobile

• Consult the content after the registration date

• Consultation duration of the content after the registration end date

• Rules

• Learning modes

• Language

• Management domain

• Main training provider

• Training providers

• Category

• Study level required

• Target jobs

• Estimated time in hours

• Price per learner

• Prix per learner year N+1

• Prix per session

• Process user registration requests

• Processus manager registration requests

• Diploma achieved

• Import code

• Cancellation date of the training

• Number of the person who created the training

• Number of the person who modified the training

• Creation date

• Modification date

• Description

• Objective

• Content

• Training equipment

• Specific condition

• Published on the LXP

• Mutualised training

• Text 1 (optional), Text 2 (optional), Text 3 (optional), Text 4 (optional), Text 5 (optional), Text 6 (optional), Text 7 (optional), Text 8 (optional)

• Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional), Text enumeration 4 (optional), Text enumeration 5 (optional), Text enumeration 6 (optional), Text enumeration 7 (optional), Text enumeration 8 (optional)

• Date 1 (optional), Date 2 (optional), Date 3 (optional),

• Number of accesses

• Need category

• Duration of self-service access:

  • Duration

  • Unit

• Layout

  • Learner session: Name, Title displayed to user, Code, Language, Priority, Domain

  • Training in the catalogue: Name, Title displayed to user, Code, Language, Priority, Domain

Administrative data axis

It comprises the following data axes:

• Eligible for CPF

• CPF Code

• Training manager

• Imputable

• Training action category

• Administrative manager

• Organisation mode

• Type of validation

Theme data axis

This data axis contains the following elements:

• Quiz: Theme, Theme level 0, Theme level 1, Theme level 2, Theme level 3, Theme level 4, Theme level 5, Theme level 6, Theme level 7, Theme level 8, Theme level 9

Catalogue publication data axis

This data axis contains the following elements :

• Destination user

• Destination group

• Privilege

Back office publication data axis

This data axis contains the following elements :

• Destination user

• Destination group

• Privilege

Main training provider data axis

This axis contains the cube elements Training providers (described in the section Training providers) with the main Training providers.

Training providers data axis

This axis contains the cube elements Training providers (described in the section Training providers).

Appreciation data axis

This data axis contains the following elements :

• Average mark

• Number of opinions

• The number of people with the mark  5

• The number of people with the mark  4

• The number of people with the mark  3

• The number of people with the mark  2

• The number of people with the mark  1

Initial training

This cube enables you to extract data linked to initial training of directory users. We find a record for each initial training of a user in a table.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Initial training

• Administrative

Initial training data axis

This data axis contains the following elements :

• ID

• Name

• Description

• Establishment

• Start date

• End date

• Training type

• Training level

• Study level

• Name of the person who created the initial training

• Name of the person who modified the initial training

• Creation date

• Modification date

• Cancellation date

• Import code

• CPF

• Mandatory training

User data axis

This axis contains the Users cube elements (described in the Users section).

Accreditations

This cube enables you to extract data linked to accreditation. We find a record for each clearance of the system in a table.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Accreditation

• Initial training

• Renewal training

Accreditation data axis

This data axis contains the following elements:

• ID

• Name

• Code

• Domain

• Validity period in days

• Time period

• Start date

• End date

• Training type

• Training level

• Study level

• Name of the person who created the initial training

• Name of the person who modified the initial training

• Creation date

• Modification date

• Cancellation date

• Import code

• CPF

• Mandatory training

Initial training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Renewal trainings data axis

This axis contains the cube elements Trainings (described in the Training sections).

Registrations

This cube extracts the list of registrations to training sessions. There's a record for each registration.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Registration

• User

• History

• Session

• Curriculum registration

• Curriculum

• Follow-up

• Administrative

• Cancellation

• Costs of the registration

• Other

• Booking

• Need

Registration data axis

This data axis contains the following elements :

• ID

• Accepted as

• Priority registration

User data axis

This axis contains the Users cube elements (described in the Users section).

History data axis

This data axis contains the following elements:

• History

• User form

  • Last name

  • First name

  • Name used

  • First name used

  • Née

  • Immatriculation

  • Civility

  • Categories

  • Sex

  • Date of birth

  • Age

  • Entry date

  • Departure date

  • Job title

  • Entry date in the job

  • Address mail

  • Type (optional)

  • Text 1 (optional), Text 2 (optional), Text 3 (optional), Text 4 (optional), Text 5 (optional), Text 6 (optional), Text 7 (optional), Text 8 (optional)

  • Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional), Text enumeration 4 (optional), Text enumeration 5 (optional), Text enumeration 6 (optional), Text enumeration 7 (optional), Text enumeration 8 (optional)

  • Date 1 (optional), Date 2 (optional), Date 3 (optional)

  • Type of work contract

  • Nature of work contract

  • Work time

  • Work time rates

  • Coefficient

  • Level of responsibility

  • Grade

  • Historisation date

• Structures:

  • Structure, Structure level 0, Structure level 1, Structure level 2, Structure level 3, Structure level 4, Structure level 5, Structure level 6, Structure level 7, Structure level 8, Structure level 9

• Establishments:

  • Establishment, Establishment level 0, Establishment level 1, Establishment level 2, Establishment level 3, Establishment level 4, Establishment level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

• Projects:

  • Project, Project level 0, Project level 1, Project level 2, Project level 3, Project level 4, Project level 5, Project level 6, Project level 7, Project level 8, Project level 9

• Domains:

  • Domain, Domain level 0, Domain level 1, Domain level 2, Domain level 3, Domain level 4, Domain level 5, Domain level 6, Domain level 7, Domain level 8, Domain level 9

Session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions) under the name Session.

Curriculum Registration data axis

This axis contains the cube elements Curriculum registrations (described in the section Curriculum registrations).

Curriculum data axis

This data axis contains the following elements :

• Part of the curriculum

• Curriculum

• Id curriculum

• Name

• Code

• Management domain

Follow up data axis

This data axis contains the following elements:

• Presence

• Type of absence

• Justified absence

• Success

• Date of the latest success rate

• Date of the latest success rate (years)

• Date of the latest success rate (months)

• Date of the latest success rate (weeks)

• Date of the latest success rate (days)

• Progression

• First training access

• Last training access

• Import code

• Registration create date

• Registration start date

• Registration start date (years)

• Registration start date (months)

• Registration start date (weeks)

• Registration start date (days)

• Registration end date (years)

• Registration end date (months)

• Registration end date (weeks)

• Registration end date (days)

• Date of the first completion

• Date of the first success

• Certified

• Certification date

• Name of the person who created the registration

• Name of the person who modified the registration

• Description

• Reason for absence

• Comment

• Date of invitation

• Optional field 1, Optional field 2, Optional field 3

• Number of mails

• Number of reminders

• Estimated time for e-learning training (in minutes)

• Time spent on e-learning training (in minutes)

Administrative data axis

This data axis contains the following elements :

• Information:

  • Registration origin

  • Learner presence (invitation)

  • Mandatory training

  • Imputable

  • For

  • Training action category

  • Manager

• Operations:

  • Invitations

  • Training contract

  • Programme

• Financing:

  • Financing request

  • File numbers

  • Application date

  • Amount requested

  • Total funding

  • Total number of hours funded

• Funding solutions:

  • Type of funding

  • Amount obtained

  • Hours

• Work unit:

  • Registration

  • Postpone

  • Replacement

  • Date entry tool

  • Cancellation

• Accommodation:

  • Number of hotel nights

  • How

Cancellation data axis

This data axis contains the following elements :

• Is cancelled

• To invoice

• Reason for cancellation

• How to cancel

• Cancellation date or registration cancellation

Other data axis

This data axis contains the following elements :

• Text 1 (optional), Text 2 (optional)

• Text enumeration 1 (optional)

• Number decimal 1 (optional)

• Date 1 (optional)

Booking data axis

This data axis contains the following elements :

• Name of the group

• Number of group reservations

• Name of the person who created the reservation

• Name of the group targetted by the group

• Type of group targetted by the group

Curriculum booking data axis

This axis contains the Registrations cube elements for the curriculum (described in the section Curriculum Registrations).

Needs data access data axis

This axis contains the cube elements Training needs from the catalogue (described in the section Training needs from the catalogue).

Registrations for external contents

This cube extracts the list of registrations with external contents.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• User

• Follow up

• Session

• Training

User data axis

This axis contains the Users cube elements (described in the Users section).

Follow up data axis

This data axis contains the following elements :

• Domain

• Time spent

• Number of accesses

• Latest access

• Optional field

• Progression

• Date of the first completion

Session data axis

This data axis contains the following elements :

• Name

• Start date

• End date

• Optional field

Training data axis

This data axis contains the following elements :

• Name

• Import code

• Optional field

• Name of the partner

• Regrouping data

Registrations on the curriculum

This cube extracts the list of curriculum registrations.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• User

• Registration

• Cancellation

• Paths

User data axis

This axis contains the Users cube elements (described in the Users section).

Registration data axis

This data axis contains the following elements :

• Progression

• Success

• Date of the latest success rate

• Date of the first completion

• Creation date

• Name of the person who created the registration

• Modification date

• Name of the person who modified the registration

• Registration start date

• Registration end date

Cancellation data axis

This data axis contains the following elements :

• Is cancelled

• To invoice

• Cancellation motive

• How to cancel

• Date of cancellation

Path data axis

This axis contains the cube elements Path (described in the section Path).

Registrations to evaluations

This cube is used to extract the list of evaluation registrations.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• User

• Session

• Registrations to the curriculum

• Curriculum

• Quiz

• Follow up

• Question

• Question (studio)

• Answer

• Score

• Axe

• Section

User data axis

This axis contains the Users cube elements (described in the Users section).

Session data axis

This axis contains the cube elements Evaluation sessions (described in the section Evaluation sessions).

Registration data axis aux curriculum

This axis contains the cube elements Curriculum registrations (described in the section Curriculum registrations).

Curriculum data axis

This data axis contains the following elements:

• Is part of a curriculum

• Curriculum

• Curriculum ID

• Name

• Code

• Management domain

Quiz data axis

This data axis contains the following elements:

• Quiz

• Id Quiz

• Quiz name

• Code

• Regrouping code

• Quiz difficulty

Follow up data axis

This data axis contains the following elements:

• Progression status

• Success

• Date of 1st access

• Date of completion

• Import code

• Creation date

• Registration start date

• Registration end date

• Answer start date

• Answer end date

• Description

• Certified

• Date of certification

• Optional field 1, Optional field 2, Optional field 3

Question data axis

This data axis contains the following elements:

• Question

• Id Question

• Question asked

• Name of the question

• Code of the question

• Type of question

• Axe

• Section

Question (studio) data axis

This data axis contains the following elements:

• Question (studio)

• Id Question (studio)

• Question asked (studio)

• Name of the question (studio)

• Code of the question (studio)

• Type of question (studio)

• Axis (studio)

Answer data axis  

This data axis contains the following elements:

• User answer

• Points obtained

• How

Score data axis  

This data axis contains the following elements:

• Score achieved

• Maximum score

• Normalised achieved score

• Normalised score

Axe data axis  

This data axis contains the following elements:

• Axe

• Score achieved

• Minimum score

• Maximum score

• Normalised achieved score

Section data axis  

This data axis contains the following elements:

• Section

• Score achieved

• Minimum score

• Maximum score

• Normalised achieved score

Registrations to the session

This cube is used to extract the list of session registrations.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Learner

• Session

• Session participation

• Situation iterations

• Reflection phrases

Leaner data axis

This axis contains the cube elements Registrations (described in the section Registrations) with a learner part.

Session data axis

This axis contains the Sessions cube elements (described in the section Sessions).

Session participation data axis

This data axis contains the following elements:

• Presence of the learner

• Presence of the learner (Automatic attendance)

• Hours of presence

• Justified absence

• Type of absence

• Comment/Justification

• Success

• Progression status

Situational scenarios data axis  

This data axis contains the following elements:

• Name

• Start date

• End date

• Time spent (in minutes)

• Comment

• Place

• Room

Reflexive situational phases data axis  

This data axis contains the following elements:

• Name

• Start date

• End date

• Time spent (in minutes)

• Comment

Registrations on hold

This cube enables you to extract the list of registrations on hold for training courses or training sessions.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• User

• Training

• Session

• Follow up

• Administrative

• Other

• Need

User data axis

This axis contains the Users cube elements (described in the Users section).

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Session data axis

This axis contains the Training cube elements session (described in the Training session section).

Follow up data axis

This data axis contains the following elements:

• Import code

• Creation date of the registration on hold

• Cancellation date of the registration on hold

• Name of the person who created the registration on hold

• Name of the person who modified the registration on hold

• Name of the person who deleted the registration on hold

• Reason for the deletion of the registration on hold

• Description

• Desired date

• Period

• Year

• Comment

Administrative data axis

This data axis contains the following elements:

• Origin of the registration on hold

• Training action category

Other data axis  

This data axis contains the following elements:

• Accepted based on

• Priority registration

Need data axis  

This axis contains the cube Training needs elements seen from the catalogue (described in the section Training needs seen from the catalogue).

Registrations on hold for a curriculum

This cube extracts the list of registrations on hold on the curricula or path. There is a record for each registration.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• User

• Curriculum

• Path

• Follow up

• Administrative

• Registration

User data axis

This axis contains the Users cube elements (described in the Users section).

Curriculum data axis

This axis contains the cube elements Curriculum (described in the section Curriculum).

Path data axis

This axis contains the cube elements Path (described in the section Path).

Follow up data axis

This data axis contains the following elements :

• Import code

• Creation date of the registration on hold

• Cancellation date of the registration on hold

• Name of the person who created the registration on hold

• Name of the person who modified the registration on hold

• Description

• Comment

Administrative data axis

This data axis contains the following elements :

• Origin of the registration on hold

• Action category of the curriculum

Registration data axis

This data axis contains the following elements :

• Accepted for

• Priority registration

Jobs-skills links

This cube establishes the link between jobs and skills, by including the skill levels.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Job

• Skill

• Skill level

Job data axis

This axis contains the cube elements Jobs (described in the section Jobs).

Skill data axis

This axis contains the cube elements Skills (described in the section Curriculum).

Training-skills levels

This cube establishes the link between training and skills, also including the skill levels.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Training

• Skill

• Skill level

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Skill data axis

This axis contains the cube elements Skills.

Training locations

This cube extracts the list of training locations from the repository.

You can generate these types of reports:  

• Table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Global information

• Coordinates

• Rooms

• Training equipment

Global Information data axis

It comprises the following data axes:

• ID

• Name of the location

• Description of the location

• Code of the location

• Management domain of the location

• Import code

Coordinates data axis

It comprises the following data axes:

• Location address

• Location zip code

• Location city

• Location country

• Location time zone

• Phone

• Email

• Name of the access file plan

Rooms data axis

It comprises the following data axes:

• Rooms

• ID

• Name of the room

• Description of the room

• Code of the room

• Type of the room

• Number of places

Training equipment data axis

It comprises the following data axes:

• Training equipment

• Training equipment ID

• Name of the equipment

• Description of the equipment

• Code of the equipment

• Type of the equipment

Training ratings

This cube extracts the notes and comments made by training users, from the “Training notes” webpart.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Appreciation

• User

• Training

Appreciation data axis

It comprises the following data axes:

• ID

• Title of the comment

• Comment

• Note

• Date of the note

User data axis

This axis contains the Users cube elements (described in the Users section).

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Objectives

This cube enables you to extract data linked to objectives extracted from interviews, consolidated once a stage has been completed.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Interview objective

• Employee

• Interview

Interview objectives data axis

It comprises the following data axes:

• ID

• Label

• Description

• Creation date

• Created by

• Modification date

• Modified by

• Cancellation date

• Start date

• Due date

• Measures

• Means available

• Results

• Comment

• Plan of action

• Complete

• Priority

• Appreciation

• Type of objective

• Detail of the result obtained

• Category

• Weighting (in %)

  Level achieved (in %)

Employee data axis

This axis contains the Users cube elements (described in the Users section).

Interview data axis

This axis contains the cube elements Interviews (described in the section Interviews).

Paths

This cube enables you to extract data linked to curriculum paths.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Path

• Registration

• Administrative

• Cancellation

• Curriculum

• Training provider

Path data axis

It comprises the following data axes :

• ID

• Name of the path

• Code

• Start date

• End date

• Tutors

• Management domain

• Creation date

• Modification date

• Name of the person who created the path

• Name of the person who modified the path

• Training provider

• Status

• Description

Registration data axis

It comprises the following data axes :

• Number of current registrations

• Profitability threshold

• Capacity

• Registration closure date

• Registration mode

• Cost per trainee

• Cost per path

Administrative data axis

It comprises the following data axes :

• Organisation mode

• Training action category

• Imputable

• Eligible under an individual entitlement

• Administrative manager

Cancellation data axis

It comprises the following data axes :

• To invoice

• Is cancelled

• Cancellation motive

• Cancellation comment

• Cancellation date

Curriculum data axis

This axis contains the cube elements Curriculum (described in the section Curriculum).

Training provider data axis

This axis contains the cube elements Training provider (described in the section Training provider).

Forecast plans

This cube enables you to extract data linked to training plans (forecast plan).

You can generate these types of reports :  

• Table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Forecast plan form

Forecast plan data axis

It comprises the following data axes:

• ID

• Name

• Management domain

• Plan start

• Plan end

• Opening the gathering of employee needs

• End of the gathering of employee needs

• Open of manager needs gathering

• End of manager needs gathering

• Start of abitration

• Plan closure

• Description

Recommendations

This cube enables you to extract data linked to recommendations. You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Recommendations

• Comment

• Training

• Evaluation

• Users

• Quiz

• Evaluation session

• Training session

• Axe

• Section

Recommendations data axis

It comprises the following data axes :

• ID

• Creation date

• Name of the person who created the recommendation

• Modification date

• Name of the person ayant modified the recommendation

• Cancellation date

• Action to take

• Type of session context

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Evaluation data axis

This axis contains the cube elements Evaluations (described in the section Evaluations).

Users data axis

This axis contains the Users cube elements (described in the Users section).

Quiz data axis

It comprises the following data axes :

• ID

• Name

• Code

• Regrouping code

• Points minimum

• Points maximum

• Date creation

• Name of the person who created the quiz

• Modification date

• Name of the person who modified the quiz

• Cancellation date

Evaluation session data axis

This axis contains the cube elements Evaluation sessions (described in the section Evaluation sessions).

Training session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions).

Axe data axis

It comprises the following data axes :

• ID

• Name

• Code

• Creation date

• Name of the person ayant Createdl’axe

• Modification date

• Name of the person ayant modified l’axe

• Cancellation date

Section of the quiz data axis

It comprises the following data axes :

• ID

• Name

• Code

• Creation date

• Name of the person who created the section of the quiz

• Modification date

• Name of the person who modified the section of the quiz

• Cancellation date

Tutor presence

This cube enables you to extract data linked to the presence of tutors for a session.

You can generate these types of reports :

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Tutor

• Session

• Duration

Tutor data axis

This axis contains the Users cube elements (described in the Users section) under the name Tutor.

Session data axis

This axis contains the cube elements Sessions (described in the section Sessions).

Duration data axis

It comprises the following data axes :

• Duration

• Unit

Presence of tutors on a session

This cube enables you to extract data linked to the presence des tutors to a session.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• ID

• User

• Session

• Information per session

• Sessions

• Presence per session

User data axis

This axis contains the Users cube elements (described in the Users section).

Session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions).

Information session data axis

It comprises the following data axes :

• Presence

• Duration of travel in hours

• Duration of travel

  • Duration

  • Unit

Session data axis

This axis contains the cube elements Sessions (described in the section Sessions).

Presence per session data axis

• It comprises the following data axes :

  • Comment/Justification

  • Type of absence

  • Justified absence

  • Presence status

  • Duration of presence

    • Duration

    • Unit

Professional projects

This cube enables you to extract data linked to professional projects extracted from interviews, consolidated when a step is complete.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Professional projects interview

• Employee

• Interview

Professional projects interview data axis

It comprises the following data axes:

• ID

• Title

• Description

• Creation date

• Created by

• Modification date

• Modified by

• Validation date

• Cancellation date

• Comment

• Deadline

• Mobility type

• Establishments

• Other establishment

• Jobs

• Other job

Employee data axis

This axis contains the Users cube elements (described in the Users section) under the name Employee.

Interview data axis

This axis contains the cube elements Interviews (described in the section Interviews).

Questions related to Adaptive Learning

This cube will serve as a showcase for the data relating to the questions, including their name, identifier code, etc., as well as the proposals that make them up.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Question

• Proposition

• Skill

• Level of the question on the skill

• Number of times has been asked in an Adaptive test

• Average score

• Percentage of success/failure for this question

Question data axis

It comprises the following data axes:

• ID

• ExternalId

• Name of the question

• Code of the question

• Creation date of the question

• Modification date of the question

• Date of the person who created the question

• Name of the person who modified the question

• Question asked

• Type of question

• Feedback

• Author

• Keywords

• Axe

• Management domain

• Maximum number of choices

• Minimum number of choices

• Score calculation mode

Proposition data axis

It comprises the following data axes :

• Points attributed for the proposition

• Is selected as being the right answer

• Textual content of the proposition

Skill data axis

This axis contains the cube elements Skills (described in the section Skills).

Quiz

This cube extracts the answers provided by learners for each question in a quiz.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Quiz

• Estimated duration

• Score per axe

• Score per section

• Question

• Question (studio)

• Answer

• User

• Learner

Quiz data axis

It comprises the following data axes:

• Quiz

• Id Quiz

• Quiz name

• Code

• Regrouping code

• Description

• Difficulty of the quiz

• Language

• Keywords

• Subjects

• Name of the person who created the quiz

• Author

• Start date

Estimated duration data axis

It comprises the following data axes :

• Duration

• Unit

Score per axe data axis

It comprises the following data axes :

• Axe

• Score achieved

• Minimum score

• Maximum score

• Normalised achieved score

Score per section data axis

It comprises the following data axes :

• Section

• Score achieved

• Minimum score

• Maximum score

• Normalised achieved score

Question data axis

It comprises the following data axes :

• Question

• Id Question

• Question asked

• Name of the question

• Code of the question

• Type of question

• Axe

• Section

• Name of the person who created the question

• Author

Question (studio) data axis

It comprises the following data axes :

• Question (studio)

• Id Question (studio)

• Question asked (studio)

• Name of the question (studio)

• Code of the question (studio)

• Type of question (studio)

• Axis (studio)

• Name of the person who created the question (studio)

• Author (studio)

• End date

Score per answer data axis

It comprises the following data axes :

• User answer

• Points obtained

• XML answer

• Comment

• Comment of the trainer

• Order of propositions

User data axis

This axis contains the Users cube elements (described in the Users section).

Leaner data axis

This axis contains the cube elements Registrations (described in the section Registrations) under the name Learner.

Interview answers

This cube enables you to extract data linked to interview answers.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Employee

• Interview

• Answers

• Form

• Actor

Employee data axis

This axis contains the Users cube elements (described in the Users section) under the name Employee.

Interview data axis

This axis contains the cube elements Interviews (described in the section Interviews).

Answers data axis

It comprises the following data axes:

• Name of the question

• Visa - Confirmation text exchange

• Code of the component

• Type of component

• Type of answer

• Answer (text)

• Answer (date)

• Answer (yes/no)

• Answer (number)

• Answer (technical field)

• Visa – confirmation of the exchange

• Visa - validated

Form data axis

It comprises the following data axes :

• Name

• Status

• Validation date

• Step

Actor data axis

This axis contains the Users cube elements (described in the Users section) under the name Actor.

Resources

This cube can be used to extract learners on a resource-by-resource basis.

You can generate these types of reports :  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Resource

• Publication to the catalogue

• Publication to the back office

• User

• Training

• Registration

• Training sessions

• Forced updates

Resource data axis

It comprises the following data axes :

• Resource

• Id resource

• Name of the resource

• Regrouping code

• Code

• Year

• Type of resource

• Resource available on mobile

• Used for AI

• Name in the plan

• Type of element

• Progression status

• Success status

• Posted on

• Is posted

• Case study status

• Corrected on

• Corrected by

• Duration estimated in minutes

• Description

• Name of the person who created the resource

• Language

• Author

• Difficulty

• Keywords

• Subjects

• Corrected by the tutor

• Corrected by the manager

• Comment for HR

• Overall appreciation

• Creation date

• Cancellation date

Publication to the catalogue data axis

It comprises the following data axes :

• Destination users

• Destination group

• Privilege

Publication to the back office data axis

It comprises the following data axes :

• Destination users

• Destination group

• Privilege

User data axis

This axis contains the Users cube elements (described in the Users section).

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

Registration data axis

This axis contains the cube elements Registrations (described in the section Registrations).

Training session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions).

Forced update data axis

It comprises the following data axes :

• Date

• Name of the person who forced the update

• Comment

• Progression status

• Percentage progression

• Success

• Score

Sessions

This cube enables you to extract data linked to face-to-face elements present in the training design.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Sessions

• Locations

• Training session

Session data axis

• It comprises the following data axes:

• ID

• Name of the session

• Type of the session

• Start date

• End date

• Fuseau horaire

• Tutors

• Rooms

• Equipment

• Duration

• Description

Location data axis

This axis contains the cube elements Training locations (described in the section Training locations).

Training session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions).

Training sessions

This cube enables you to extract data linked to training sessions.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Profil

• Administrative

• Training

• Logistics

• Cancellation

• Path

• Training provider

• Bookings

Profile data axis

It comprises the following data axes :

• ID

• Name of the session

• Mandatory training

• Code

• Start date

• Start date

• End date

• Timezones

• Status

• Description

• Registration mode

• Profit threshold reached

• Target groups

• Registration closure date

• Domain

• Estimated time in hours

• Number of registrations

• Fill rate

• Number of places available

• Profit threshold

• Capacity

• Cost per learner

• Cost per session

• Training cost

• Number of cumulative hours of training for the session

• Import code

• Version en production

• Training provider

• Name of the person who created the session

• Creation date

• Modification date

• To invoice

• Is on a path

• Number of available places from the catalogue

• Number of current registration requests

• Number registrations on hold

• Text 1 (optional), Text 2 (optional), Text 3 (optional)

• Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional)

• Text decimal 1 (optional), Text decimal 2 (optional), Text decimal 3 (optional)

• Session type

• End date for the group session

• Mutualised session

Administrative data axis

It comprises the following data axes :

• Administrative manager

• Organisation mode

Training data axis

This axis contains the cube elements Training locations (described in the section Training locations).

Logistics data axis

It comprises the following data axes :

• Location

• Id location

• Location cancellation date

• Rooms

• Equipment

• Tutors

• Id tutors

Cancellation data axis

It comprises the following data axes :

• Is cancelled

• Cancellation motive

• Cancellations comment

• Cancellation date

Path data axis

This axis contains the cube elements Path (described in the section Path).

Training provider data axis

This axis contains the cube elements Training providers (described in the section Training providers).

data axis  Bookings

It comprises the following data axes :

• Total number of bookings

• Total number of registrations from a booking

• Name of the group

• Number of group bookings

• Name of the person who created the booking

• Name of the target group by the regrouping

• Type of group targeted by the regrouping

• User registered on the grouping

• Name of the person who registered the user on a grouping

Evaluation sessions

This cube enables you to extract data linked to evaluation sessions.

You can generate these types of reports:  

• Pie chart

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Profile

• Evaluation

• Estimated duration

• Evaluator

• Path

Profile data axis

It comprises the following data axes:

• ID

• Name of the session

• Code

• Start date

• End date

• Cost per learner

• Status

• Management domain

• Import code

• Is part of a path

Evaluation data axis

This axis contains the cube elements Evaluations (described in the section Evaluations).

Estimated duration data axis

It comprises the following data axes:

• Duration

• Unit

Evaluator data axis

This axis contains the Users cube elements (described in the Users section) under the name Evaluator.

Path data axis

This axis contains the cube elements Path (described in the section Path).

Training requests

This cube enables you to extract data linked to requests expressed by people on training in order to be notified of a new session.

You can generate these types of reports :  

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Request

• Training

• User

Request data axis

It comprises the following data axes :

• ID

• Creation date

• Cancellation date

Training data axis

This axis contains the cube elements Trainings (described in the Training sections).

User data axis

This axis contains the Users cube elements (described in the Users section).

Structures

This cube enables you to extract data linked to structures.

You can generate these types of reports:  

• Table

• Table with hierarchy

• Loop

It comprises the following data axes:

• Structure

• Manager

• Member

• Structure parent

• Structure level 0

• Structure level 1

• Structure level 2

• Structure level 3

• Structure level 4

• Structure level 5

• Structure level 6

• Structure level 7

• Structure level 8

• Structure level 9

Structure data axis

It comprises the following data axes:

• Id Structure

• Code structure

• Name of the structure

• ExternalId

• Phone

• Mobile

• Shortened number

• Fax

• Address

• Zip code

• City

• Country

Manager data axis

This axis contains the Users cube elements (described in the Users section) under the name Manager.

Member data axis

This axis contains the Users cube elements (described in the Users section) under the name Member.

Structure parent/Structure level 0/structure level 1/etc…

These data axes contain the same elements as the Data Structure axis.

Community follow up

This cube enables you to extract data linked to the community follow up.

You can generate these types of reports :  

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Follow up

• User

• Session

• Community group

• Message

• News

• Contribution

• Wiki page

• Quiz

• Case study

• Exam

Follow up data axis

It comprises the following data axes :

• ID

• Creation or access date

• Type of action

• Access the page

• Consultation

• Publication

• Correction

User data axis

This axis contains the Users cube elements (described in the Users section).

Session data axis

This axis contains the cube elements Training sessions (described in the section Training sessions).

Community group data axis

It comprises the following data axes :

• Name

• Description

• Import code

• Code

• Type

• Keywords

• Managers

Message data axis

It comprises the following data axes :

• Title

• Description

• Is pinned

• Date of the latest post

• Creation date

• Created by

• Modification date

• Modified by

• Cancellation date

• Forum

  • Title

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • Subject

News data axis

It comprises the following data axes :

• News:

  • ID

  • Title

  • Description

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • Number of comments

  • Keywords

• Comments

  • Comment

  • ID

  • Contents

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • User

Contribution data axis

It comprises the following data axes :

• Contribution

  • ID

  • Title

  • Description

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • Number of comments

  • Keywords

• Comments

  • Comment

  • ID

  • Content

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • User

Wiki page data axis

It comprises the following data axes :

• Wiki page

  • ID

  • Title

  • Description

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • Number of comments

  • Keywords

• Comments

  • Comment

  • ID

  • Content

  • Creation date

  • Created by

  • Modification date

  • Modified by

  • Cancellation date

  • User

Quiz data axis

It comprises the following data axes:

• Name

• Description

• Import code

• Creation date

• Created by

• Modification date

• Modified by

• Cancellation date

Case study data axis

It comprises the following data axes:

• Name

• Description

• Import code

• Creation date

• Created by

• Modification date

• Modified by

• Cancellation date

Exam data axis

It comprises the following data axes:

• Name

• Description

• Import code

• Creation date

• Created by

• Modification date

• Modified by

• Cancellation date

External contents follow up

This cube enables you to extract data linked to external content follow up.

You can generate these types of reports:  

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• Users

• Follow up

• External content

User data axis

This axis contains the Users cube elements (described in the Users section).

Follow up data axis

It comprises the following data axes :

• Id

• User start date

• User end date

• Time spent by the user in seconds

• Progress (percentage)

• Success rate

• Date of the last consultation

External content data axis

This axis contains the cube elements External contents (described in the section External content).

Users

This cube enables you to extract data linked to the directory.

You can generate these types of reports :  

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• User form

• Tutor characteristics

• Roles

• Groups

• Connections

User form data axis

It comprises the following data axes :

• ID

• Full name

• Last name

• First name

• Used last name

• User first name

• Née

• Immatriculation

• Civility

• Categories

• Sex

• Date of birth

• Age

• Entry date

• Seniority (years)

• Seniority (months)

• Seniority (weeks)

• Seniority (days)

• Exit date

• Active until

• Exit date (anonymisation)

• Year started

• Job title

• Preferred language

• Nationality

• Phone

• Mobile

• Do not send email

• Fax

• Email

• Zip code

• City

• Country

• Import code

• Type (optional)

• Comments (optional)

• User creation date

• User cancellation date

• Connection ID

• CGU validation date

• Timezone

• Management domain

• Text 1 (optional), Text 2 (optional), Text 3 (optional), Text 4 (optional), Text 5 (optional), Text 6 (optional), Text 7 (optional), Text 8 (optional)

• Text enumeration 1 (optional), Text enumeration 2 (optional), Text enumeration 3 (optional), Text enumeration 4 (optional), Text enumeration 5 (optional), Text enumeration 6 (optional), Text enumeration 7 (optional), Text enumeration 8 (optional)

• Date 1 (optional), Date 2 (optional), Date 3 (optional)

• Type of work contract

• Nature of the work contract

• Work time

• Work rate time

• Start of the work contract

• Coefficient

• Responsibility level

• Grade

• Is concerned by the interviews

• Status of professional projects

• Entry date in the structure

• Entry in the structure (in days)

• Entry in the structure (in weeks)

• Entry in the structure (in months)

• Entry in the structure (in years)

• Entry date dans the job

• Entry in the structure (in days)

• Entry in the structure (in weeks)

• Entry in the structure (in months)

• Entry in the structure (in years)

• Entry date dans the job

• Entry in the job (in days)

• Entry in the job (in weeks)

• Entry in the job (in months)

• Entry in the job (in years)

• Entry date in the Domain

• Entry in the Domain (in days)

• Entry in the Domain (in weeks)

• Entry in the Domain (in months)

• Entry in the Domain (in years)

• Entry date in the establishment

• Entry in the establishment (in days)

• Entry in the establishment (in weeks)

• Entry in the establishment (in months)

• Entry in the establishment (in years)

• Entry date in the post

• Entry in the post (in days)

• Entry in the post (in weeks)

• Entry in the post (in months)

• Entry in the post (in years)

Tutor characteristics data axis

It comprises the following data axes :

• Validity end date

• Tutor profile

• Training resource

Roles data axis

It comprises the following data axes :

• Role

• Id role

• Name of the role

• Profile code

• Domain

Groups data axis

It comprises the following data axes :

• Structures:

  • Structure:

    • Structure, Id structure, Code structure, Import code, Phone, Mobile, Shortened number, Fax, Address, Zip code, City, Country, Start date, End date, Parent structure (level -1), Parent structure (level -2), Structure manager, Email

  • Structures per level

    • Structure level 0,  Structure level 1, Structure level 2, Structure level 3, Structure level 4, Structure level 5, Structure level 6, Structure level 7, Structure level 8, Structure level 9

  • Structures IDs

    • Id Structure level 0, Id Structure level 1, Id Structure level 2, Id Structure level 3, Id Structure level 4, Id Structure level 5, Id Structure level 6, Id Structure level 7, Id Structure level 8, Id Structure level 9

  • Structure codes:

    • Code structure level 0, Code structure level 1, Code structure level 2, Code structure level 3, Code structure level 4, Code structure level 5, Code structure level 6, Code structure level 7, Code structure level 8, Code structure level 9

  • Structure managers:

    • Parent structure manager (level -1),  Parent structure manager (level -2), Structure level manager 0, Structure level manager 1, Structure level manager 2, Structure level manager 3, Structure level manager 4, Structure level manager 5, Structure level manager 6, Structure level manager 7, Structure level manager 8, Structure level manager 9

• Establishments

  • Establishment:

    • Establishment, Establishment ID, Establishement code, Import code, Phone, Mobile, Shortened number, Fax, Address, Zip code, City, Country, Start date, End date,  Establishment parent (level -1), Establishment parent (level -2), Establishment manager, Email

  • Establishments per level:

    • Establishment level 0,  Establishment level 1, Establishment level 2, Establishment level 3, Establishment level 4, Establishment level 5, Establishment level 6, Establishment level 7, Establishment level 8, Establishment level 9

  • Establishment managers:

    • Parent establishment manager (level -1),  Parent establishment manager (level -2), Establishment level manager 0, Establishment level manager 1, Establishment level manager 2, Establishment level manager 3, Establishment level manager 4, Establishment level manager 5, Establishment level manager 6, Establishment level manager 7, Establishment level manager 8, Establishment level manager 9

• Projects:

  • Project:

    • Project, Id Project, Code Project, Import code, Phone, Mobile, Shortened number, Fax, Address, Zip code, City, Country, Start date, End date, Parent project (level -1), Parent project (level -2), Project manager, Email

  • Projects per level:

    • Project level 0,  Project level 1, Project level 2, Project level 3, Project level 4, Project level 5, Project level 6, Project level 7, Project level 8, Project level 9

  • Project managers:

    • Parent project manager (level -1), Parent project manager (level -2), Project level manager 0, Project level manager 1, Project level manager 2, Responsable projet level 3, Project level manager 4, Project level manager 5, Project level manager 6, Project level manager 7, Project level manager 8, Project level manager 9

• Teams:

  • Management, Id manager, Email of the manager, Team, Id Team, Code Team, Manager N+2, Manager N+3, Manager level 0, Manager level 1, Manager level 2, Manager level 3, Manager level 4, Manager level 5, Manager level 6, Manager level 7, Manager level 8, Manager level 9

• The referent:

  • Referent, Id Referent, Email of the referent, Name of the referent group, Id Name of the referent group, Code referent group

• Domains:

  • Domain:

    • Domain, Id Domain, Code Domain, Cancellation date, Import code, Domain parent (level -1), Domain parent (level -2), Domain manager, Email

  • Domains per level:

    • Domain level 0,  Domain level 1, Domain level 2, Domain level 3, Domain level 4, Domain level 5, Domain level 6, Domain level 7, Domain level 8, Domain level 9

  • Domain managers:

    • Parent domain manager (level -1),  Parent domain manager (level -2), Domain-level manager 0, Domain-level manager 1, Domain-level manager 2, Domain-level manager 3, Domain-level manager 4, Domain-level manager 5, Domain-level manager 6, Domain-level manager 7, Domain-level manager 8, Domain-level manager 9

• Jobs

  • Job:

    • Job, Id Job, Code Job, Adaptive Learning activated, Alias, Cancellation date, Import code, Job parent (level -1), Job parent (level -2), Job manager

  • Jobs per level:

    • Job level 0,  Job level 1, Job level 2, Job level 3, Job level 4, Job level 5, Job level 6, Job level 7, Job level 8, Job level 9

  • Job managers:

    • Parent job manager (level -1),  Parent job manager (level -2), Job level manager 0, Job level manager 1, Job level manager 2, Job level manager 3, Job level manager 4, Job level manager 5, Job level manager 6, Job level manager 7, Job level manager 8, Job level manager 9

• Community group:

  • Community group

    • Community group, Import code, Id Community group, Code, Type, Keywords, Managers

• Training provider:

  • Training provider, Id Training provider, Training provider code, Import code, Training provider managers

• Dynamic groups:

  • Dynamic groups, Dynamic groups, Dynamic group code

Log on data axis

It comprises the following data axes :

• Log on time

• Log off time

• Current connection status

• Last logon date

Accredited users

This cube enables you to extract data linked to user accreditation.

You can generate these types of reports :  

• Histogram

• Bars

• Radar

• Cloud points

• Line

• Table

• Pivot table

• Table with hierarchy

• Loop

It comprises the following data axes :

• ID

• Attribution

• Accreditation

• User

Attribution data axis

It comprises the following data axes :

• Creation date

• Created by

• Modification date

• Modified by

• Attribution date

• End date

• Validity start

• Validity end

• Reminder date

• Last test date

• Last successful test

• Training provider

• Comment

• Historised

• Validity

• Validity status

• Text 1 (optional), Text 2 (optional), Text 3 (optional)

• Text enumeration 1 (optional)

• Date 1 (optional), Date 2 (optional)

• Import code

Accreditation data axis

This axis contains the cube elements Accreditations (described in the section Accreditations).