Key figure in BEx working but in WEBI displays only 0

[Former Member]

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?

More detail...

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

[Former Member · Accepted solution]

Hi Khaled,

I'd suggest for you to re-post this inquiry through the Integration Kits - SAP forum to get more visibility from our SAP Integration gurus.

Hope this helps.

[Former Member · Accepted solution]

I've developed a workaround.

I created a global CKF with the following formula: ZCNT_1 * 1.

Now the result displays correctly.

I'd still like to understand why the issue occurs in the first place so please post ideas / suggestions...

[Former Member · Accepted solution]

Hi,

How is there projection defined at universe level?

Regards,

Swapna.G