I have created a few calculated members under one dimension (meaning the parent dimension is not Measures, but other dimensions). It can be showed in the Analysis Manager, but cannot be displayed in MS Excel PivotTable (MS Office 2k, xp, even 2003). Is there any solution to display the calculated members (as with the dimension) in Excel PivotTable? vba code needed? service pack needed?
Originally posted by Satya
Don;t know whether the SP may fix or not, but you can try though.
BTW what is the level of SP on OLAP & SQL?
i have installed the service pack 3 for SQL Server 2000 & Analysis Services (OLAP); sp4 for Windows 2k; MS Office 2003... but seems no change with the presentation of the Excel PivotTable from OLAP cube... still can't display the calculated members under the dimensions. Or is there anyway to force the calculated members be displayed under the dimensions?
I feel user interface is not able to simulate the data contained
in the dimension using a local cube. This may be because the estimated size of the dimension is large or possibly because it uses a feature not
supported in local cubes.
I think i got the solution for this...
When i create a calculated member in Calculated Member Builder, besides changing the Parent dimension, need also to specify the Parent member. Then only the calculated member will be displayed under the specified dimension in MS Excel XP/2003 PivotTable (Excel 2k doesn't support this feature). At least we know that the newer version of Excel has solved this problem.
Really thanks a lot for all the guidance & advices.