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 |
|
casagrandi
Starting Member
3 Posts |
 Posted - 2006-05-24 : 12:17:40
|
hi,excuse my bad english.i'have problem with percent measures in reporting service. the measures GoodPct is calculated members and equal to:nb good product / nb all product produced. I want to display this measures as follow-(-)------------------------------semestre1-------------------------|-------------------------------semestre2-------------------------|(-)month1| month 2 |month 3 |month4| month 5 |month 6|month7| month 8|month 9 |month10| month 11 |month12GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPct|GoodPctwith drilldown options. The problem is when i display thoses datas in analysis services the agrégations work as i hope . But in reporting services when i agregate i have the pct who is greater than >1 for semestre example:the correctmonth1-->nb good product in month 1/nb all product producedin month 1month2-->nb good product in month 2/nb all product producedin month 2semestre1->nb good product in semestre 1/nb all product producedin in semestre 1what i obtain:semestre1--> sum(nb good product in month j/nb all product producedin month J)can you help me pleasevisit this schema : [ |
|
|
|
|
|
problem with non additiv measure