Data Mart Report Templates

Hello,

I have started to work on ‘out of the box’ crystal reports provided by Genesys on CCA reporting solution.
When updating the database source or location there are various statistics missing from the dma templates ie for agents the import layout does not include AV_T_CALLS or PC_T_CALLS. This means if I don’t match the statistics a lot of the available tables and data cannot be displayed making the report unusable.
Having checked the reporting technical reference 8.0 guide, it seems to state these additional statistics are taken from the data mart report template (which differ from the ods layout templates, but does not specify where they are or how they can be Imported into DMA.
This extract is taken from the same section of the guide:
ETL Runtime names these tables using a sequence stored in the database following a
specific naming convention. Refer to “Viewing the Report Query” on page 41 in the
“CC Analyzer Report Templates” chapter for naming convention details. ETL
Runtime then creates additional views (synonyms) using the ODS layout template
name. The out-of-box reports are configured to use these views.

Am I missing something?
thanks,

The extract of the guide you took is talking about how ETL runtime creates tables and views for each of the report layouts, views based on the template names. For example O_1_obj_dim and R_1_Stat_res for tables and O_Agent_Day and R_Agent_Day (template name layout was built from was “Agent”). That doesn’t determine the stats and column names that are set up in the in the templates and used in the layouts in DMA though.

Are you saying the statistics are missing in the DMA layout templates under statTypename when you import ? Are you sure they are part of the XML import? If I remember correctly when you import the layouts should create both the layout and the statistics used in the layout. Have you checked the XML file to make sure the statistic exists in it?

The xml ‘agent’ file only has the 28 statistics as described in the ods layout section.
Whereas the data mart ‘agent’ template has 76 statistics.

I was expecting there to be an xml template available containing the 76 statistics if genesis are producing out of box reports containing a lot of these.
BR,