Hyperion Kernel, From Alpha To Omega

Using share member is a quite powerful capability in ESSBASE. It allows you to create unlimited alternative roll ups, and it takes zero storage. Whenever the base member changes (data, name, etc), the share member which it points to, changes too. You have freedom to use different alias for share members, but you can not change the member name.  One other reason developers like to use share members is that it is SAFE to delete. When the share members are deleted, it has no impact to the base members where the data are stored. More often than not, dynamic calc will be used for alternative rollups, with the intention that the overall aggregation time will not be increased by the addition of multiple alternative rollups. However, if we are not careful on writing the calc scripts, we could easily miss out the opportunity of improvement on calc time. Following is an example - In Department hierarchy, there are multiple alternative hierarchies, all are with dynamic calc In Calc s