• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Customer segment based on product type - how to connect lookup to fact table

CustomerCustomer segment
KjopernavnKundesegment
A&O SEAFOOD EXPORT ASExport for further processing
ABS ASExport for further processing
ANDREAS BJØRGE SEAFOOD ASClipfish

I am using the above lookup table to find the customer segment for each customer in the table "Fangstdata"
But each customer can have different customer segments based on the type of product the buy, in this case fish type
In the table below I have illustrated how this can look like, and fish type can have difference segment between different customers
I having problem to connect this to the table "fangstdata" so that I can get a report on total amount (belop) for each customer segment
I hope I was able to explain my problem well
Thanks for any help

CustomerFish type There are around 30 fish typesCustomer segment
KjopernavnFiskeslagKundesegment
A&O SEAFOOD EXPORT ASCodClipfish
A&O SEAFOOD EXPORT ASShrimpShrimp
A&O SEAFOOD EXPORT ASHaddocFilet
A&O SEAFOOD EXPORT ASOther fish typesExport for further processing
ABS ASCodFilet
ABS ASOther fish typesExport for further processing
ANDREAS BJØRGE SEAFOOD ASAllClipfish


Here is the connection between the "kjopernavnDim" table and the "Fangsdata" table
82661

Kindly Regards
Lars Ole
 
Back
Top