Order of calculation

By now, you have a good understanding of what an Essbase calculation is. You have learned about a head-spinning number of database calculation functions and commands. We now need to describe for you another one of those conceptual ideas that Essbase is famous for.

As we've said many times before, Essbase is an art, not a science! The idea of how to determine the order of calculation is made up of equal parts of scientific blah, blah, blah about, "Well this is how Essbase is written so this is how it works", and generous portions of, "I kept tweaking the script or the outline until I got the results I needed."

Isn't that great? How do I figure out something like that? Well, here is how it's supposed to work:

1. 1. During a CALC ALL database calculation, Essbase will calculate your dimension tagged as Accounts first.

2. 2. Next will be the dimension you have tagged as Time.

3. 3. Then, Essbase will calculate the remaining Dense dimensions in the order they appear in the EAS outline...