hi olap guys
i have a question
i am working on olap application on oracle9i R2 DW, i built the data warehouse and did ETL process now i am confused why i need to build my olap application to use olap api although i can do all queries
using sql (including cube,rollup,rank .... )statements using fact,dimensions tables incuding ( materialized views and dimensions objects for query rewriter) instead of olap api and olap metadata , what olap api can do for olap that i can't do it using oracle sql.
and what i should do to use forcasting,what-if analysis with my olap application.