Essabase Transparent Partition with @PRIOR or @PREVSIBLING formulas
SummaryEssabase Transparent Partition with @PRIOR or @PREVSIBLING formulas
Having an issue with Essbase transparent partitions, which may be stretching the partition beyond its capabilities.
We have a partition, where the target database contains FY17 & FY16 data, and there is a transparent partition to another BSO DB which contains FY15 and before.
Within the Period dimension, there is a dyn calc member which sources a sum of months across current and previous year:
This formula works fine when you pull data from FY17 (as FY17 & FY16 data is in the same DB) and FY15 (as FY15 & FY14 data is in the source DB). However if you pull FY16 data, the number will differ depending on your grid: