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! |
All times are GMT +1. The time now is 02:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com