BEx Date variable doesn’t show calendar in webi prompt
A bex query based of a Multiprovider has a date variable that prompts the user to enter date in calendar format. This is working as expected in BEx Analyzer. But when the report is run via webi which is based on a universe (.unv), the webi shows List of values (LOV) instead of a calendar format.
The BEx variable is based on 0Date. Data type is DATS.
The variable comes through the universe (.unv) as a dimension that’s in italics. It has the following properties:
Type: Character ( changing this to DATE also not working)
Primary key: Character
‘Associate a list of values’ under properties is checked. Unchecking it gives an error on webi report on run time.
Any ideas how to get this fixed.