Hi
I wanted to do a incremental load of my cube.
My sql query for taking delta is this.
select column 1, column 2 ...column N from tableFact
where load_dt > current date - 1
This basically check the load date and find the records came newly from yesterday. I schedule this daily.
Lets think like the job failed on Sunday and no body available to take care. It picks Monday schedule automatically and should pull from Saturday to Monday (last successful date to current date).
what I thought is that I want to read the latest load date from SSAS Cube using MDX. can this be possible in SSIS package.