i have 2 fact and 2 dimension tables in my universe . my question is how get th

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?

Question Posted / siddu.cherla

4 Answers
12273 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

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

Answer / siddu

to create a derived table from two facts and you can use the derived table columns in report level

Is This Answer Correct ?

5 Yes

6 No

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

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

More Business Objects Interview Questions

Explain when we use aggregate awareness function in designer?

0 Answers

What is the difference between the Bo 3.0 and 3.1?

1 Answers

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers Polaris,

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers TCS,

How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 Answers

Explain what are the steps to be taken to schedule the report?

0 Answers

Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?

2 Answers

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Answers

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers TCS,

Any body help me...what are challenges did u face in Business object project?

1 Answers

Can we configure two instances of CMS pointing to two different CMS system databases?

0 Answers

Explain about Short cut join?

2 Answers Wipro,

For more Business Objects Interview Questions Click Here