Less than or Equal to Variable on Calquarter is not working in Webi

[Former Member]

Hi Guru,

I have Variable on Calquarter which brings the query result for all the cal quarters which are LESS THAN or EQUAL to entered one.

But, when we execute the Webi Report of this Bex Query, we get data for all the Calquarters in the infoprovider.

Its a "Single Value, Optional" variable with operand as LE.

Thanks in advance,

Deepak Jain

[Former Member]

Thanks all,

Calquarter is mapped as Key only.

We noticed that though its a single value Bex Variable, it doesn't work.

[former_member183012]

This message was moderated.

[Former Member]

Heloo Deepak,

Can you please put the screenshots here?

[former_member39123]

In BEx side, calquarter is mapped as key or text?

Maybe it is mapped as text and the variable in BO doesn't work correctly.

Regards.