Traversing Grid/Map

[umerqadir]

Can I through the grid and save the data into a table?.. I want to do something like edit the grid and then save all the changes made back into a table which should contain all the rows loaded into the cube at leaf level

[AlexZencovich]

You should use event handler which fired after editing and use same way as we did to fill grid (loop over api calls to get values of individual cells over cube) to save values into facttable. Most complex task will locate corresponding facttable rows. But you may see example how to do that in VCL demo app (see for work with detail data set).

Must say it is quite uneasy task and you should be sure if your app still connected to DB (PivotCube mostly do not expect in constant database connection). You also should have PivotCube VCL source code to see how it works internally (editing)