Database DataWarehousing (MOSC)

MOSC Banner

How to get the oracle OLAP variables value from rational OLTP database

edited Feb 16, 2013 2:22PM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi,I use the OLAP IRR function to calculate a invest index and want to get it from PLSQL package. Would you like to tell me how to approach it?
Following are my steps done for it:
I use the following OLAP DML to create AW and calculate the IRR:
aw attach IRRTEST rw
DEFINE year_d DIMENSION NUMBER
DEFINE estmodel_header_d DIMENSION NUMBER
DEFINE cflow VARIABLE DECIMAL <year_d estmodel_header_d>
DEFINE estmodel_irr_f FORMULA IRR(cflow, year_d) DECIMAL
MAINTAIN year_d ADD 1 2 3 4 5 6 7 8
MAINTAIN estmodel_header_d ADD 24
limit estmodel_header_d to 24
limit year_d to 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center