Custom Entity Relationships in Time Range

Samir Jones

Are Custom Entities only working as a parent to the lowest level?

I'm struggling with the "Current Fiscal Year" (red mark).
In selection phases (i.e. a screen selection), the selection of the entity member "Current" on the "Current Fiscal Year" won't apply on the child "Fiscal Year" (member "22/23" in this case).

However, whenever I do a selection on "Current Month" (green mark), the relevant child in "Month" is selected.

I tried the same thing in a different Data Model, where "Day" was the lowest level.
Since "Month" wasn't the lowest level anymore, the "Current Month" stopped working.

We are on version 12.6.01

No children are selected

"Current Month" works fine.

James Packham

Hi Samir

With custom time entities there is no automated association between indirect levels of the hierarchy - in this case I would go into the Custom Relationships view, select Month and then select Current Fiscal Year to see the existing mappings between the 2 levels - it may be blank under column Current Fiscal Year. I would do similar checks up and down the entire time hierarchy. The possible resolution here is either to associate the months manually in the Custom Relationships screen (which could be time-consuming) or to create a data reader for Month and its Custom Time entity parents (including Fiscal Year) which will effectively 'normalise' those associations.

James