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