OLAP Pivot

happy_smiler1

New member
Joined
Aug 28, 2012
Messages
67
Reaction score
0
Points
0
Excel Version(s)
office 365
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 
Top