Incremental data load on essbase data

Fri, 24 Mar 2017 04:24:57 GMT

Hello

Has anyone done incremental data load to .qvd file from essbase.

We know that essbase data can be loaded to qlikview using essbase connector and then can be stored in .qvd file. The data can then be displayed in qlikview from the .qvd file. Now, I only want to query and store new essbase data pulled from source to .qvd file.

The main issue here is that data coming from essbase doesn't have any key or time-stamp. How can we proceed from here.

Thanks

Re: Incremental data load on essbase data

adamdavi3s — Fri, 24 Mar 2017 11:32:28 GMT

Without a key or timestamp its not simple to do, but you can create a hash128() using all the fields you need to use and then use this as your key, a bit of a faf but certainly workable.

The only tricky thing might be detecting updates and where old rows need to be removed.

topic Incremental data load on essbase data in QlikView

Incremental data load on essbase data

Re: Incremental data load on essbase data