topic Re: SAPReport Connector in QlikView

SAPReport Connector

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

I have connected to a SAP report by the SAPReport Connector. How do I rename the dimensions in the script? It's not taking aliases (as). Please Help.

Thanks!

Re: SAPReport Connector

Tomas_Sommergyll — Wed, 25 Nov 2015 11:35:56 GMT

Hi Chandni,

What version of the connector are you running?

In your Load field it looks as you have only ONE column field: it shows as:

LOAD [Field0_ ! SomeHeader1 ! SomeHeader2 ! SomeHeader3 !]

FROM ...

This means the columns needs to be separated by using the Field Delimiter "Add"-button, please see the manual how to do that.

Then it will look something like this:

Load [Field0_Material],

[Field1_Descr],

[Field2_Test];

...

Which you can change with AS:

Load [Field0_Material] AS 'name1',

[Field1_Descr] AS 'name2',

[Field2_Test] AS 'name3';

...

Is it possible to tick the "Auto Detect Column Width" box in that report? If so you would get the Fields automatically (Will not work on all types of Report)

Thanks,

Tomas

Re: SAPReport Connector

Anonymous — Mon, 30 Nov 2015 22:13:16 GMT

Hi,

Thanks for your reply. Sometimes qlikview gives me the fields automatically without using the add button and sometimes it doesn't(for the same SAP Report).

I am not sure how I can use the add button when I don't get the fields automatically. Can you please help. Thanks!

Re: SAPReport Connector

Tomas_Sommergyll — Wed, 02 Dec 2015 12:22:13 GMT

Hi Chandni,

In the Qlik help site, there is a description how to define the report with the Qlik SAP Report Connector.

Link: Defining a report

Re: SAPReport Connector

Anonymous — Wed, 02 Dec 2015 15:23:05 GMT

Hi,

Thank you for your reply. How do I achieve this: "Set the column width" or "Select the option Auto Detect Column Width and click OK" . I don't see these options when I extract the report from SAP to QlikView.