Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Unanswered: can't display calculated members

    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?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Posts
    5

    Wink

    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?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any error or information during this process?

    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.
    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Posts
    5

    Cool

    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.

Posting Permissions

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