Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

what is difference between calc All and ACG?

what is difference between calc All and ACG?
0
AJITPADHY
Asked:
AJITPADHY
  • 2
1 Solution
 
garycrisCommented:
Both are calc script commands used to calculate dimensions in the outline.

A 'CALC ALL' calculates and aggregates the entire database based on the database outline.

An 'AGG' Consolidates database values. This command ignores all member formulas, consolidating only parent/child relationships.

The AGG command performs a limited set of high-speed consolidations. Although AGG is faster than the CALC commands when calculating sparse dimensions, it cannot calculate formulas; it can only perform aggregations based on the database structure. AGG aggregates a list of sparse dimensions based on the hierarchy defined in the database outline. If a member has a formula, it is ignored, and the result does not match the relationship defined by the database outline.

    *

      AGG only works with sparse dimensions.
    *

      When a dimension contains fewer than six consolidation levels, AGG is typically faster than CALC. Conversely, the CALC command is usually faster on dimensions with six or more levels.
    *

      AGG follows the rules for any defined FIX command.
0
 
AJITPADHYAuthor Commented:
thanks
0
 
AJITPADHYAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now