I am trying to connect to SAP BW query using Bex Connector and I am able to fetch the data after running the script as shown below :
Now I close the pop up and Sheet Properties window appears where I should see the list of Available fields and then I can select the desired ones to get displayed in the sheet. But here I am getting the available fields empty and none of the fields are available (Screenshot below ). Hence I am unable to proceed .
Any pointers on how to overcome this issue and get the field list displayed ?
That's basic practice when using one of the SAP Connectors. SAP Connector is most often used in a first data stage where SAP data is read into QlikView and stored in QVDs. These QVDs will be used by the QlikView document in the next data stage to transform tables into QlikView tables or data marts.
There is no use for QlikView to keep those tables in the document as they do not form a data model. The end result is the set of QVDs that is created on disk.