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 |
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Can anybody tell me about issues faced while creating universe. thanks in advance
what are slowly changing dimensions, confirm dimensions?
draw the architecture of bo
what do u mean by variable functions ?
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
How do scheduling the report in BO XIR2? can you say what are they steps?
Explain what are the steps to do to use alerts in bo?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
how many times can use the union operator in a report?
what is the diff between etl tool and olap tool