Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal Wish List
 ROLAP - adding calculated measures

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
fdranguet 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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page