Traversing Grid/Map

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Traversing Grid/Map

Postby umerqadir » Sat Jan 27, 2007 4:48 pm

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
umerqadir
User
 
Posts: 6
Joined: Wed Aug 23, 2006 6:41 am

Postby AlexZencovich » Tue Jan 30, 2007 2:23 am

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)
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 10 guests

cron