how to link 3 fact tables
Answer / joel rodrigues
Fact tables are tables with lots of measure values and are
uniquly identified by a key, also a fact table can have a
foreign key. For Example custumer fact table is connected
to loan fact table via customer_id, and each record in loan
fact table is uniquely identified by a primary key on
cod_acct_no. Similarly customer table can be connected to
Savings fact table through customer id.
| Is This Answer Correct ? | 2 Yes | 1 No |
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
When we use aggregate awareness function in designer?
What is Cartesian product?
Explain what are the steps to be taken to schedule the report?
what is fantrap ?
How many ways you can restrict data in business objects?
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
what is main functional differences between BO and COGNOs?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
Is it possible to generate reports without having knowledge of the Universe structure?
what is meant by slowly changing dimensions?