Have you 'joined' these fields? i.e. the orange chain link is showing against the dimension in the dimension list?
When we connect two different data source then add relationship in data window.
Data-Edit relationship - Custom and add related fields.
Hey, thank you for your help. The data comes from two different excelfiles, so I don't see both in the Data View.
You need to perform blending, as data is coming from two different excel files. Is there common data between the files or field ?
It would be better if you attach a workbook.
Hey, I solved my problem with our advices. It was a bit more complex, than I expected but it work like in the tutorial. I created a seperate sheet with all my products (several hundred) and added the needed parameters as calculated fields.
This Solution is now getting to very huge table. Several hundreds of articles multiplied with 100 Countries and hundreds of Customers. Hmm...I'm getting a Table with thausands and thausands of Rows