OLAP Pivot

Hello All,

Not sure if this is the right part of the thread but does anyone know how to link to an olap cube? What i mean is, i can link it, create a pivot table and extract my data, but what i would like is to be able to set a table up a seperate table, and link that table to the olap cube so that i can create graphs from the table, without having to constantly refresh the olap pivot table as this is done automatically when dates are selected.

Any help would be appreciated.

Thanks

Use CUBE formulae, CUBESET, CUBEMEMBER, CUBEVALUE etc.

You get get a start by converting your existing pivot to a table by using PivotTable Tools>Options>OLAP Tools>Convert to formulas.