Note: Make sure you have configuration/license keys configured, otherwise the dimensions that have no access of the field of OLTP will be removed.
Step # 1:
OLTP database synchronization of OLAP tables:
The following procedure is used to update the BI tables that are purely related to BI cubes and used as a dimension in the BI cubes. Before executing the procedure you need to perform some pre-requistes listed below:
1 - Go into Administration tab> Setup> Business Analysis> OLAP and click on OLAP Administration.
2 - A form will be opened.
3 - Go onto the Advanced tab of the form and mark the checkbox 'Update BI Data'.
4 - Press the button 'Update database'
You will observe that the BI related tables are filled and now these tables can be used for BI analysis after processing.
Step # 2:
OLAP database synchronization with OLTP database:
We know that OLAP has a different schema and is mapped directly to the OLTP tables in order to provide the records in OLAP cube's dimensions and measures.
Same form will be used to synchronize OLAP database. The only difference is that here we need to provide the datasource and the server where the OLAP database schema exist. For this task follow the steps below:
1 - Go onto OLAP Administration form.
2 - A form will be opened.
3 - Go onto the OLAP servers tab. Select the server (instance)
4 - Go onto the OLAP databases tab. Select the OLAP database.
5 - Now go onto the advanced tab, click on the checkbox Synchronise OLAP database with OLTP schema.
6 - Click update database button.
This will update the OLAP schema. Same procedure will be applied if you want database changes to be shown in OLAP schema after inserting any records in OLAP tables like CustTrans (When creating FTI), PurchTrans, LedgerTrans etc.
Soon, I will talk about how to update the OLAP database incase if you have any tables and want to use as a dimension and measures in the OLAP cubes..
