Answer Posted / 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 |
Post New Answer View All Answers
What are non-additive facts in detail?
What are the data types present in bo?
What is informatica architecture?
Explain what are non-additive facts?
How do you setup Lo-cockpit?
I have two universes created by two difference database can we join them in designer & report level? How
What is scd1 , scd2 , scd3?
What is perform recovery?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What are the various tools? Explain name a few?
What is dimension modeling?
What is defined as partial backup?
What is crass reference table?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
How to add a number to a macro variable?
