1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

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

What is drill across ? can anybody explain me in detail?

1 Answers  

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

How to create universe in business objects enterprise 11.5

1 Answers  




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

0 Answers  

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

1 Answers   CSC,

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,

For more Business Objects Interview Questions Click Here
Categories