what is difference between calc All and ACG?

what is difference between calc All and ACG?
AJITPADHYAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
garycrisConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.