Flex.bi Support Center
Flex.bi Support Center
Breadcrumbs

Odoo core measures and dimensions

flex.bi core dimensions for Odoo

flex.bi imports and analyzes Odoo Timesheets and Odoo Planning records via REST API and organizes them into shared analytical dimensions.

Timesheet entries come from account.analytic.line, tasks from project.task, projects from project.project, employees from hr.employee, employee categories from hr.employee.category, departments from hr.department, planning slots from planning.slot, and roles from planning.role.

Operational records in this context are timesheet lines and planning slots that track work performed, planned work, employees, projects, tasks, roles, and dates.

Dimension

Description

Time

Calendar date used for reporting. Timesheets use the timesheet date; Planning uses the planning slot end date.

Employee

Employee associated with a timesheet entry or planning slot. Includes employee status, category, and department information.

Employee Category

Employee category imported from Odoo employee categories and linked to the Employee dimension.

Employee Department

Department imported from Odoo departments and linked to the Employee dimension.

Task

Odoo task associated with a timesheet entry. The Task dimension also includes a Project level for analyzing task work by project.

Task Project

Project level inside the Task dimension, based on the project linked to the task. Includes project name and project status properties.

Project

Odoo project associated with timesheet entries and planning slots. Supports shared analysis across Timesheets and Planning.

Role

Planning role from Odoo Planning, imported as a separate dimension.

Planning Slot

Individual planning slot with slot identifier, start date, and end date. Planning slots are filtered to draft or published slots with allocated hours greater than zero.

Employee Dimension Property

Properties in the table below can be used if the Employee dimension is placed in rows.

Level

Property name

Source / notes

Employee

Employee Id

hr.employee.id; key field.

Employee Name

Name field.

Employee Status

Derived from active: Active or Inactive.

Employee Category Id

Imported from category_ids.

Employee Category

Category name from hr.employee.category.

Employee Department Id

Imported from department_id.

Employee Department

Department name from hr.department.

Task Dimension Property

Properties in the table below can be used if the Task dimension is placed in rows.

Level

Property name

Source / notes

Project

Project Real Name

Project name from project.project.name.

Task Project Status

Derived from project active: Active or Inactive.

Task

Task Id

project.task.id; key field.

Task Name

Task name from project.task.name.

Project Dimension Property

Properties in the table below can be used if the Project dimension is placed in rows.

Level

Property name

Source / notes

Project

Project Status

Derived from active: Active or Inactive.

Planning Slot Dimension Property

Properties in the table below can be used if the Planning Slot dimension is placed in rows.

Level

Property name

Source / notes

Planning Slot

Slot Start Date

planning.slot.start_datetime; date property.

Slot End Date

planning.slot.end_datetime; date property.

flex.bi core measures for Odoo

Odoo Timesheets Cube measures

These measures are calculated from Odoo timesheet entries in account.analytic.line.

Measure

Description

Timesheet Count

Count of imported timesheet entries. The value is set to 1 for each imported timesheet line.

Time Spent

Time spent from unit_amount on the timesheet entry. This measure can be shared with Odoo Planning.

Odoo Planning Cube measures

These measures are calculated from Odoo planning slots in planning.slot.

Measure

Description

Planning Slot Count

Count of imported planning slots. The value is set to 1 for each imported slot.

Effective Hours

Effective hours recorded on planning slots. This measure can be shared with Odoo Timesheets.

Allocated Hours

Allocated hours planned on planning slots. This measure can be shared with Odoo Timesheets.