Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Calculating NPV

612723Dec 9 2007 — edited Dec 11 2007

Dear all,

I get some large amount of data through a batch process from mainframe. I need to calculate NPV (Net Present Value), once per day. When I was searching through sites and posted in some other forums, I could get two replies

1) Use OLAP DML to calculate npv.

How should I do this? I understand that I cannot use an OLAP function just like a select clause. And another point, how will I trigger this every day certain time (like a unix cron)? Please give some links.

2) The spreadsheet technique:-
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm#sthref1943

Which one I should adopt considering efficiency ? Is there any other way such as Pro*C could be used for the same purpose?

Please help with the best architectural decision to go about it, thanks

Warmest regards,
Ravion

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2008

Added on Dec 9 2007

#data-warehousing, #olap

2 comments

2,555 views