My Oracle Support Banner

Using MinList and MaxList with Date Or DateTime Values In DRM (Doc ID 1967005.1)

Last updated on MARCH 08, 2017

Applies to:

Hyperion Data Relationship Management - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

Goal

Example: How can we calculate the minimum end date across all the children of a particular node?

You have a custom property End Date with data type as Date. You have tried using MinList in conjunction with ListNodePropValues thus:

MinList(ReplaceStr(ListNodePropValues(ListChildren(SortOrder),[comma],Custom.EndDate),[comma],#,true),#,date)

This gives a blank value as output.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.