1 person found this helpful
The issue is your model (and data) ...
You have a LAST aggregation which is executed on the company code and year. But you have the same company code for various countries, which explain why the same values for a given company are used in every single country.
I would say you have issues in your logical keys.
Who knows ...
I said it looks like your logical keys aren't correct. But you are the one knowing how they should be instead as it's your data and your model.
But just from the picture I believe you have an issue as if "Company code" is the one of the first post it's clearly not unique for every country.
A single company can be in multiple countries ... you need a distinct key for company-country ... the hierarchy keys have to be related ... currently you have no relationship (logically) set for country and company -- data just repeats at the summary level where a 'match' exists.
Use of information drives physical/logical data model design. Knowing that companies are in multiple countries should have driven the design of not only the physical data but also the logical relationships.