Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

981


What are the data types present in bo? What happens if we implement view in the designer and report?

968


any difficulitis have you phase while creating bo reports and how did u solve it

3385


How were the reports scheduled and how to resolve unexecuted documents?

2612


Explain about a time when you discovered a more efficient way to do a work task?

1083


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

1001


how many reports have u created ? explain a few.

2030


8. How much supervision have you typically received in your previous job?

2201


How would you format some text using css to be verdana and bold?

1029


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?

2170


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2268


Explain how many universes can be created in a project?

1007


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

1820


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?

963


(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.

1461