Results 1 to 2 of 2

Thread: OLAP Pivot

  1. #1
    Acolyte happy_smiler1's Avatar
    Join Date
    Aug 2012
    Posts
    67
    Articles
    0
    Excel Version
    office 365

    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
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,808
    Articles
    0
    Excel Version
    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.

Posting Permissions

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