Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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,399 Views
0 Likes
0 Replies