Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2011-11-02 : 08:28:53
|
| Hi ! I have the following calculation in my cube :scope([Measures.KPI],[DIM KPI], [KPI_Hr].[KPI].&[21]);this=([Measures].[Kpi21],linkmember([Exec_Month].[Daily_Hr],[Plan_Month].[Daily_Hr]),root([Exec_Month].[Daily_Hr]));I want to receive sum of [Measures.KPI] for Plan month while in the filter it'll be Exec_month. When I check the result, it's larger then it must be.Somebody knows where is my mistake?Thank you |
|
|
|
|
|
wrong result for linkmember