Oracle BI Beans and statistics other than SUM

From: David Granger - Sun UK - Information Analyst <David.Granger_at_Sun.COM>
Date: Thu, 24 Apr 2003 16:17:39 +0100
Message-ID: <b88v6k$ebd$1_at_new-usenet.uk.sun.com>



Hi All,

This message was previously posted on Oracle's MetaLink OLAP forum but didn't
get any sensible response. Surely this must be possible as the underlying MV's can cope fine.

Dave.

Previous message:

I'm finally getting going with BI Beans after a nightmare of an install process but that's another story.

Anyway, my question is, how do I report anything other than the sum of a measure. I realise that in the finance world this is all that most people are interested in along with variance reports, percentages, moving averages and the like, but how do I, for example show the average, or standard deviation in a crosstab/graph rather than the sum ?

For example, consider the case of Oracle TAR's, where u and sd in the following example refer to the mean and standard deviation of the time to close a TAR within given countries / time periods.

Time

01Q1 01Q2 01Q3 ....
u sd u sd u sd
UK x x x x x x
US x x x x x x
France x x x x x x



Total x x x x x x

I've looked into the query builder but I don't see how I can do this. At least not against the bibdemo schema.

-- 


+----------------------------------------------------+
| /\ | | \ \ Dave Granger | | \ \ / Information Analyst. | | / \// / Sun Microsystems Ltd | | / / \//\ Phone : +44 (0) 1252 420591 | | / //\ / Internet : http://www.sun.com | | / \ \ Email : david.granger_at_sun.com | | \ \ | | \/ |
+----------------------------------------------------+
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Thu Apr 24 2003 - 17:17:39 CEST

Original text of this message