Refreshing SSAS cube

• VRT

  SSCertifiable

  Points: 5776

  More actions

  June 26, 2015 at 8:25 am

  #305403

  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.

  Thank You

• Paul Hernández

  SSCarpal Tunnel

  Points: 4961

  More actions

  July 1, 2015 at 3:39 am

  #1809408

  Hi,

  I didn't get your point but I think you are overcomplicating the things. You can fully control your incremental loads using a log table.

  Anyway, you can use DMV queries to get cube metadata.

  Please have a look here:

  Using DMV Queries to get Cube Metadata[/url]

  Kind Regards,

  Paul Hernández