Line 3: | Line 3: | ||
<onlyinclude> | <onlyinclude> | ||
Welcome to the ''Physical Data Model {{#switch:{{#explode:{{FULLPAGENAME}}|:|2}} | Welcome to the ''Physical Data Model {{#switch:{{#explode:{{FULLPAGENAME}}|:|2}} | ||
− | |PDMMS=for a Microsoft SQL Server Database | + | |PDMMS |
+ | |GIMRef=for a Microsoft SQL Server Database | ||
|PDMOra=for an Oracle Database | |PDMOra=for an Oracle Database | ||
|PDMPostgre=for a PostgreSQL Database | |PDMPostgre=for a PostgreSQL Database | ||
Line 10: | Line 11: | ||
This document will help you make informed business decisions, based on the information that is collected by Genesys Info Mart. It will also help you understand how you can use the data that is collected by Genesys Info Mart to create reports. In brief, you will find the following information in this document: | This document will help you make informed business decisions, based on the information that is collected by Genesys Info Mart. It will also help you understand how you can use the data that is collected by Genesys Info Mart to create reports. In brief, you will find the following information in this document: | ||
− | *[[Documentation: | + | *[[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:GIMOverview:{{PONYDOCSVERSION}}|Overview]] and general information about the Info Mart database — [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartDBSchema:{{PONYDOCSVERSION}}|Info Mart database schema]], [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:TenantUserDBSchema:{{PONYDOCSVERSION}}|Tenant User database schema]], and [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:TenantViews:{{PONYDOCSVERSION}}|tenant views]] |
− | *[[Documentation: | + | *[[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:GIM850NewPDM:{{PONYDOCSVERSION}}|New in This Release]] information |
<!--*Subject area diagrams, depicting each Genesys Info Mart star schema--> | <!--*Subject area diagrams, depicting each Genesys Info Mart star schema--> | ||
− | *Descriptions of each dimensional model table and its columns and indexes — see [[Documentation: | + | *Descriptions of each dimensional model table and its columns and indexes — see [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartTables:{{PONYDOCSVERSION}}|Info Mart Tables]] |
− | *Descriptions of each dimension view and its columns — see [[Documentation: | + | *Descriptions of each dimension view and its columns — see [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartViews:{{PONYDOCSVERSION}}|Info Mart Views]] |
− | *Descriptions of important service tables and administrative views — see [[Documentation: | + | *Descriptions of important service tables and administrative views — see [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartAdminTablesViews:{{PONYDOCSVERSION}}|Info Mart Service and Staging Tables and Administrative Views]] |
*Summary lists of: | *Summary lists of: | ||
− | **[[Documentation: | + | **[[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartIndexes:{{PONYDOCSVERSION}}|Indexes]] |
− | **[[Documentation: | + | **[[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartReferences:{{PONYDOCSVERSION}}|References]] |
− | **[[Documentation: | + | **[[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartPartitioning:{{PONYDOCSVERSION}}|Partitioned tables]] |
Revision as of 15:06, March 26, 2017
Welcome
Welcome to the Physical Data Model for Genesys Info Mart for release 8.5DRAFT. This document, formerly called a Reference Manual, acquaints you with the subject areas and tables that make up the Genesys Info Mart star schemas.
This document will help you make informed business decisions, based on the information that is collected by Genesys Info Mart. It will also help you understand how you can use the data that is collected by Genesys Info Mart to create reports. In brief, you will find the following information in this document:
- Overview and general information about the Info Mart database — Info Mart database schema, Tenant User database schema, and tenant views
- New in This Release information
- Descriptions of each dimensional model table and its columns and indexes — see Info Mart Tables
- Descriptions of each dimension view and its columns — see Info Mart Views
- Descriptions of important service tables and administrative views — see Info Mart Service and Staging Tables and Administrative Views
- Summary lists of:
This document is valid only for the 8.5DRAFT releases of this product.
Comments or questions about this documentation? Contact us for support!