Why do we use DSS database for OLAP tools?
Answers were Sorted based on User's Feedback
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 |
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 |
Suppose we want to display zero when null values coming to report how can we do that?
What is many-to-many dimensional model in datawarehousing ?
What are the different types of segments?
how much memory space occupied real time project (roughly)?
What is the difference between datawarehouse and bi?
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.
What is surrogate key?
Ist the schema that a data warehouse system can implements.
What is the function of surrogate key in data warehousing?
What is informatica architecture?
what is difference between scd2 and scd3
What is a Data Cube?