Skip to Content
0
Former Member
Apr 21, 2010 at 11:32 AM

Issue with webi on BEx query: wrong result for characteristic = #

37 Views

Hi,

I have the following issue:

in the webi query definition I have characteristics which have no value (not assigned, #) in the cube fact table.

E.g. in contracts the characteristic "partner 1" always exists, but "partner 2" is optional.

In the Bex query, I have partner 1 in the rows, partner 2 as free characteristic.

when drawing partner 2 into the rows in executed analyzer table, the number of rows and the results of the key figures are not changed, regardless whether partner 2 is filled or not.

But the webi drops out the rows where partner 2 is not assigned ( = #). Already when having partner 2 only in the webi query definition, not yet drilled into the report. In this way, I cannot use Webi on BEx at all !

is there any parameter on universe or anywhere elseI need to adjust?

Thanks for every help and,

cheers,

Phil