I have still having problems building a cross tab report which is taking information from two different fact tables. One fact table is Revenue which has its own Date and the other is Costs which also has its own date. I built a query which independently gives me the correct information for Revenue and Costs. But I need these to be combined. The problem is how to account for the two different date fields from each fact table.
rhodesdw (BOB member since 2009-06-26)
Are both dates in the same format? Are you having trouble merging the dimensions? You should only need to merge the two dates. I’m no expert but I never had a problem combining queries from separate tables using merged dimensions in XI R2.
mcnelson 
(BOB member since 2008-10-09)
The dates are in the same format.
rhodesdw (BOB member since 2009-06-26)
Can you not merge the dimensions then?
mcnelson (BOB member since 2008-10-09)
and how do you merge the two date fields. In the universe or in reports.
rhodesdw (BOB member since 2009-06-26)
That depends whether your dimensions are conformed over both facts, or not…:).
If they are and you have set your contexts and incompatabilities correctly BO will join the SQL for you.
You can see this by looking at the SQL produced in your chosen query editor, it should show two SQL scripts with join in the left hand pane - query panel.
If not, you have some work to do at the report level.
Mak 1 (BOB member since 2005-01-06)
Still having trouble. I have attached three screen shots of my report queries and the report. Can’t figure out how to combine the two different sum measures when each one is coming from a different fact table.
rhodesdw (BOB member since 2009-06-26)
You need to merge your month fields.
There is a button that will allow you to merge dimensions on the tool bar.
There is plenty of info on the forum, not forgetting the Webi product guide, have you, actually, tried to find the answer yourself?
Mak 1 
(BOB member since 2005-01-06)
Yes I have tried to find the answer myself over the last few days.
rhodesdw (BOB member since 2009-06-26)
That works. Thanks a bunch.
rhodesdw (BOB member since 2009-06-26)
No problem.
I may have sounded harsh, but I like people to help themselves too…
In addition you will have noticed two of your dimensions merged themselves.
This is because the object names are the same, so BO knows to merge them.
I recommend that you read more on dimension merging, its a fundamental of Business Objects…:).
Mak 1 (BOB member since 2005-01-06)