Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.