Views
Different views are provided, model, import,
and business.
The Import View
The import view includes all database objects in the IBM® Controller datamart. You can use a query tool to retrieve this information for troubleshooting.
| Query subject | Description |
|---|---|
| DMACCF | Accounts in three levels: form, account, and account detail |
| DMACCT | Account names |
| DMFACT | Facts |
| DMTEMPLATE | Templates |
| DMTRACURR | Transaction currencies |
| DMFACTTEXT | Comments for fact rows. 3600 characters are allowed in comments. |
| DMFORMSECURITY | Form security: mapping user - form |
| DMCOMPSECURITY | Company security: mapping user - compid |
| DMCOMPTEXT | Other company texts, no relationship to other query subjects, used for stand alone reports |
| DMCOMPTEXTDESCR | Description for other company texts |
| DMCURR | Currencies |
| DMRELATIVE_PERIODS | Relative periods |
| DMACT | Actualities |
| DMACTT | Actuality names |
| DMCOMPF | Companies, 20 levels |
| DMEXTDIMF | Extended dimensions, 7 levels |
| DMEXTDIMT | Extended dimension names |
| DMEXTDIMNAME | Description of extended dimensions 1 - 4 |
| DMJOURNALTYPE | Journal types |
| DMJOURNALTYPET | Journal type names |
| DMCOMPT | Company names |
| DMEXTDIMSECURITY | Extended dimension security: mapping user - dim ID |
| DMCONSOLSTAT | Consolidation status, no relationship to other query subjects, used for stand alone reports. |
| DMREPSTAT | Company status, no relationship to other query subjects, used for standalone reports |
| DMPERIOD | Periods |
| DMGRP | Groups |
| DMGROUPSECURITY | Group security: mapping user - comp ID |
| DMCLOSVER | Closing versions, no relationship to other query subjects, used for grouping of journal types |
The Model View
The model view is normally used to retrieve data for reporting and analysis using products such as Report Studio.
Security
The Account, Company, and Extended Dimension query subjects include security filters to ensure that a user can access data only according to the IBM Controller user setup.
| Query subject | Description |
|---|---|
| ACCOUNT | Accounts in three levels: form, account, and account detail |
| ACTUALITY | Actualities |
| CLOSING VERSION | Closing versions, no relationship to other query subjects, used for grouping of journal types |
| COMPANY | Companies |
| COMPANY ADDITIONAL INFORMATION | Other company texts, no relationship to other query subjects, used for stand alone reports |
| COMPANY ADDITIONAL INFORMATION DESCRIPTION | Description for other company texts |
| COMPANY STATUS | Company status, no relationship to other query subjects, used for standalone reports |
| CONSOLIDATION STATUS | Consolidation status, no relationship to other query subjects, used for stand alone reports |
| CURRENCY | Currencies |
| EXTENDED DIMENSION 1 | Extended dimension 1, 7 levels |
| EXTENDED DIMENSION 2 | Extended dimension 2, 7 levels |
| EXTENDED DIMENSION 3 | Extended dimension 3, 7 levels |
| EXTENDED DIMENSION 4 | Extended dimension 4, 7 levels |
| FACT | Facts |
| FACT TEXT | Fact comments |
| GROUP | Groups |
| PERIOD | Periods |
| RELATIVE PERIODS | Relative periods |
| TEMPLATE | Templates |
| TRANSACTION CURRENCY | Transaction currencies |
The Business View
The business view is used only to group published objects. We recommend that you put all published query subjects in this view.