Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> point-in-time balance calculation algorithm required

point-in-time balance calculation algorithm required

From: Cock <cocktalker_at_yahoo.com.sg>
Date: 16 Jun 2004 14:45:34 -0700
Message-ID: <2a88bf82.0406161345.7100e9a7@posting.google.com>


Hi there, does anyone has an optimal way of calculating the month-to-date and year-to-date balances for a datawarehouse, based on a huge number of ledger journal lines? My customer, an international bank, is on 9.2.0.5. I already tried the 9i OVER (PARTITION BY ...) stuff but am unable to place this kind of query in fast refresh MV's; it wont take complex SQL for fast refresh. Complete refresh is not an option due to performance constraints.
I also tried regular PL/SQL loops, but the performance sucks. I wonder if this can be done with PIPED FUNCTIONS but have trouble getting the logic right, as we do not use object types in the database.

Any help would be appreciated,
Paul Received on Wed Jun 16 2004 - 16:45:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US