Results 1 to 2 of 2

Thread: OLAP Pivot

  1. #1

    OLAP Pivot



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •