How do you design KPI goal that is dimension dependant
Q: How do you design KPI goal/forecast that is dimension dependant?
A: You should create separate goal/forecast measure group. It is quite common that this measure group would have different granularity from actual event measure group. For example you might have sales measure group at day level, but goal/forecast measure group at month level.
After you created this measure group, you query it to get a goal/forecast value for your KPI.