Full load execution package not running

Hi Daniel, 

No, the package with objects added to Full load cannot be Executed manually. 

I made a new package, added in one table on the Included section and ran it.

Done in a few seconds and DW_TimeStamp got one more distinct value added - in other words, that didn't do a Full load (as expected to be honest).

Hi Stefan,

Quick check: Did you also add that table to the Full Load Section in the second tab?

Hi Daniel,

I didn't - but did now and Executed.

That seems to have worked! DW_TimeStamp is now, not unique, but all within the same second (it's a small table to test with).

So, in summary:

• Add the Incremental table(s) to Full load
• Add them to Include steps

Done?

Would it also work to just add the entire data warehouse (from ODX - DSA - MDW - SDM) in both tabs?

I'll probably won't go for that, but make a Perspective for all incremental tables and add that and let the ‘regular’ refresh solve the total reload up to my report.

Thanks!!

Dear Stefan,
Yes, you're summary is correct. Then you're done. 
It will work if you pick the ‘Execute Project’ which is everything. But this might be overkill. I use the Entire project sometimes and then Excluded tables through the Exclude Tables section (usually perspectives).

Working with the perspectives is a perfect way to load subsets of your DWH. Your proposal sounds good.
Take care!

Hi Stefan

Yes you can do that.

This is how I would set up a full load execution of my whole project.

I guess I'll do that, way less work as well than maintaining a perspective.