Hey there! Today’s post is a quick overview of the new CurrentProperty object that Oracle released in the 23.12 EDM patch! This function allows for the expression builder on a derived property to reach into the property parameters of itself! Currently, in an expression you can use the CurrentProperty function to retrieve the property Name and Description to use in your derivation.

This feature could be helpful if you need to derive a string field that comes from the configuration (maybe you need to include a description of the property or the property name in the load to a data warehouse/data lake, for example).

You can read more about this function it in the Oracle EDM admin guide.

To test this out myself, I created a String property called “”To test this out myself, I created a String property called “Test.CurrentProperty” – where I added a Description of the property to be “Test Description for Hyperion Barbie!!!”:

I then added it to my HyperionBarbie Planning > HB_Product node type and started a derivation with expression builder:

In expression builder, I returned the Node Name – and was able to test out the new “Play Derivation” feature that makes it super easy to test!!! You can see for the expression, the result is in the bottom right hand corner (I just selected a random node to use as the test):

The name of the property is displayed as a result of the expression (“Test.CurrentProperty”).

I then changed the expression to pull the Description field, and you can again see the results: