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.
Go to Solution.
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 !]
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:
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 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!
In the Qlik help site, there is a description how to define the report with the Qlik SAP Report Connector.
Link: Defining a report
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.