Hyperion Planning (MOSC)

MOSC Banner

Form Validation for Overlapping Dates

edited Feb 15, 2016 10:33AM in Hyperion Planning (MOSC) 3 commentsAnswered ✓

I'm using Planning 11.1.2.3 and have a requirement to implement a validation that checks if level 0 entities have overlapping dates (2 date members that define a range are defined in another dimension). The edit should only check dates among the groups of level 0 siblings; i.e., if there are 100 parents with between 1-10 level 0 siblings each, then first check for overlaps among the first group of siblings, then the next, and so on.

The solution should be dynamic so that no changes will be required if/when the number of parents or siblings change. Any ideas on how to implement this as a form validation in Planning? I know how to build the basic validation logic for determining if 2 date ranges overlap. The difficulty is due to not knowing in advance how many siblings will be in each group and the requirement to limit the comparison to only siblings. The form also displays rows for multiple years, and the comparisons also need to be limited to rows within the same year.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center