Where should I store targets tolerances

Hi,

I have to design solution for a bank so that its peformance can be monitored, I have different KPIs and KPIs are same for different countries but there targets value and tolerances value could be different.

I have this

Country DIM, KPI DIM, Time Dim, fact table.

My fact tables have [ country_SK,KPI_SK,Time_SK,KPI ACTUAL VALUE ]

Where should I store target value and tolerance values which are different for each country?

Store them in one or more different fact tables with appropriate dimensionality. Incorporate them in queries when needed.

So there are 2 approaches

1) Put Target and tolerances in the same fact as I mentioned earlier as it has country_SK as well as KPI_Sk and Time too.

2) Create a separate table where I store Surrogate_KEY,CountryID (NK),KPI (NK), TargetValue,ToleranceValue and then put this Surrogate_KEY in to the earlier mentioned fact table.

Also provide view of this to repot developers like - Surrogate key,Target,Tolerances

Hi,

is your tolerance value changing every month, if not then you can add it in the country dimension.
thanks

Himanshu

can not take anything to country as country has many many KPIs, I have taken 2nd approach.