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 |
What are the steps involved in creating dimensional modeling process?
What is cubes?
What is the difference between er modeling and dimensional modeling?
What are the different models used in cluster analysis?
Explain what are components of reportnet?
What is the differences between star and snowflake schemas?
Where do we use semi and non additive facts?
What are the main steps to build the data warehouse?
How are the dimension tables designed?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
What is data cleaning? How can we do that?