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 |
what is the difference between Ranking and sort-out in bo?
Can we have multiple domains?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
what is diff between Decode and case ? Give some Example?
What is the merge dimension?
Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
can any body tell me how to create Hyperlinks in BO XI R2?
Difference between b.o 5.1 and 6.1b?
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
What is meant by data federator and what is the use of it?