Updating an Advanced Analytics data model
The update of an Advanced Analytics data model can be required if new fields are added to the tables/views that compose the data model. As of the redaction of this article, there exists a limitation in the beqom TCM product regarding the update of the data model using the normal process (through build for ElastiCube data models or in real-time for Live data models). However, a workaround is available to allow data models to be updated with any changes performed to the tables/view underlying the model.
To update an Advanced Analytics data model, proceed as follows:
After having performed the changes to the relevant table(s)/view(s), go to the TCM Admin Portal interface, and then navigate to (Undefined variable: CompoVariables_AP.Admin2) > Technical Admin > Synchronization & Data Security.
In the grid, locate search for the object(s) that you want to synchronize. You can type the name of the table(s)/views in the Name column search field.
Click the table/view in the list.
Click the synchronization icon in the toolbar located under the grid, as illustrated in the following figure:
Repeat the operation for each table/view that has been updated.
Switch to the TCM Web App interface, and then navigate to "Admin" > Data > Reporting Models.
Make sure you are in the Advanced Analytics tab of the Reporting Models page.
Locate, in the list of available models, the data model that you want to update and then click the corresponding box to open the model. The data model is opened.
Click the Add Sources button located at the right of the data source search bar. The Add Sources to Data Model contextual window is opened.
Select any data source in the list and then click Add and click Save at the bottom-right of the screen to see the columns of the newly added source.
Use the Refresh Schema button to refresh the data of the data model tables.
Remove the newly added data source by hovering the name of the data source and then clicking the icon located at the right of the name, as illustrated in the following figure:
Click Save in the lower right corner of the application window.
If your data model is an ElastiCube, click Build at the bottom of the window to rebuild the ElastiCube. The data model is now properly updated.