Hi there,
Say I have a data package that:
1. Clear a subset of data defined by parameters ENTITY, CATEGORY, TIME sent through the Excel data manager
2. Import data from a table for the same selected ENTITY, CATEGORY, TIME
To clear the data subset in 1., I use the typical EXPORT ZERO and LOAD ZERO method. However, when the selected ENTITY, CATEGORY and TIME have no record yet in any of the 3 fact tables, the LOAD CUBE task fails. I forced it to "Success" using the ForceExecutionResult in SSIS but it causes the following BPC task to fail as well. If I disable the LOAD ZERO, the subsequent BPC tasks executes successfully.
How do we handle this LOAD ZERO thingy when there is no actual data in the database?
Thanks
Regis