We have one Execution plan loading all the BI Analytics module as of now.
2)Procurement and Spend,
3)Supply Chain and Order Management and
Issue is if i go to Tools-->ETL Management-->Reset Data Sources in DAC, it refreshes dates for all the Tables in the warehouse. ( and hence full load for all the Modules happens when i start the execution plan)
I dont want full load for other modules, just want to do full load for a particular Module lets say EAM Module ( and also want to make sure that this particular full load doesnt create issues with the data for other modules)
Let me know how to achieve this.
Any help in this regard would be highly appreciated.
Try to get the list of Fact (and dim) tables excluding common dims and set the refresh dates to NULL and start the load that would take care of EAM as full load and all other modules as Incr.
if helps mark
I can get a list of all the Facts and dimensions for a particular module from BI Apps Content guide... and then i can go and make refresh dates as Null for those Tables.
Now should i run the execution plan for one particular module or an Execution plan containing all the modules?
Cause i got this from someone..
"The Data models for the different modules have many common dimensions, so a reload of one module could leave the facts in another in an invalid state as the dimension keys would be moved.
Therefore it should not be expected that you can reload a module in isolation.
However, you can selectively do a reload of any table by resetting it's refresh date in the DAC console.
Then the DAC will determine the dependent objects that will also need a full load in order to maintain data consistency."
Since you got all modules in 1 EP and all these are based on 1 container you can go as I said. Leaving common dims aside setting refresh dates to null works but you need to do a test it to make sure all is well.
Its all depends on how you are maintaining with containers..
Since you got SIL mappings those take care of Insert and Updates you never have any issues as someone said to you.
Just do it you come to know what is right
just in case if you are flexible with going for multiple containers let me know.
sveerava at gmail or cool-bi.com
hope this helps
In this case assume that each module is from each container and all set in 1 EP.
for any module refresh can do any time that might followed with common dims but dac will take care of it.
do not pull rpd into this, no relation at all at this context
let me know what you see after the load
Moreover, when you create the execution plan, just select the subject area which you want to run and generate it.
Finally build your execution plan and run it..