Dimension Reference Table In Memory Data Model Setup
Targit version 2022.6 build 21002
I have a Dimension Customer table and a Fact Sales table joined on CustomerID One to Many.
I want to introduce a Dimension Customer Reference Table which has Many Customer IDs.
What is the best way to set this up in Targit In-Memory Data Model?
Use case: User will select one or multiple campaigns i.e. 'Spring1' and '15% Off' and the Fact Sales will only return sales for these CustomerIDs.
Is Setup A possible In-Memory
a Many to Many
Or do I retain the Star Schema and feed the values into the existing Customer view but this could be difficult to manage over time as more campaigns are added.
0
Comments
Please sign in to leave a comment.