Using palo.eparent in a specific hierarchy or subset

    Using palo.eparent in a specific hierarchy or subset

    Dear all,

    I want to retrieve a specific parent in my dimension time (built with the time parameters script in the modeller).

    The problem i have is that every element has 17 parents (month, week, month to date, year, fiscal year...), and all base elements were not created at the same time, so the parent hierarchy is not the same for all elements.

    In my example, I want to retriveve the week number for a spectific day.
    If I use Palo.eparent(server,dimension,element, 1) or any other hierarchy number I do not get always the weeek number (sometimes the month, the YTD, the MTD etc...).

    I was thinking to use palo.eparent in a specific subset of elements (the hierarchy with the year-month-week) to get always the desired parent, but I don't get any idea how to do this...

    Any clue to do so ?

    Thanks for your help,
    Nicolas