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 / pradeep

Create a Short cut join between the two fact tables in the
universe.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1744


Explain what are the steps to do to use alerts in bo?

605


What task is 98% of the required work of a business analyst?

575


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

1487


explain in detail about type 3?

620






Can we Save (save as) WEBI Doc as DESKI?

7059


Explain is data mart?

584


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

619


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1395


Explain about a tricky situation for which you found a very simple solution?

532


Can anybody tell me what are the tuning problems?

1585


What Is The Difference Between Oltp And Olap?

669


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1614


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1534


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

1812