Creating a model
The BOD service creates a set of database views prefixed by PM_ within the CPM BOD database. These views facilitate creating a CPM model. A database view is a virtual table made up of a query on one or many tables in a database.
These views contain structure:
| View | Description |
|---|---|
| PM_ChartStructureDimensions | This view is created from the AccountingChart BOD. The AccountingChart BOD defines what code lists populate to up to 10 custom dimensions. |
| PM_Custom<1-10> | This view is populated by CodeDefinition BODs as specified by the accounting chart structure. |
| PM_RateView | This view is populated by the CurrencyExchangeRateMaster BOD. |
| PM_RateSetView | This view is populated by the CurrencyExchangeRateMaster BOD. |
| PM_ScheduleView | This view contains the schedule lines from ChartOfAccount BODs. |
| PM_StatementView | The two schedules supported by BODs are Balance Sheet and Income Statement. |
| PM_UnitView | This view is populated by Accounting Entities referenced within the BODs or by the first custom dimension in the chart structure, depending on which type of CPM BOD database was created. |
These views contain financial data:
| View | Description |
|---|---|
| PM_AmountDataView | This view is for summarized financial data sent in SourceSystemGLMovement BODs. This is the local, untranslated data to load into the CPM model. |
| PM_ExchangeRateDataView | This view is for currency exchange data sent in the CurrencyExchangeRateMaster BODs. You can load data using OpenLink. |
| PM_JournalDetailView | This view is for the underlying journal data sent in SourceSystemJournalEntry BODs. This view is used for drill through to journal detail from CPM. |