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.




Please sign in to leave a comment.

Didn't find what you were looking for?

New post