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
What task is 98% of the required work of a business analyst?
What are the data types present in bo? What happens if we implement view in the designer and report?
any difficulitis have you phase while creating bo reports and how did u solve it
How were the reports scheduled and how to resolve unexecuted documents?
Explain about a time when you discovered a more efficient way to do a work task?
What is the difference between the public object&schema object?
how many reports have u created ? explain a few.
8. How much supervision have you typically received in your previous job?
How would you format some text using css to be verdana and bold?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain how many universes can be created in a project?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.