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

FIX on two distinct sets

Received Response
edited Aug 2, 2018 2:36AM in Essbase 7 comments


FIX on two distinct sets


Hello.  Novice Essbase developer here, using BSO Planning.

I have a cube with a Year dimension and a Period dimension.  I need to fix on FY17, Oct-Dec and on FY18:FY22, Jan-Dec.  Those dates will be substitution variables, of course, but for this example let's use the literal values.  Normally I would use two sets of fixes with the same logic within both sets to first operate on 2017 and then on 2018-2022.  In this case that approach won't work.  I need to construct a single set of fixes that will pull both 2017 Oct-Dec and also 2018-2022 Jan-Dec.

Howdy, Stranger!

Log In

To view full details, sign in.


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