Database Software

Greetings,

Firstly i am a beginner, just started working in this sector.

I have a question regarding OLAP.

We have;

"Business Intelligence SE One 10g" and "Oracle SE 10g" as database server for BI.

I wanted to install "Oracle Spreadsheet Add-in" by mistake thought it is available on Oracle BI SE One. When i try to install it, i got an error and while searching for a solution, found out that OLAP option must be TRUE in the database where BI installed.

Then i checked it through this code;

select value
from v$option
where parameter = 'OLAP'

and found out that the option is FALSE.

When i tried to ask people about it, they say you dont have OLAP option installed in your database. Now, as far as i know "OLAP" is the process of approaching multi dimensional analytic queries. I didnt quite get it. If OLAP is not installed, what is the process that is used to approach queries in our BI Database.

Or is Oracle OLAP and OLAP are different things?


One last question : Is it available to install Oracle OLAP option in SE 10g?


Have a nice day!