We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essabase Transparent Partition with @PRIOR or @PREVSIBLING formulas

Received Response
9
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Essabase Transparent Partition with @PRIOR or @PREVSIBLING formulas

Content

Hi,

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:

@SUMRANGE(@MEMBER(@PREVSIBLING(@CURRMBR("Year"))),"Apr":"Dec")+@SUMRANGE(@CURRMBR("Year"),"Jan":"Mar");

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!