Configuring an Advanced Analytics data model
In the context of beqom Advanced Analytics, a data model is set of tables/views (data sources) containing criteria and values that will be available to build analysis reports and dashboards. The data model is the foundation of the whole Advanced Analytics functionality.
Before the Advanced Analytics feature can be used in the beqom TCM application, at least one data model must be created and made available. The procedure outline herein describes the steps to be followed in order to create a data model from scratch.
Prerequisites
To be able to perform the configuration steps described herein, the profile you are using must have been granted the following rights:
To be able to import tables and views as described in the section Importing Tables and Views for Use in Advanced Analytics, your profile must have been granted full rights on table/view synchronization, under Admin Portal > Admin > Functional Admin > Profiles > <ProfileName> > Admin > Technical Admin > Synchronization & Data Security.
To be able to perform data model management tasks in Web App, as described starting with section Creating an Advanced Analytics Data Model in Web App, your profile must have been granted full rights on Advanced Analytics data model management under Admin Portal > Admin > Functional Admin > Profiles > <ProfileName> > Analysis > Administration > Advanced Analytics Data Models.
Importing Tables and Views for Use in Advanced Analytics
The first step in the configuration of an Advanced Analytics data model consists in importing (i.e. synchronizing) the tables and/or views that should be available for use in an Advanced Analytics data model. This operation must be performed in the Admin Portal interface of the beqom TCM application.
This is an attention message.
There is no mechanism to restrict the visibility of sources (tables/views) synchronized for use in Advanced Analytics; before importing any source, make sure that the data contained in the table/view is suitable for use by Advanced Analytics users.
To synchronize tables and/or views for use in Advanced Analytics data models, proceed as follows:
Log into beqom Admin Portal.
Open the (Undefined variable: CompoVariables_AP.Admin), and then navigate to Technical Admin > Synchronization & Data Security. A grid containing all the tables/views currently synchronized in the application is displayed.
Click Import in the lower-left corner of the grid; a new panel is opened under the grid, as illustrated in the following figure:
Table/view import
Select the table/view that you want to use as a data source by checking the box located on the left of the corresponding record in the grid. The list displayed in the panel contains all the tables and views available in the database that have not yet been imported in the system
In the Select Type drop-down list, located at the bottom of the secondary panel), choose the Advanced Analytics option, as illustrated in the following figure:
Import type
This step is crucial for the configuration of the data model. If this is step is not properly performed, users who create data models will not be able to see the table/view.
Click the green + button, located under the drop-down list. The table/view is imported; from this point on, the source can be used to build an Advanced Analytics data model.
Creating an Advanced Analytics Data Model in Web App
Once the tables/views have been synchronized in Admin Portal under the proper type, it is then possible to start building an Advanced Analytics in the Web App interface. To do so, proceed as follows:
This is a tip message.
Additional operations, such as the inclusion of additional data sources (tables/views) and the mapping of fields and tables are available as part of the management of data models. For more information, see Managing the Data Sources of an Advanced Analytics Data Model.
Preparing the Data Model for Use in Advanced Analytics Reports
Once the data model has been created, an additional step, which depends on the type of data model selected at the creation of the data model, needs to be performed before the data model can be used to create Advanced Analytics reports.
Building an ElastiCube Data Model
Publishing a Live Data Model
Sharing an Advanced Analytics Data Model
The last step in the creation of an Advanced Analytics data model consists in sharing the data model. This step ensures that the model can be used by other users, such as Advanced Analytics report designer users, to create report.
This is an note/information message.
Models that are not shared can only be used by their owner for the creation of reports and will not be visible to other users.
The Advanced Analytics data model is now ready to be used to create reports under the (Undefined variable: CompoVariables_WA.Analysis) of the Web Application interface.
Going Further
For the full documentation related to the creation and management of data models in WebApp, refer to Managing Advanced Analytics Data Models