Hi, I’m very new at BO, I’m creating a simple report in which I have two queries synchronized by an attribute. I should report that the tables on which the queries are based, are not physically linked on the DB, I created this link as a join in the Universe, so there’s no referential integrity contraint (no problem in this case because the data are very few).
The report I created is composed by 5 columns, and some rows, with a Sum Calculation row at the end. But the problem is that above the last row I have a blank row that I can’t remove, and I don’t know where it comes from!!
hi Christian, when you synchronize, it’s like a outer join in both directions. So it the results display matching values from both data providers AND non matching. I think this is your problem.
You need to create a filter (Insert / filter from the menu). Filter out the null values of a measure.
(BOB member since 2002-08-15)