Latest revision as of 15:02, December 23, 2019

Library Book for Unpublished GIM PDMs

Welcome to the Physical Data Model for Genesys Info Mart for release 8.5.0. This document, formerly called a Reference Manual, acquaints you with the subject areas and tables that make up the Genesys Info Mart star schemas.

Important

Starting with release 8.5.014.14 on August 30, 2019, Genesys Info Mart is part of 9.0. This document is valid only for the 8.5 releases of this product before Genesys Info Mart was part of 9.0. For 8.5 releases of Genesys Info Mart after August 30, 2019, see the DRAFT version of 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:

Overview and general information about the Info Mart database — Genesys Info Mart Database Schema and Genesys Info Mart Tenant User Schema and Tenant Views
New in This Release information, including a Summary of Info Mart Schema Changes
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:

@@ Line 1: / Line 1: @@
-= Welcome=
+= Library Book for Unpublished GIM PDMs=
 <onlyinclude>
-Welcome to the ''{{PONYDOCSMANUAL}}'' {{Editgrn_open}}for release {{PONYDOCSVERSION}}{{Editgrn_close}}. This document{{Editgrn_open}}, formerly called a ''Reference Manual,''{{Editgrn_close}} acquaints you with the subject areas and tables that make up the Genesys Info Mart star schemas.
+{{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}
+|PSAAS=
+|#default=Welcome to the ''Physical Data Model {{#switch:{{#explode:{{FULLPAGENAME}}|:|2}}
+|PDMMS
+|GIMRef=for a Microsoft SQL Server Database
+|PDMOra=for an Oracle Database
+|PDMPostgre=for a PostgreSQL Database
+|Library
+|#default= for Genesys Info Mart}}'' for release 8.5.0. This document, formerly called a ''Reference Manual,'' acquaints you with the subject areas and tables that make up the Genesys Info Mart star schemas.}}
+{{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}
+|PSAAS=
+|#default={{NoteFormat|Starting with release 8.5.014.14 on August 30, 2019, Genesys Info Mart is part of 9.0. This document is valid only for the 8.5 releases of this product before Genesys Info Mart was part of 9.0. For 8.5 releases of Genesys Info Mart after August 30, 2019, see the [[Documentation:GIM:{{#explode:{{FULLPAGENAME}}|:|2}}:{{#explode:{{FULLPAGENAME}}|:|3}}:{{#switch:{{#explode:{{FULLPAGENAME}}|:|4}}|8.5DRAFT=DRAFT|8.5PDMSource|8.5.0||#default=Current}}|{{#switch:{{#explode:{{FULLPAGENAME}}|:|4}}|8.5DRAFT=DRAFT|8.5PDMSource|8.5.0||#default=Current}} version]] of 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:GIM:{{PONYDOCSMANUALSHORT}}:GIMOverview:{{PONYDOCSVERSION}}|Overview]] and general information about the Info Mart database — [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartDBSchema:{{PONYDOCSVERSION}}|Info Mart database schema]], [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:TenantUserDBSchema:{{PONYDOCSVERSION}}|Tenant User database schema]], and [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:TenantViews:{{PONYDOCSVERSION}}|tenant views]]
+*[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:GIMOverview:{{#explode:{{FULLPAGENAME}}|:|4}}|Overview]] and general information about the Info Mart database — [[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartDBSchema:{{#explode:{{FULLPAGENAME}}|:|4}}|Genesys Info Mart Database Schema]] and [[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:TenantViews:{{#explode:{{FULLPAGENAME}}|:|4}}|Genesys Info Mart Tenant User Schema and Tenant Views]]
-*[[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:GIM850NewPDM:{{PONYDOCSVERSION}}|New in This Release]] information
+*[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:GIM850NewPDM:{{#explode:{{FULLPAGENAME}}|:|4}}|New in This Release]] information, including a [[{{#replace:{{FULLPAGENAME}}|{{#explode:{{FULLPAGENAME}}|:|3}}|InfoMartSchemaChanges}}|Summary of Info Mart Schema Changes]]
 <!--*Subject area diagrams, depicting each Genesys Info Mart star schema-->
-*Descriptions of each {{Editgrn_open}}dimensional model{{Editgrn_close}} table and its columns {{Editgrn_open}}and indexes{{Editgrn_close}} — see [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartTables:{{PONYDOCSVERSION}}|Info Mart Tables]]
+*Descriptions of each dimensional model table and its columns and indexes — see [[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartTables:{{#explode:{{FULLPAGENAME}}|:|4}}|Info Mart Tables]]
-*{{Editgrn_open}}Descriptions of each dimension view and its columns — see [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartViews:{{PONYDOCSVERSION}}|Info Mart Views]]{{Editgrn_close}}
+*Descriptions of each dimension view and its columns — see [[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartViews:{{#explode:{{FULLPAGENAME}}|:|4}}|Info Mart Views]]
-*{{Editgrn_open}}Descriptions of important service tables and administrative views — see [[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartAdminTablesViews:{{PONYDOCSVERSION}}|Info Mart Service and Staging Tables and Administrative Views]]{{Editgrn_close}}
+*Descriptions of important service tables and administrative views — see [[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartAdminTablesViews:{{#explode:{{FULLPAGENAME}}|:|4}}|Info Mart Service and Staging Tables and Administrative Views]]
-*{{Editgrn_open}}Summary lists of:{{Editgrn_close}}
+*Summary lists of:
-**{{Editgrn_open}}[[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartIndexes:{{PONYDOCSVERSION}}|Indexes]]{{Editgrn_close}}
+**[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartIndexes:{{#explode:{{FULLPAGENAME}}|:|4}}|Indexes]]
-**{{Editgrn_open}}[[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartReferences:{{PONYDOCSVERSION}}|References]]{{Editgrn_close}}
+**[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartReferences:{{#explode:{{FULLPAGENAME}}|:|4}}|References]]
-**{{Editgrn_open}}[[Documentation:GIM:{{PONYDOCSMANUALSHORT}}:InfoMartPartitioning:{{PONYDOCSVERSION}}|Partitioned tables]]{{Editgrn_close}}
+**[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartPartitioning:{{#explode:{{FULLPAGENAME}}|:|4}}|Partitioned tables]]
-This document is valid only for the 8.5.0 releases of this product.
 </onlyinclude>
-{{Editgrn_open}}<font color=red>Tanya, at least for immediate purposes, I think we'll have to go with a heads-up like the following note. Because of the very issue we're warning about, this note will have to be inserted manually on every RDBMS-specific Welcome page (which is why it's outside the onlyinclude tags here), because the transclusion call (which relies on a switch function and uses generic PONYDOCS variables to identify the required source) does not survive parsing for the PDF.</font>{{Editgrn_close}}
-{{NoteFormat|This document is currently available in online format only. For technical reasons associated with the way the online content is produced, PDF results are incomplete.}}
 [[Category:V:GIM:8.5DRAFT]]

Latest revision as of 15:02, December 23, 2019

Library Book for Unpublished GIM PDMs

Contact

Genesys

Customer Care

Legal