Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: I need help with Analysis Services

    Hi.
    I have a problem with the caculation of the dimensions in the Analysis
    Services and I need help.
    In a certain dimension I make some calculations with the "personalized member formulas". Some cells are modified after this calculations. After this, in another dimension, other calculations are made using again the "personalized member formulas". With this operations some cells that were modified in the previous dimension should be modified again, but they aren't. Is there a way to fix the sequence of the calculation of the dimensions? Do they get calculated at the same time or some get done before others? Once one of this cells are modified using those formulas is it possible to modify them again? In the Hyperion's Essbase software ther is an option to calculate some dimensions before others. Does Analysis Services has that option or something similar?.
    I hope you can help me. Thank you very much.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Are you using third party OLAP and if not what is the level of service pack on Analysis server?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jan 2004
    Posts
    6
    We are you using service pack 3 on Analysis server and the Microsoft tools for Analysis Services. (SQL Server 2000 SP3 + Windows 2000 Server + SQL Server Enterprise Manager; and Analysis Services SP3 + Analysis Manager)

Posting Permissions

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