|
fdranguet
France
82 Posts |
 Posted - 02/25/2009 : 05:16:43
|
Hello,
what about adding calculated measures for ROLAP reports? You can add a calculated field at line level, by entering some SQL code at the cube definition screen (Admin=>ROLAP), but this is sometimes not sufficient: let's say I have two measures, one which is "sell price", another one "product cost", and I want to display the percentage of contribution, which would be calculated by ("sell price"-"product cost")/"sell price". I can add that at line level by SQL on the cube definition, but then, when grouping on certain criteria, doing either an average or a sum will not display accurate value for that measure.
Regards,
François Dranguet
Scott Bader SA |
|
Report Portal
ROLAP - adding calculated measures
