how to link 3 fact tables
- 1 Answers
- 7215 Views
- I also Faced
- E-Mail Answers
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 can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is aggregate table and aggregate fact table ... Any examples of both?
what is the difference b/w star and snowflack schema in dataware house?
9.what are the multidimensional analyses
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what is data cubes??
what is drill down?
What is DSS?? (Defination of DSS)
is it possible to export the webi reports to crystal reports?with out using businessview?
How many universes are required for a single project,and how many reports are required for a single Universe.
The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports
Teradata 
