Skip to Content
0

Time independent attributes

Mar 26 at 01:18 PM

33

avatar image
P K

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Nora Roch
Mar 28 at 09:45 AM
0

Hi PK,

you can use time-dependent hierarchies.

Cheers,

Share
10 |10000 characters needed characters left characters exceeded