Hi,
I have done the hard part - created a Form Pivot Table in Access 2013 from an OLAP Cube using properties - ConnectionString and DataMember. The PivotTable works fine and gives me the result I want.
But I am stuck with the easy part - I want to use the result in a Query or Table (i.e. The totals it is showing in the pivot table.
How can I do this? I am a bit stuck as I am not sure if it is an SQL, select using Form parameters or PassThrough query.
Any suggestions will be much appreciated.
I have done the hard part - created a Form Pivot Table in Access 2013 from an OLAP Cube using properties - ConnectionString and DataMember. The PivotTable works fine and gives me the result I want.
But I am stuck with the easy part - I want to use the result in a Query or Table (i.e. The totals it is showing in the pivot table.
How can I do this? I am a bit stuck as I am not sure if it is an SQL, select using Form parameters or PassThrough query.
Any suggestions will be much appreciated.