Default data mart dimensions

By default, the Financial Management application provides a dimension definition for each of the default segments in the IT chart of accounts and for buckets.

Dimension definition Dimension table Transactional table
Business Service Dimension Business Service

[dm_table_cmdb_ci_service]

Business Service

[cmdb_ci_service]

Business Unit Dimension Business Unit

[dm_table_business_unit]

Business Unit

[business_unit]

Vendor Dimension Vendor

[dm_table_core_company]

Company

[core_company]

Note: Only companies with the Vendor check box selected are included in the Company dimension.

Cost Center Dimension Cost Center

[dm_table_cmn_cost_center]

Cost Center

[cmn_cost_center]

Location Dimension Location

[dm_table_cmn_location]

Location

[cmn_location]

Department Dimension Department

[dm_table_cmn_department]

Department

[cmn_department]

Portfolio Dimension Portfolio

[dm_table_pm_portfolio]

Hardware

[cmdb_ci_hardware]

Project Dimension Project

[dm_table_pm_project]

Project

[pm_project]

Server Dimension Server

[dm_table_cmdb_ci_server]

Server

[cmdb_ci_server]

Portfolio Dimension Portfolio

[dm_table_pm_portfolio]

Portfolio

[pm_portfolio]

IT Shared Service Dimension IT Shared Service

[dm_table_itfm_shared_service]

IT Shared Service

[itfm_shared_service]

Bucket Dimension Bucket

[dm_table_itfm_bucket]

Bucket

[itfm_bucket]

Weight Maps Dimension Weight Maps

[dm_table_itfm_weight_map]

Weight Maps [itfm_weight_map]
Note: The Bucket and Weight maps dimensions are not part of the IT chart of accounts by default, and you should not allocate expenses to them. The application uses these for report calculations.