Skip to Content
P K

Time independent attributes

Hi,

below is a modelling example and I wanted a help on the solution for this

in June 2017, the manager group was A. In July it got changed to B. While running the report for June 2017, business needs to see manager group A, even though it was changed to B in July 2017.
The dimension table Manager is time independent.

How do we model in such case?

Thanks,

PK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 28 at 09:45 AM

    Hi PK,

    you can use time-dependent hierarchies.

    Cheers,

    Add comment
    10|10000 characters needed characters exceeded