SSAS FAQ 
Design FAQ How do you design KPI goal that is dimension dependant
Design FAQ How do you design KPI goal that is dimension dependant
| How do you design KPI goal that is dimension dependant |
| Written by Vidas Matelis | |||
| Thursday, 29 March 2007 07:01 | |||
|
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.
|
Tags: design, faq, kpi
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- MDX-How do you format or round KPI expression value?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- MDX-How can I setup default dimension member in cube calculation script?
- How to calculate YTD monthly average and compare it over several years for the same selected month
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000
