So the KPI has a value and a goal field. Let's say the value is sales growth and the goal would be looking at things like: if we reached a sales growth of 20% then that is good, 10% is fair, negative is bad. No problems.
Now my issue is that I will create this cube but I will install it on a number of different company servers. Each company is going to have different goals. One might say 20% is good, 10 % is fair. Another might say 12% is good and 3% is fair.
Is is possible to code the KPI so that it gets the percentage threshhold number from say a data table rather than having them hard coded? I really don't want to customize the KPI every time I install it as I will have to keep track of the customizations and then reinstall them if there is an update.
Now my issue is that I will create this cube but I will install it on a number of different company servers. Each company is going to have different goals. One might say 20% is good, 10 % is fair. Another might say 12% is good and 3% is fair.
Is is possible to code the KPI so that it gets the percentage threshhold number from say a data table rather than having them hard coded? I really don't want to customize the KPI every time I install it as I will have to keep track of the customizations and then reinstall them if there is an update.