Webi Report - Data Problem.

building reports webintelligence
1

I have report that has customer name and address. Customer ABC has two addresses which is valid. Yesterday morning when I ran report, report showed only one address, and when I ran report again in the evening it showed two addresses. Data did not changed I am working with March data, so no problem with Database side.

This morning I ran same report I am getting one address only, so I did following steps:

  1. Ran report in webi got one address.

  2. Took query and ran in pl/sql , returned two addresses.

  3. In qury filter I added customer name =‘ABC’ and refreshed report it returned two addresses.

  4. I compared sql’s from step1 and step3 no difference in joins, one different is it has extra filter condition on customer name.

I am lost no idea why its behaving differently. Any help appreciated.

rajpal (BOB member since 2010-05-07)

2

First, you need to check whether it’s BO side or SQL side or data side.

WebI Side:

  • Query : enable duplicated values (if twice the same adresse you want)
  • in your tab : also check show duplicated rows

SQL side : let’s imagine it’s tow different adress and the way you filter impact the SQL code.
What can happen :
Add a filter >> Add an object >> Add a DB table >> add a Join operation >> additionals rows extracted

mathieuBO (BOB member since 2011-01-06)