Skip to Content
Feb 08, 2021 at 01:47 PM

WEBI report - more BEx queries as a source



I am making a report in WEBI and source for graphs and tables is several queries. In each query is 0CALMONTH and 0VENDOR characteristic, because for generation of report is used publication with dynamic recipient mapping. In a WEBI I have created merged dimension for both characteristics to ensure that dynamic recipient source query set input to each table. Generation of report restricted for one month works, but I am facing an issue with tables, where I want to present data for more months than for one. If I generate report, I have all tables and graphs displayed for one month, but in few tables should be displayed data for more months. When I restrict 0CALMONTH in source query of this table, it won't works. (Is it because of dynamic recipient source query, which has in this case restriction for one month only and overwrites the variable of source query of the table?)

How can I fix the problem?

Thank you.