Home » Developer & Programmer » Reports & Discoverer » Question from a student (OLAP)
icon5.gif  Question from a student [message #358351] Mon, 10 November 2008 18:10
Messages: 1
Registered: November 2008
Junior Member
First of all I would like to apologise for my thread, probably under your level of knowledge.

I'm a IT student, and I just had the pleasure to meet the Oracle OLAP discoverer tool.
So here I go and on the first step I take I pretty much fell down..

This is what I tried to do, really simple:

I got a Cube "Returned Items" and some dimensions such as time, geographic location and some others.
In my cube there are a few important measures: bought items and returned items

Case 1:

In 2006: 17782 products were sold, 5910 products were returned.

Question 1:

What is the percentage of the items that were returned?

This should be 33% since (5910 / 17782=0.33235856484)*100

But then why does my Oracle OLAP discoverer tool give me the result of 28% when I use the calculation:

Any help or suggestions are highly appreciated.

Yes, I have to finish my assignment by Wednesday 12th

Previous Topic: Oracle 6i order by parameter from forms to reports
Next Topic: Letters Reports in 10g
Goto Forum:

Current Time: Thu Aug 17 14:23:24 CDT 2017

Total time taken to generate the page: 0.06421 seconds