pass ado recordset directly to PivotCube?

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

Moderator: Alex Zencovich

pass ado recordset directly to PivotCube?

Postby fjp » Thu Mar 06, 2008 11:01 pm

No doubt I've missed an example - but, is it possible to pass an ado recordset to pivotcube? By this I mean, to create a recordset, and then assign that to a property of pivotcube, without setting the connection string property of pivotcube, etc?

If so, can you point me to an example showing this method of building a cube?
fjp
Guest
 
Posts: 2
Joined: Thu Feb 14, 2008 7:30 pm

Postby AlexZencovich » Fri Mar 07, 2008 6:21 am

See

PCX.ADOConnection : _Connection
PCX.FactTableRecordSet : _RecordSet

also each dimension has property RecordSet : _RecordSet
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

Postby fjp » Fri Mar 07, 2008 6:48 am

AlexZencovich wrote:See

PCX.ADOConnection : _Connection
PCX.FactTableRecordSet : _RecordSet

also each dimension has property RecordSet : _RecordSet


Thanks, Alex - so, if I'm understanding properly, you can pass a retrieved record set, but you set the pivotcube's adoconnection property to the recordsets connection property?
fjp
Guest
 
Posts: 2
Joined: Thu Feb 14, 2008 7:30 pm

Postby AlexZencovich » Fri Mar 07, 2008 5:40 pm

yes. if you have _Recordset, you should have Adoconnection anyway. Actually I do not sure - may be you may pass recordset without set up adoconnection, I just never check that way.

BTW. You shouild alsoe set

PCX.ConnectionType = dstADO

and

PCX.Dimensions[].DimensionType = dtRuntime
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 2 guests

cron