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!

olap vs sql

415100Feb 28 2004 — edited Mar 7 2004

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.
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2004

Added on Feb 28 2004

#data-warehousing, #olap

4 comments

405 views