Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dpietersz
Creator
Creator
‎2010-01-06 07:36 AM

Fact Table and Slowly Changing Dimension

I have build a Fact table for a CRM system. See the image below. error loading image

I have two problems:

  1. The field "Accountmanager" in the table "Company" needs to be a Slowly Changing Dimension (type 2)
  2. I need to keep the history of every sales record to determine the average sales cycle


I found an example (see this thread) which I think I can use for problem 1. But I don't know how to implement it in my existing datamodel.

Anyone who can help?

1,308 Views
0 Likes
0 Replies