4 Replies Latest reply: Dec 2, 2015 10:23 AM by Chandni Bhowmick RSS

    SAPReport Connector

    Chandni Bhowmick

      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.

      ab.png

       

      Thanks!

        • Re: SAPReport Connector
          Tomas Sommergyll

          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