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
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What is difference between custom hierarchy and report based hierarchy?
how to prepare the documentation in business objects and where to get the requirement?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to create Index to the table in the universe designer and how it improves the Query performence
Give some information on report bursting?
Can more than 1 metric be applied on an analytic in business objects?
can anybody tell me about complicated object you have created
Explain what is the difference between business requirement document and use case document.
What is top business?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
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
Explain what sort of existing documents should business analysts refer to when starting on a new project?