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

What are the design methods of data warehousing?

0 Answers  


How to performance tune reports?

0 Answers  


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

0 Answers  


Which is the optimized method of extracting the data.

3 Answers  


How can we schedule the graph in unix?

0 Answers  






How can Oracle Materialized Views be used to speed up data warehouse queries?

3 Answers  


What are different deliverables according to phases?

0 Answers  


Difference between e-r modeling and dimentional modeling?

0 Answers  


Explain Process flow in data warehouse??

1 Answers   BirlaSoft,


in general which algorithms for used?

0 Answers  


Can we start and stop single session in concurent bstch?

0 Answers  


What is core dimension?

0 Answers  


Categories