Skip to Content
Former Member
Apr 08, 2013 at 12:44 PM

Time Dependent Hierarchy Not Working as expected



I have loaded a Time Dependent hierarchy (Time Dependent Hierarchy Structure with Use Temporal Join checked). I have transaction data for Jan, Feb and March 2013. The Leaf nodes have different parents in each of these months. There is transaction data in all three months.

When I execute my report for range Jan-Mar (date range 01.01.2013 - 31.03.2013), I expect to see 3 assignments of the leaves, as per the time range. However, I see all of the transactions of the 3 months, grouped under the latest relationship.

I have tried changing the Key Date of the Hierarchy in Query Designer, but this doesn't help either. I have used a replacement path variable here, to get fed from the CALDAY input variable.

Any assistance to get expected result is appreciated.