DATA MISMATCH BETWEEN WEBI AND DATABASE( methods)

I’m facing issues while validating the data. When I generated a web report got 30000 rows copied the use the query script in the database Oracle 11g but it show 5000 rows in the database: were the query filter applied in start date and end date as well as country Name:

Initially validated the data in this method

Example: The data must be validated from 1- Nov-10 and 15-jan-2011 based on the country name

webi data is exported to the excel its strange that one-month data missing (1- nov -2010 is not showing data ) completely nov month is not able in data

Similarly the DB data exported in to excel .Here the data is displayed completely period from 1 nov -10 and 15-Jan-2011

Related questions

4 Answers

If you enable the Avoid Duplicate Row Aggregation than you will get the duplicate data. If you disable it than you are restricting the duplicates in the raw data. So the question is do you want to get all the data even if it's duplicated.