Problem with date filter in Webi report with merged values

[Former Member]

Hello everyone.

I'm having a problem with a filter prompt from a webi report based in an universe created in IDT.

I created the filter from the query panel on Rich Client with the "Posting Date" of ZBSIS (BUDAT) table and almost i created two more queries using the same universe, because i did it a merge with the tables ZBSAK and ZBSIK to show all the results in the same report.

But the problem is that the filter don't take the merged values and doesn't show me the correct values. Only takes the correct values if I apply a filter to the merged posting value.

Any suggestion to solve this inconsistency?

Regards.

[amitrathi239 · Accepted solution]

If you are getting wrong result then might be issue with joins between the tables.Reason if you are getting correct result if you create the individual queries for each table and not getting from single query.

what type of joins between the table?inner,left/right?

If inner join then you will get the matching records between the tables..think again where is gap..take one record example and find out why it's not coming with other table join.