Hi Experts,
I'm getting an error while executing a BEx query in portal.
Background:
There is a NAV attribute(CHAR(5)) in multiprovider. This object can hold positive values, negative values and 0. (-3. -2, -1, 0, 1, 2, 3)
We have created a user entry variable in query on this NAV attribute.We have created as CHAR, as we want to hold negative values in it and wanted to use it as NAV attribute.
Query is running fine when I'm entering positive and negative values however when I'm entering 0, it is giving following error:
Characteristic 'X' has no master data for "0" or you do not have authorization.
An invalid selection for characteristic has been discarded.
All selections for characteristic 'X' are invalid and have been discarded.
The same query works absolutely fine in RSRT with all types of values - positive, negative and 0.
Please suggest.
Any help would be highly appreciated.
Regards,
S