OBIA Finance Anlaytics

Chinmay Kale

Hello,

The Current project I am working on has OBIA 7.9.6.3 implemented and the full load was run around 9 years earlier by an EP which was custom built having all the seeded subject areas from HR, FINANCE and SCM.

We have custom ETL which populates almost many tables using custom workflows.

Now particularly talking about the scenario:

We have finance GL dashboards implemented using custom tables. Data is customized in w_gl_balance_f. The seeded dashboards were not visible to the client.

The Client now wants to see all the seeded analysis. The current data in the all the seeded dashboards whether it is AR/AP etc.. has data uptil when the full load was run (9 yrs from now).

Now we need to run the seeded EP only for Finance Anlaytics.

According to my research, we need to identify the confirmed dimensions and set the last refresh date  in DAC of those tables to a very old date to facilitate non-truncate incremental load.

Also update refresh date for Finance Analytics tables in  DW to NULL so that those would be executed in full load.

Now my question is If I run the Finance EP(full load disabled), which was not previously executed, will it truncate the tables(which I don't want as it would hamper my SCM and HR Analytics)

Thanks in advance.