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

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post