Hi,

I have a report that is OLAP enabled that allows the user to filter the data present on the report using the OLAP control panel.The report shows all the fields(columns) it is supposed to show when it is run the first time.However,after applying filter criteria using OLAP control panel and using the RUN button present on the OLAP control panel to run report, few of the fields are not shown.I have earlier developed an OLAP report and that one is perfectly running fine.I developed the new one on the lines of the old report but i am unable to find why this strange problem is happening.

Kindly help me.

Hi Aditya,

Can you please check you Master file for AnV fields? If present, then remove the V part to make the field An and then retest. The issue should go away. This is most likely a known issue.

Hope this helps.

Cheers,

Kerry

Hi Kerry,

I tried inserting the following command in the fex file and it worked.
ENGINE SQL SET VARCHAR OFF

Thankyou very much for your suggestion.
Regards,
Aditya