Major Tables
|
Prefix of the Table Name |
Description |
|---|---|
|
D_ |
[Dimension] – Each record represents a Dimension Member, including all its related attribute data. |
|
DO_ |
[Dimension Order] – Stores the Member ordering of a Dimension. |
|
F_ |
[Fact] – Store both numeric and text data, sliced by the Dimensionality of a Model. |
|
H_ |
[Hierarchy] – Stores the set of Members that define a Member List. Parent-child relationships can also be defined here. |
|
HO_ |
[Hierarchy Order] – Stores the Member ordering for a Member List. |
Staging Tables
|
Prefix of the Table Name |
Description |
|---|---|
|
DS_ |
[Dimension Staging] – Used with staging SP to merge Dimension data from the DS_ table into the D_ table. |
|
DSE_ |
[Dimension Staging Error] – Reporting any errors during a Dimension merge from staging to main. |
|
Staging_F |
[Staging Fact] – An optional table that can be used for staging Fact records. |
|
Staging_H |
[Staging Hierarchy] – An option table that can be used for staging member list records. |
Generated Tables
|
Prefix of the Table Name |
Description |
|---|---|
| DefinedSet_ | [Defined Set] – Each record represents a Dimension Member used to define the Defined Set of type MEMBERS. |
|
HC_ |
[Hierarchy Calculation] – Each record represents a Member Formulas for a Member. |
|
FH_ |
[Fact History] – Stores the historical changes to the associated F_ table from the writeback process. Can be used for audit trail to track data changes to a Model. |
|
Map_ |
[Mapping] – Defines the data for a form drop-down that are of type Dynamic-List. |
|
MF_ |
[Mapping Filter] – Used to define multi-filter selections for Dashboard Apps. |
|
NS_ |
[Nested Sets] – Holds hierarchy information for quick query searches on a Parent-child hierachy. |
|
SysCache_V_ |
[System Cached View] – Table generated by Kepion to materialized complex views as records in a table. Used internally for improved performance. |
Metadata Info Tables
|
Table Name |
Description |
|---|---|
| AllModelDimensions | Reference Information – list all Model Dimensions used by each Model (including Model Dimensions from the Linked Models). |
| DashboardForms | Reference Information – list Dashboard Forms by Dashboard within the Application. |
| DashboardPages | Reference Information – list Dashboard Pages by Dashboard within the Application. |
| Dimensions | Reference Information – list Dimensions within the Application. |
| FormAxis | Reference Information – list the Member Lists/Hierarchies used by a Form on ROW, COLUMN or FILTER axis. |
| Hierarchies | Reference Information – list Member List/Hierarchies within the Application. |
| ModelDimensions | Reference Information – list Model Dimensions by Model within the Application. |
| Models | Reference Information – list Models within the Application. |
| Partitions | Reference Information – list Partitions within the Application. |
Metadata Definition Tables
|
Table Name |
Description |
|---|---|
| ApplicationDefinedSets | Metadata table for Defined Sets. |
| ApplicationDrillthroughDefinitions | Metadata table for Transactional Drill-through definitions. |
| ApplicationMemberVariableMembers | Metadata table for Application Member Variable value. |
| ApplicationMemberVariables | Metadata table for Application Member Variable definition. |
| ApplicationInfo | Metadata table for the Application, including the database version number. |
| ApplicationVariables | Metadata table for the Application Standard Variable definition and value. |
| Authorizations | Metadata table for Apps that are configured through Administrator. |
| AuthorizationsNotificationTemplates | Metadata table for Notification email templates for the Application. |
| Dashboards | Metadata table for Dashboards. |
| FileContainers | Metadata table stored image content in the Application. |
| FileContents | Metadata table stored image content in the Application. |
| Files | Metadata table stored image content in the Application. |
| FileStores | Metadata table for File Stores. |
| Forms | Metadata table for Forms. |
| HistoricForms | Metadata table storing the historic record of Form edits. |
| HistoricRules | Metadata table storing the historic record of Rule edits. |
| Htmls | Metadata table for HTML definitions. |
| Rules | Metadata table for Rules. |
| Scripts | Metadata table for deployment Scripts. |
| MappingFilters | Metadata table for Mapping Filters. |
| Submissions | Metadata table for App Instances. |
System Tables
|
Table Name |
Description |
|---|---|
| AccountLogic_AccountType | Used in Chart of Account rollup logic. |
| AccountLogic_DebitCredit | Used in Chart of Account rollup logic. |
| AccountLogic_DebitCredit_Aggregation | Used in Chart of Account rollup logic. Determines the aggregation to use when aggregating from a child member to a parent member. |
| Activities | Writeback and rule activities are logged to this table. |
| ApplicationDeployment | Application deployment log. |
| ApplicationSettings | Internal use. |
| ppointedApprovers | Approvers for an App Instance. |
| ApproverAssignments | Approver chain defined for an App workflow. |
| AuthorizationsDashboardRules | Rules associated to a Dashboard App. |
| AuthorizationsDimensionPermission | Control write access to Dimension Member at the App level. |
| AuthorizationsFilterGroups | Global filter logic for Workbook Apps. |
| AuthorizationsFilterGroupsToForms | Global filter logic for Workbook Apps. |
| AuthorizationsFormRestrictions | Control access to Forms within a Workbook App. |
| AuthorizationsForms | Forms associated to a Workbook App. |
| AuthorizationsPageRestrictions | Page permission settings for a Dashboard App. |
| AuthorizationsRules | Rules associated to a Workbook App. |
| AuthorizationsUsers | Users associated to an App. |
| Constants | Internal use. |
| ContextOverrideFilter | Defines context override details. |
| ContextOverrideSettings | Defines context override settings, such as specifying the selected page for a Dashboard App. |
| DataPermissions | Data level permissions. |
| DimensionDataPermissions | Dimension Member permissions. |
| DummyAllMembers | Internal use. |
| ErrorCodes | Internal use. |
| ExtendedDataPermissions | Expanded data permissions. |
| ExtendedDimensionPermissions | Expanded dimension member permissions. |
| ExtendedModelAccesses | Expanded model access. |
| Filter_Modeler | Default form filter value defined in Modeler. |
| Filter_Planning | User-saved form filters by App Instance. |
| Filter_Planning_Empty | User-save form filtters that are empty by App Instance. |
| Formula_CoordinateDefinition | Internal use. |
| Formula_Expression | Internal use. |
| Formula_RHSTupleReference | Internal use. |
| Formula_UniqueName | Internal use. |
| Log | Application logs for performance analysis. |
| LogExtension | Details associated with the Application logs. |
| LoggingDashboardPageAccess | Log of user access by Dashboard Page. |
| ModelAccesses | Security table defining model access by user. |
| PartitionTracker | Internal use. |
| ProcessDetails | pplication process log. |
| RuleComponentProgress | Internal use. |
| RuleProgress | Internal use. |
| Session | Internal use. |
| SubmissionSettings | Override settings for submissions, e.g. starting page. |
| SysCache_Rules | Internal use. |
| SystemCheck | Internal use. |
| UpgradeSettings | Internal use. |
| UserAffiliations | User to group/role mapping. |
| UserRestrictions | Stores the restrictions defined for a user. |
| Users |
List of all users within the Application. |
System Views
| View Name | Description |
|---|---|
| [pub].[Dimension_Permission_{DimensionName}] | List of users and their associated dimension permissions when dimension security is enabled |