Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

what is difference between calc All and ACG?

Posted on 2009-07-08
3
Medium Priority
?
502 Views
Last Modified: 2012-05-11
what is difference between calc All and ACG?
0
Comment
Question by:AJITPADHY
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
garycris earned 1500 total points
ID: 24803707
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
 

Author Closing Comment

by:AJITPADHY
ID: 31600994
thanks
0
 

Author Comment

by:AJITPADHY
ID: 24825565
thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question