Why do we use DSS database for OLAP tools?

Answers were Sorted based on User's Feedback



Why do we use DSS database for OLAP tools?..

Answer / harish

olap tools or reporting tools can be connected to only ONE
database.If we need a report of data from more than one
database like oracle,SQL Server and DB@ then all the data
is put into a datawarehouse database and then the olap tool
can be connected to this datawarehouse database and the
necesarry reports can be generated.

As far as i know this could be a good answer.

Hope this answer helps.
Experts please correct me if i am wrong.
Regards
Harish.

Is This Answer Correct ?    12 Yes 0 No

Why do we use DSS database for OLAP tools?..

Answer / jimmy

It's dission supporting system.Maybe you can say OLAP is
just useing a software.But it can provider more
imformation.just like profobi.

ProfoBI is a leading provider of business intelligence tool
which gives you the information when you need it. ProfoBI
is committed to offer an integrated, robust and flexible
presentation layer for the full breadth of ProfoBI
Analytics capabilities for better and faster decision
making.

www.profobi.com

Is This Answer Correct ?    2 Yes 0 No

Why do we use DSS database for OLAP tools?..

Answer / shekar

dission supporting system
bo, cognos, etc

Is This Answer Correct ?    4 Yes 3 No

Post New Answer

More Data Warehouse General Interview Questions

Suppose we want to display zero when null values coming to report how can we do that?

0 Answers  


What is many-to-many dimensional model in datawarehousing ?

0 Answers  


What are the different types of segments?

0 Answers  


how much memory space occupied real time project (roughly)?

0 Answers  


What is the difference between datawarehouse and bi?

0 Answers  






Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

1 Answers   iFlex, Wipro,


What is surrogate key?

5 Answers   IBM, Informatica,


Ist the schema that a data warehouse system can implements.

0 Answers  


What is the function of surrogate key in data warehousing?

0 Answers  


What is informatica architecture?

0 Answers  


what is difference between scd2 and scd3

3 Answers  


What is a Data Cube?

1 Answers  


Categories