Qlik Community

QlikView Connectors

chandni90
New Contributor III

SAP OLAP Connector

Hi

I have connected to SAP BW by the SAP OLAP Connector. How do I write a where clause in the script? I want to filter the document date from year 2014 to year 2016.

Please help.

df.png

2 Replies
Not applicable

Re: SAP OLAP Connector

Hello Chandni,

How it works when you have mandatory variables in the BEx query, I don't have connector to check, can you pls let me know.

Thanks,

balrajahlawat
Esteemed Contributor

Re: SAP OLAP Connector

just after from ($OFIAP_C03)) where  Year=2014....;

2nd last line from below of the table..

Hope this will help!1

Community Browser