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

There should be a dimension that will connect those two
fact tables which we call it as "Confirmed Dimension"

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to be taken to schedule the report?

551


Is there any other repository domains rather than universe, security, document?

591


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1879


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

686


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

584






What is aggregate table and aggregate fact table ... Any examples of both?

606


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599


Explain how to schedule the report in b.o?

561


Can Bo generates the Report from the cubical data Explain?

1626


When we use aggregate awareness function in designer?

546


Explain how many universes can be created in a project?

609


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1904


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

1615


Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1812