pass ado recordset directly to PivotCube?

[fjp]

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?

[AlexZencovich]

See

PCX.ADOConnection : _Connection
PCX.FactTableRecordSet : _RecordSet

also each dimension has property RecordSet : _RecordSet

[fjp]

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?

[AlexZencovich]

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