Joining multiple star schema in BO

[Swati Gutgutia]

Hi,

I have two star schema with common dimension tables.
I want to create data foundation in BO in such a manner so that i can query upon Fact 1 and Dim 1...Dim n, fact 2 and Dim 1..Dim n and, Fact 1, Fact 2 and Dim 1...Dim N
I have created
1. one context for one star schema with Fact 1 and related dimension tables (Dim 1...Dim n)
2. one context for one star schema with Fact 2 and related dimension tables (Dim 1...Dim n)
3. One context using Fact 1 and Dim 1(conformed dimension) and Fact 2 and Dim 1 (conformed dimension)

Now, when i am using the reporting layer
1. Upon using both the fact table and the dimension table I see two queries being generated. Which are then getting Unioned and giving me the result. Will this give correct reslut?
I want to have a single query that picks fact from both the fact tables having dimension members of Dim 1 common in both of them

I am stuck with a deadline, Will really appreciate a quick response.

[rathjeevesh]

Use the option of merging of dimension. Use two independent data provider for star schema 1 and another for star schema 2. Then merge the result based upon your common dimension which will do a left outer join between these results.
Please clarify on your exact reporting requirement. Then a concrete solution can be proposed.

[ngalemmo]

1. Upon using both the fact table and the dimension table I see two queries being generated. Which are then getting Unioned and giving me the result. Will this give correct reslut?

This is correct.

I want to have a single query that picks fact from both the fact tables having dimension members of Dim 1 common in both of them

No, this is absolutely NOT what you want it to do. BOBJ handles star schema correctly. Don't mess with it.

[Sponsored content]