Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GetPivotData and SQL Server OLAP cubes
I am new to SQL Server OLAP cubes.
The following is the formula in question. =GETPIVOTDATA("[Measures].[Units]",$A$16,"[Markets]","[Markets].[All Markets].[South].[Virginia].[Salem]","[Platform Types]","[Platform Types].[All Platform Types].[center]") Using normal Excel pivots, I can subsitute excel addresses in the Getpivotdata function to automate my work. For example, GETPIVOTDATA("Sum of "&TRIM(ColList!$H$5),INDIRECT(RegionPivotStartRef) ,"REGION",$A7,"ACTIVATION_MONTH",DATE(YEAR(G$5),MO NTH(G$5),1) Is this possible with SQL Server cubes? I have tried various ways to reference Excel cells, but keep getting #REF errors. Any assistance would be appreciated! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA from OLAP cube | Excel Discussion (Misc queries) | |||
OLAP Cubes | Excel Discussion (Misc queries) | |||
pivottable and OLAP cubes | Excel Worksheet Functions | |||
What do i enter in the server textbox to access olap? | Excel Discussion (Misc queries) | |||
Excel pivottable with OLAP cubes saves names, not keys | Excel Discussion (Misc queries) |