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

Explain swot analysis?

0 Answers  


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  


What is Discrete and Continuous data in Data mining world?

0 Answers  


What are the different models used in cluster analysis?

0 Answers  


what are the major three types of modeling used?

0 Answers   InfoAxon Technologies,






What is Snow Flake Schema design in database?

3 Answers  


What is surrogate key? Where we use it?

0 Answers  


What is an OLAP (On-line Analytical processing) system?

1 Answers  


What are vaious etl tools in the market?

0 Answers  


What are partition points?

0 Answers  


Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

0 Answers  


why oracle is the best database for data warehousing?

4 Answers   HCL,


Categories