Differences between Essbase calculation scripts and Business Rules

Calculation scripts

Script is either specific to database or application in Essbase.

Use substitution variables.

Scripts can be executed from Excel Add In / Smart View.

Business Rules

Easier way of implementing business logic either using script or graphical method.

Use Substitution variables.

Use run time prompts to narrow down calculation scope.

Cannot access from Excel Add In / Smart View.

Rule can be defined as global so every application can make use of it.

Happy Learning :)