Doubt about rebuilding the whole cube.

[CrystalBlood]

Hi!
Sorry for my english!

Congratulations about the component!
i have some doubt, i hope you could give a hand!

one of the wanted features is the possibility of easy upgrade the cube data without rebuilding the whole cube.
so i'm asking if that is posible in some way?

My imagination go far, with a picture of a real datawarehouse, with a ETL process or something, but apparently is not necesary..
the component provides some functionality about it?
I couldn't found.. is documented?

if the component allow the functionality, is posible to automatic the process periodically in some server, obtaining the cube builded-updated and ready to use?

[AlexZencovich]

Yes, it is possible. After set PivotCube.Active := True; (cube built) or PivotCube.Load From... just change dataset and call PivotCube.Build - it will not clear old cube but add new data from dataset to old.

Look at Demo app, menu item Update cube

[CrystalBlood]

I've built the cube in my application, and when run the upgrade, there's no checking about the data already loaded, i.e. if i have a cube with 500 records(facts), when i do a upgrade, appends another 500 records, having finally 1000 records...
that isn't especifically a updated cube.. it's more like a a double build.
i missed something? some property?

Thanks!

[AlexZencovich]

I've built the cube in my application, and when run the upgrade, there's no checking about the data already loaded, i.e. if i have a cube with 500 records(facts), when i do a upgrade, appends another 500 records, having finally 1000 records...
that isn't especifically a updated cube.. it's more like a a double build.
i missed something? some property?

Thanks!

Pity, but there are no way to check if data is really new or it just already loaded (in some cases we propably can do that by check datetime field but not in common case). There is task for person who knows data nature to build sql clause which will not use loaded data, like save last build datetime and limit sql clause for only new records or save some identity ID etc.

[CrystalBlood]

So, in the demo, there's no actually updating?

[AlexZencovich]

So, in the demo, there's no actually updating?

In demo that actually update cube but it does not make filter old?new records. It just show how to add new records to existed cube without rebuild fuill cube