I have a universe with Contexts. When i am creating webi report based on this universe, the SQL generated by universe seems fine as it is creating 2 SQL queries, 1 for each context. However, the data on report is split into 2 blocks and not joined on the objects common in both contexts.
Am i missing something? Any help is greatly appreciated. We are on BI 4.1 and using Information Design Tool for universe development.
Attached are the screenshots of report query and output.
It will probably be because you have dimensions in each context that do not belong together.
For example, you may want car and motorbike sales by showroom by month, with some more specific details about the cars and bikes.
Your query might look like
Make | Model | Number of Doors | Sidecar Included | Sales Month | Showroom | Cars Sold | Bikes Sold
This would split out into your cars and bikes contexts as:
Cars:
Make | Model | Number of Doors | Sales Month | Showroom | Cars Sold
Bikes:
Make | Model | Sidecar Included | Sales Month | Showroom | Bikes Sold
So, you have common dimensions of Make, Model, Sales Month and Showroom that will (if allowed) automerge. You have your measures of Cars Sold and Bikes Sold that can be reported together against the common objects. However, Number of Doors makes no sense when talking about bike sales and Sidecar Included makes no sense when talking about car sales.
While this example has things that obviously don’t belong, your case may have things that are less obvious. It may be a flaw in the data model if you believe that they should fit or it may be a misunderstanding.
Hi Andreas - Please find the report SQL in attached text file.
Hi Mak 1 - The report has only 1 data provider and the same objects appear on both data blocks on the report (all the objects that are one of the report blocks are also displayed in the other block with some additional objects)
OK, so are they merged together or not?
Have you tried merging manually, if not?
Once you have confirmed they are merged…
Measures will be compatable with non merged attributes, you will have to make detail objects for the non-conformed dimensions, you wish to display in the same block.
Ah, so it’s a single data provider with objects from different contexts. As per my example, the report is splitting itself into two parts because there are dimensions from different contexts in the same query. If you look at the generated SQL you’ll see two distinct SQL statements and two different group by statements. This means that the two measures are being returned at different levels of granularity and should not be logically presented together - Webi is preventing this from happening.
(BOB member since 2002-06-20)
(BOB member since 2005-01-06)