From: rejib@yahoo.com (Reji) Newsgroups: comp.databases.oracle Subject: Re: Oracle Analytical functions - Qn Date: 11 Nov 2002 10:17:09 -0800 Organization: http://groups.google.com/ Lines: 48 Message-ID: References: <130ba93a.0211100948.46add397@posting.google.com> NNTP-Posting-Host: 63.119.238.172 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037038629 11045 127.0.0.1 (11 Nov 2002 18:17:09 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Nov 2002 18:17:09 GMT I am getting the following error when I issued the query "Feature not enabled OLAP Windows Functions"....what needs to be done here? I have oracle8.1.7 Enterprise edition. Reji JusungYang@yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0211100948.46add397@posting.google.com>... > The posting looks incomplete. ID2 does not seem to play a role in your query. > If so, a sum and a ratio_to_report should do it. Something like > > select ID, ratio_to_report(c1) over() from ( > select ID, sum(bytes) c1 from group by ID) > > > - Jusung Yang > > > select > rejib@yahoo.com (Reji) wrote in message news:... > > I have the following data set: > > > > ID ID2 BYTES > > 1000 1000 1000 > > 1000 1200 2000 > > 1000 1300 2000 > > 1200 1400 5000 > > 1200 1000 5000 > > 1250 1400 5000 > > > > Assume that ID and ID2 are two locations and BYTES - number of bytes > > transfered from ID to ID2 > > > > I would like to produce couple of results > > > > 1) Shared percentage of data transfered from each ID > > > > Ex with this data set > > > > ID Shared percentage > > 1000 25% (5000/20000)*100 > > 1200 50% > > 1250 25% > > > > I would like to use oracle analytical function if I can...please help > > me here > > > > RB