i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?

Answer Posted / sivakumar

Two Fact tables can be Joied through an confirmed dimension.
So any of the dimension should have the feature of
confirmed dimension.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the dense rank?

679


Explain difference between zabo and webi?

656


Can we create universe with no cache??

1956


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

591


Did you face any problems while creating reports? Name? Solutions?

3260






what are the tables used in health care domain project and columns used in report?

4039


What is Indexing? how did u implement indexing?

1820


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


What is the difference between the public object&schema object?

578


is it possible to export the webi reports to crystal reports?with out using businessview?

1820


what is xcelsius architecture?

3745


What is top business?

567


What is object stores?

583


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!!!

1759


how get the grand total in master-detail report?

1819