8 Replies Latest reply: Jul 26, 2016 5:04 AM by Prashant Sangle RSS

    Fields not available after executing Script

    Samir Bihari

      Hi Experts ,


      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 :


      Successful Script Execution.JPG


      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 ?


      Thanks in Advance

        • Re: Fields not available after executing Script
          Prashant Sangle

          Can you post your complete script



            • Re: Fields not available after executing Script
              Samir Bihari

              max dreamer wrote:


              Can you post your complete script





              Hi Max Dreamer ,


              ZCOPA02_Q01_ST_AUTH : SAP BW Query Name

              Connector Used : Qv Bex Connector


              Below is the complete script :


              SET ThousandSep=',';

              SET DecimalSep='.';

              SET MoneyThousandSep=',';

              SET MoneyDecimalSep='.';

              SET MoneyFormat='$#,##0.00;($#,##0.00)';

              SET TimeFormat='h:mm:ss TT';

              SET DateFormat='M/D/YYYY';

              SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

              SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

              SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

              SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

              SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

              SET FirstWeekDay=6;

              SET BrokenWeeks=1;

              SET ReferenceDay=0;

              SET FirstMonthOfYear=1;

              SET CollationLocale='en-US';



              CUSTOM CONNECT TO "Provider=QvBexConnector.exe;servertype=0;ASHOST=;CLIENT=100;SYSNR=00;Timeout=3600;SNC_MODE=false;SNC_QOP=9;XUserId=bZMedJdIQBMKTaEW;XPassword=cDLJTZFMNLaEXYEV;";



              [0CUSTOMER] as [Customer number],

              [0SALES_OFF] as [Sales Office (Territory)],

              [ZDIVISION] as [Division],

              [0FISCYEAR] as [Year],

              [00O2TEUVW6E5MFFKXRIU579Z3] as [Target],

              [00O2TEUVW6E7D0RWWC3NTCGNQ] as [Net Sales Revenue],

              [00O2TEUVW6E7G1N0V5IL04I4J] as [Pending Invoices],

              [CURRENCY003] as [CURRENCY003 Target],

              [UNIT003] as [UNIT003 Target],

              [CURRENCY004] as [CURRENCY004 Net Sales Revenue],

              [UNIT004] as [UNIT004 Net Sales Revenue],

              [CURRENCY006] as [CURRENCY006 Pending Invoices],

              [UNIT006] as [UNIT006 Pending Invoices];

              // Uncomment appropriate lines and move the semicolon

              // to load TEXT data for the dimensions that are known

              // to include text: 

              // [0CUSTOMER__TEXT] as [Customer number TEXT],

              // [0SALES_OFF__TEXT] as [Sales Office (Territory) TEXT],

              // [ZDIVISION__TEXT] as [Division TEXT],

              // [0FISCYEAR__TEXT] as [Year TEXT];



              SELECT [ZCOPA02_Q01_ST_AUTH]

              DIMENSIONS (






              MEASURES (





              UNITS (








              VARIABLES (

                [NAME=ZV_YEAR, SIGN=I, OPTION=EQ, LOW=K42016],


              FROM [ZCOPA02];


              STORE * FROM [ZCOPA02_Q01_ST_AUTH] INTO ZCOPA02_Q01_ST_AUTH.qvd;

              DROP TABLE [ZCOPA02_Q01_ST_AUTH];