How to get the oracle OLAP variables value from rational OLTP database
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
0