Forum Discussion
OLAP Get Pivot Data function vs. Non-OLAP Pivot tabel
Due to change in our Business Intelligence system I have to pull data into Excel files using OLAP. When I use the GetPivotData function the formulas are much more complicated. Here is an example of...
You have been very patient so far but I have to profess my ignorance in your last statement when you say that the cell reference may not be "recognized for the cube". I started the formula by typing an = sign in a cell outside the pivot table that was created from an OLAP connection and then letting Excel build the formula. Then I was trying to edit that formula with the syntax you showed. Not sure what I am doing wrong. I just tried refreshing the cube again by running the OLAP query but no change - still #REF.
It's hard to say what exactly is wrong without the file. For example, in the cell it could be "Lights " instead of "Lights".
Try to play with attached file, that's the sample from my previous post.