Jump to: navigation, search
(Incorporating review feedback)
Line 28: Line 28:
 
{{Editgrn_open}}<font color=red>'''Writer's note:''' The following paragraphs are based on material on the Dep Guide [[Documentation:GIM:Dep:GIMDBModifs|"Completing Database Preparation"]] page.</font>{{Editgrn_close}}
 
{{Editgrn_open}}<font color=red>'''Writer's note:''' The following paragraphs are based on material on the Dep Guide [[Documentation:GIM:Dep:GIMDBModifs|"Completing Database Preparation"]] page.</font>{{Editgrn_close}}
  
Each Tenant User schema has a view on a single <tt>DATE_TIME</tt> table, so each schema supports a single time zone. To provide reports in multiple time zones, the downstream report developer must use a separate Tenant User schema for each time zone.
+
Each Tenant User schema has a view on a single <tt>DATE_TIME</tt> table, so each schema supports a single time zone. To provide reports in multiple time zones, the downstream report developer must use a separate Tenant User schema for each time zone.  
  
{{Editgrn_open}}<font color=red>'''Writer's note:''' Borys, as a related follow-up, please note that we don't provide details about how to actually create a separate Tenant User schema for a different time zone. Should we add anything under [[Documentation:GIM:Dep:GIMDBModifs#CreateViews|"Creating the Views"]] in the Dep Guide about how to specify a custom DATE_TIME table for the view?</font>{{Editgrn_close}}
+
The [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartDBSchema:{{PONYDOCSVERSION}}#TenantViewDiagram|Genesys Info Mart Data Organization and Tenant Views]] diagram shows a Tenant User schema that contains table views for only one tenant. However, to simplify deployment of the reporting solution, Genesys Info Mart supports creating table views for more than one tenant in the same Tenant User schema. Therefore, the tenant administrator does not need to create a separate Tenant User schema for each combination of time zone and tenant. Instead, the tenant administrator can include all tenants, or a group of tenants, in a single schema per time zone. <span style="background-color:{{{1|#33fcff}}};">For more information, see [[Documentation:GIM:Dep:GIMDBModifs#TenantViews|Creating Read-Only Tenant Views]] in the ''Genesys Info Mart 8.5 Deployment Guide.''</span>
 
 
The [[Documentation:{{PONYDOCSPRODUCTSHORT}}:{{#explode:{{FULLPAGENAME}}|:|2}}:InfoMartDBSchema:{{PONYDOCSVERSION}}#TenantViewDiagram|Genesys Info Mart Data Organization and Tenant Views]] diagram shows a Tenant User schema that contains table views for only one tenant. However, to simplify deployment of the reporting solution, Genesys Info Mart supports creating table views for more than one tenant in the same Tenant User schema. Therefore, the tenant administrator does not need to create a separate Tenant User schema for each combination of time zone and tenant. Instead, the tenant administrator can include all tenants, or a group of tenants, in a single schema per time zone.
 
  
 
{{Editgrn_open}}<font color=red>End of new, DG-based content</font>{{Editgrn_close}}
 
{{Editgrn_open}}<font color=red>End of new, DG-based content</font>{{Editgrn_close}}
Line 43: Line 41:
 
The structure of the views created in the Tenant User database schema is identical to that of their underlying dimension and fact tables or views in the Genesys Info Mart database schema. For this reason, subject area diagrams and descriptions for the Tenant User views are not provided in this document.
 
The structure of the views created in the Tenant User database schema is identical to that of their underlying dimension and fact tables or views in the Genesys Info Mart database schema. For this reason, subject area diagrams and descriptions for the Tenant User views are not provided in this document.
  
A Tenant User database schema contains the following views, as well as additional views that are created for custom user data tables:
+
A Tenant User database schema contains the following views, as well as additional views that are created for custom user data tables. <span style="background-color:{{{1|#33fcff}}};">For internal reasons in the case of some of the [[{{#replace:{{FULLPAGENAME}}|{{#explode:{{FULLPAGENAME}}|:|3}}|InfoMartDBSchema}}#DimensionViews|dimension views]], the Tenant User schema includes views of both the dimension view and its underlying table.</span>
 +
 
 +
<div><font color=red><span style="background-color:{{{1|#33fcff}}};">'''Writer's note:'''The list is now generated by query and therefore will update automatically going forward. The following tables weren't in the previous hard-coded list:
 +
{{ColumnFormat|content=
 +
* BGS_*
 +
* Callback_*
 +
* CDR_*
 +
* ChAT_SESSION_*
 +
* COBROWSE_*
 +
* GPM_*
 +
* GROUP_ANNEX
 +
* LDR_*
 +
* POST_CALL_SURVEY_*
 +
* RESOURCE_ANNEX
 +
* SDR_*
 +
* SM_MEDIA_NEUTRAL_STATE_FACT
 +
}}</span></font></div>
  
{{Editgrn_open}}<font color=red>'''Writer's note:''' Borys, (1) the following list was copied directly from the 8.1 PDF source when the PDM was converted to wiki, and the list was probably already out of date at that time -- e.g., GROUP_ANNEX and RESOURCE_ANNEX are missing, as well as SM_MEDIA_NEUTRAL_STATE_FACT, CALLBACK, SDR, and other new contribution-model tables. Should we rather replace it with an auto-generated list of links to the fact and dimension tables and views in the PDM, or else with links to the auto-generated lists on the [[InfoMartTables|Info Mart Tables]] and [[InfoMartViews|Info Mart Views]] pages? (2) Also, the list below includes some semi-duplicates for facts and dimensions -- e.g., the CALLING_LIST_TO_CAMP_FACT_  table as well as the CALLING_LIST_TO_CAMP_FACT view. Is this intentional? (3) Should CTL_GDPR_HISTORY be included?</font>{{Editgrn_close}}
 
 
{{ColumnFormat|cols=2|content=
 
{{ColumnFormat|cols=2|content=
* ANCHOR_FLAGS
+
{{#cargo_compound_query:
* ATTEMPT_DISPOSITION
+
tables=PDMTable;where=_pageName LIKE {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}|PSAAS="Documentation:GIM:Library:%%:{{#switch:{{PONYDOCSSTATUS}}|unreleased|preview=8.5DRAFT|released|#default=8.5PDMSource}}"|#default="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:{{#switch:{{PONYDOCSSTATUS}}|unreleased={{#explode:{{FULLPAGENAME}}|:|4}}|preview|released|#default={{#sub:{{#explode:{{FULLPAGENAME}}|:|4}}|0|3}}PDMSource}}"}} AND _pageName NOT LIKE "%GIM:Library:Table-CTL%" AND _pageName NOT LIKE "%Library:Table-STG%" AND _pageName NOT LIKE "%Library:Table-USER_DATA_CUST_DIM%" AND _pageName NOT LIKE "%Library:Table-IRF_USER_DATA_CUST%";fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:Table-',IF(SUBSTRING(tableName,-1)="_",SUBSTRING(tableName,1,(LENGTH(tableName)-1)),tableName),':{{#explode:{{FULLPAGENAME}}|:|4}}|',PDMTable.tableName,']]');limit=1000
* CALLING_LIST_METRIC_FACT
+
 
 +
|tables=PDMView;where=_pageName LIKE {{#switch:{{#explode:{{FULLPAGENAME}}|:|1}}|PSAAS="Documentation:GIM:Library:%%:{{#switch:{{PONYDOCSSTATUS}}|unreleased|preview=8.5DRAFT|released|#default=8.5PDMSource}}"|#default="Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:Library:%%:{{#switch:{{PONYDOCSSTATUS}}|unreleased={{#explode:{{FULLPAGENAME}}|:|4}}|preview|released|#default={{#sub:{{#explode:{{FULLPAGENAME}}|:|4}}|0|3}}PDMSource}}"}} AND _pageName NOT LIKE "%GIM:Library:View-ADMIN%" and _pageName NOT LIKE "%GIM:Library:View-CDR%" AND _pageName NOT LIKE "%GIM:Library:View-CTL%";fields=CONCAT('[[Documentation:{{#explode:{{FULLPAGENAME}}|:|1}}:{{#explode:{{FULLPAGENAME}}|:|2}}:View-',IF(SUBSTRING(viewName,-1)="_",SUBSTRING(viewName,1,(LENGTH(viewName)-1)),viewName),':{{#explode:{{FULLPAGENAME}}|:|4}}|',viewName,']]');limit=500
 +
 
 +
|format=ul
 +
}}
 
* CALLING_LIST_TO_CAMP_FACT_
 
* CALLING_LIST_TO_CAMP_FACT_
* CALL_RESULT
 
* CAMPAIGN_GROUP_SESSION_FACT
 
* CAMPAIGN_GROUP_STATE
 
* CAMPAIGN_GROUP_STATE_FACT
 
* CONTACT_ATTEMPT_FACT
 
* CONTACT_INFO_TYPE
 
* DATE_TIME
 
* DIALING_MODE
 
 
* GROUP_TO_CAMPAIGN_FACT_
 
* GROUP_TO_CAMPAIGN_FACT_
* INTERACTION_DESCRIPTOR
 
* INTERACTION_FACT
 
* INTERACTION_RESOURCE_FACT
 
* INTERACTION_RESOURCE_STATE
 
* INTERACTION_TYPE
 
* IRF_USER_DATA_GEN_1
 
* IRF_USER_DATA_KEYS
 
* IXN_RESOURCE_STATE_FACT
 
* MEDIATION_SEGMENT_FACT
 
* MEDIA_TYPE
 
 
* PLACE_GROUP_FACT_
 
* PLACE_GROUP_FACT_
* RECORD_FIELD_GROUP_1
 
* RECORD_FIELD_GROUP_2
 
* RECORD_STATUS
 
* RECORD_TYPE
 
* REQUESTED_SKILL
 
* REQUESTED_SKILL_COMBINATION
 
* RESOURCE_
 
* RESOURCE_GROUP_COMBINATION
 
 
* RESOURCE_GROUP_FACT_
 
* RESOURCE_GROUP_FACT_
 
* RESOURCE_SKILL_FACT_
 
* RESOURCE_SKILL_FACT_
* RESOURCE_STATE
+
}}
* RESOURCE_STATE_REASON
 
* ROUTING_TARGET
 
* SM_RES_SESSION_FACT
 
* SM_RES_STATE_FACT
 
* SM_RES_STATE_REASON_FACT
 
* STRATEGY
 
* TECHNICAL_DESCRIPTOR
 
* TIME_ZONE
 
* CALLING_LIST
 
* CALLING_LIST_TO_CAMP_FACT
 
* CAMPAIGN
 
* GROUP_
 
* GROUP_TO_CAMPAIGN_FACT
 
* PLACE
 
* PLACE_GROUP_FACT
 
* RESOURCE_GROUP_FACT
 
* RESOURCE_SKILL_FACT
 
* SKILL
 
* TENANT
 
* WORKBIN}}
 
 
</onlyinclude>
 
</onlyinclude>
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 13:47, May 22, 2019

Genesys Info Mart Tenant User Schema and Tenant Views

A Genesys-provided script, named make_gim_view_for_tenant.sql, is used to create read-only views to access data in the Genesys Info Mart fact and dimension tables.

The views are created in:

In a multi-tenant environment, the two types of views can be used in combination.

Views in the Genesys Info Mart Database Schema

The purpose of these views (referred to as tenant-specific views in the Genesys Info Mart Data Organization and Tenant Views diagram) is to provide read-only access to data in the Genesys Info Mart database schema for tenant users who are working only with the data for a particular tenant. A separate set of views is created for each particular tenant. When the tenant administrator creates these views by using the make_gim_view_for_tenant.sql script, the script generates the names for created views.

Multi-tenant deployment applications should query Genesys Info Mart data by using these read-only views, instead of querying the tables and views that reside in the Genesys Info Mart database schema.

To restrict data access in single-tenant deployments, use the same script to create a similar set of read-only views. The data organization for the Tenant User that is shown in the Genesys Info Mart Data Organization and Tenant Views diagram is applicable to single-tenant deployments in which data-access views are created.

Views in the Tenant User Database Schema

These views (shown within the Tenant User database schema in Genesys Info Mart Data Organization and Tenant Views) can be used to make data access more specific to the needs of a particular tenant user. The tenant administrator creates these views in a separate Tenant User database schemas by using the same make_gim_view_for_tenant.sql script.

Writer's note: The following material was formerly on the "Tenant User Database Schema" page, which will be deleted.

In addition to the Genesys Info Mart database schema, Genesys Info Mart supplies a script to create a separate database schema for each tenant, so that each tenant user can access only its tenant’s data. Because each tenant’s data is exposed through a different database schema, tenant administrators can control user access to tenant-specific data.

Writer's note: The following paragraphs are based on material on the Dep Guide "Completing Database Preparation" page.

Each Tenant User schema has a view on a single DATE_TIME table, so each schema supports a single time zone. To provide reports in multiple time zones, the downstream report developer must use a separate Tenant User schema for each time zone.

The Genesys Info Mart Data Organization and Tenant Views diagram shows a Tenant User schema that contains table views for only one tenant. However, to simplify deployment of the reporting solution, Genesys Info Mart supports creating table views for more than one tenant in the same Tenant User schema. Therefore, the tenant administrator does not need to create a separate Tenant User schema for each combination of time zone and tenant. Instead, the tenant administrator can include all tenants, or a group of tenants, in a single schema per time zone. For more information, see Creating Read-Only Tenant Views in the Genesys Info Mart 8.5 Deployment Guide.

End of new, DG-based content

Each Tenant User database schema contains:

  • Dimension views
  • Fact views

End of deleted page content

The structure of the views created in the Tenant User database schema is identical to that of their underlying dimension and fact tables or views in the Genesys Info Mart database schema. For this reason, subject area diagrams and descriptions for the Tenant User views are not provided in this document.

A Tenant User database schema contains the following views, as well as additional views that are created for custom user data tables. For internal reasons in the case of some of the dimension views, the Tenant User schema includes views of both the dimension view and its underlying table.

Writer's note:The list is now generated by query and therefore will update automatically going forward. The following tables weren't in the previous hard-coded list:
  • BGS_*
  • Callback_*
  • CDR_*
  • ChAT_SESSION_*
  • COBROWSE_*
  • GPM_*
  • GROUP_ANNEX
  • LDR_*
  • POST_CALL_SURVEY_*
  • RESOURCE_ANNEX
  • SDR_*
  • SM_MEDIA_NEUTRAL_STATE_FACT


  • CALLING_LIST_TO_CAMP_FACT_
  • GROUP_TO_CAMPAIGN_FACT_
  • PLACE_GROUP_FACT_
  • RESOURCE_GROUP_FACT_
  • RESOURCE_SKILL_FACT_
Comments or questions about this documentation? Contact us for support!