i want to add the goal values to my data warehouse. and make then available in the ssas to read.
so what's the best way for that ?
i saw in adventure works that there is a factsalesQuota to save targets of each employee.
but for me that won't cover all i need.
i have targets for doctors and departments and services and insurance companies and so on.
so what's the best way ?
is it put a fact like the fact contains my data but that need more and more targets to be added ?
please help in the the idea to think about "How To Design the goals which are dependent on the dimensions?
View Complete Post