I have a universe based on a BEx query. There are 6 key figures in the BEx query. All of them display data in Query Designer. In the WEBI report, however, for one of the measures it displays only 0. Any ideas what may be causing this issue?
There are two very similar key figures: ZCNT_1 and ZCNT_2. They both have the same aggregation (Agg = Maximum, Exception Agg = Last Value, Agg. ref. char. = 0CALMONTH).
These key figures have been created in the DSO (i.e. they are not just calculated key figures in query level).
In BEx ZCNT_1 and ZCNT_2 display 4234 and 291827 respectively. In WEBI they display 0 and 291827 respectively.
Any ideas on cause or resolution?
Edited by: Khaled McGonnell on Jul 27, 2010 5:10 PM