Essbase ASO dynamic calc weird issue
hi All,
I have a ASO formula in outline which is like below hierarchy.
Time (Multiple Hier enabled)
|_Total Year(+)
|_ Jan(+) (Stored)
|_ Feb(+) (Stored)
|_ ....
|_ Dec(+) (Stored)
|_ FY(+)
|_ Jan(+) (Shared)
|_ Feb(+) (Shared)
|_ .....
|_ Dec(+) (Shared)
|_ FYCalc (Dynamic) (Formula: SUM(JAN:DEC))
my question is the formula FYCalc will use shared member or stored member in this hierarchy order.
We are having one weird issue that sometimes FYCalc is missing a month and sums other. ex: it only sums Feb to Dec and ignores Jan
did any one face such issue, it is only happening on one server. Same outline and data in another server is no issues.