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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9419


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

684


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1579


Can you please send me the migration related issues .

1637


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

532






Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2596


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

597


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

3256


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

619


Explain about a task that really tested your analytical abilities?

744


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1607


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 I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1617


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9868