Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravindra
Contributor II
Contributor II

Error while fetching data from SAP BW Report

I am trying to fetch data from SAP BW report using SAPConnector BEXquery.

But I am unable to fetch the data, it throws below error message:

Custom read failed
SELECT [ZICPPAN_Q001]
DIMENSIONS (
[AUART],
[AUFNR],
[AUTYP],
[BLDAT],
[BOMCAT],
[BUDAT],
[BUKRS],
[BWART],
[CALWEEK],
[CHARG],
[CQUARTER],
[KDAUF],
[LGORT],
[MANDT],
[MATKL],
[MATNR],
[MBLNR],
[MJAHR],
[MONTH],
[PRCTR],
[QUARTER],
[WERKS],
[ZEILE],
[ZMATKL],
[ZMATNR],
[ZMATNR1],
[ZMTART],
[ZZGRADE],
[ZZKGPERMC],
[ZZL2ID],
[ZZLENGTHC],
[ZZSECTION],
[ZZSIZE],
[ZZSTD],
[0CALDAY],
[0CALMONTH],
)
MEASURES (
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
UNITS (
[CURRENCY001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
[UNIT001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
VARIABLES (
[NAME=ZCOMP_CODE11, SIGN=I, OPTION=EQ, LOW=6000],
[NAME=ZCALMONTH, SIGN=I, OPTION=BT, LOW=201811, HIGH=201901],
)
FROM [ZICPPAN]

Below is the Script:

CUSTOM CONNECT TO "Provider=QvBexConnector.exe;servertype=0;ASHOST=000.00.00.00;CLIENT=00;SYSNR=00;Timeout=3600;SNC_MODE=false;SNC_QOP=9;XUserId=EDfcZIRJJaSKVJVISSbB;XPassword=YaISQIRNJbaAUYIGTZaB;";
[ZICPPAN_Q001]:
LOAD
[AUART] as [Document Type],
[AUFNR] as [Order Number],
[AUTYP] as [Order category],
[BLDAT] as [Document Date],
[BOMCAT] as [BoM Category],
[BUDAT] as [Posting Date],
[BUKRS] as [Company Code],
[BWART] as [Movement Type],
[CALWEEK] as [Calendar Week],
[CHARG] as [Batch Number],
[CQUARTER] as [Quarter],
[KDAUF] as [Sales Order Number],
[LGORT] as [Storage Location],
[MANDT] as [Client],
[MATKL] as [Material Group],
[MATNR] as [Material],
[MBLNR] as [Material Document],
[MJAHR] as [Material Document Year],
[MONTH] as [CALMONTH],
[PRCTR] as [Profit Centre],
[QUARTER] as [Calendar Quarter],
[WERKS] as [Plant],
[ZEILE] as [Material Document Item],
[ZMATKL] as [Material Group],
[ZMATNR] as [Planned Material],
[ZMATNR1] as [Prime/Non-Prime],
[ZMTART] as [Material type],
[ZZGRADE] as [Grade],
[ZZKGPERMC] as [KgPerMeter],
[ZZL2ID] as [Level II ID],
[ZZLENGTHC] as [Length],
[ZZSECTION] as [Section],
[ZZSIZE] as [Size],
[ZZSTD] as [Standard],
[0CALDAY] as [Calendar day],
[0CALMONTH] as [Calendar year/month],
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL] as [Consumption Quantity],
[CURRENCY001] as [CURRENCY001 Consumption Quantity],
[UNIT001] as [UNIT001 Consumption Quantity];
// Uncomment appropriate lines and move the semicolon
// to load TEXT data for the dimensions that are known
// to include text:
// [AUART__TEXT] as [Document Type TEXT],
// [AUFNR__TEXT] as [Order Number TEXT],
// [AUTYP__TEXT] as [Order category TEXT],
// [BLDAT__TEXT] as [Document Date TEXT],
// [BOMCAT__TEXT] as [BoM Category TEXT],
// [BUDAT__TEXT] as [Posting Date TEXT],
// [BUKRS__TEXT] as [Company Code TEXT],
// [BWART__TEXT] as [Movement Type TEXT],
// [CALWEEK__TEXT] as [Calendar Week TEXT],
// [CHARG__TEXT] as [Batch Number TEXT],
// [CQUARTER__TEXT] as [Quarter TEXT],
// [KDAUF__TEXT] as [Sales Order Number TEXT],
// [LGORT__TEXT] as [Storage Location TEXT],
// [MANDT__TEXT] as [Client TEXT],
// [MATKL__TEXT] as [Material Group TEXT],
// [MATNR__TEXT] as [Material TEXT],
// [MBLNR__TEXT] as [Material Document TEXT],
// [MJAHR__TEXT] as [Material Document Year TEXT],
// [MONTH__TEXT] as [CALMONTH TEXT],
// [PRCTR__TEXT] as [Profit Centre TEXT],
// [QUARTER__TEXT] as [Calendar Quarter TEXT],
// [WERKS__TEXT] as [Plant TEXT],
// [ZEILE__TEXT] as [Material Document Item TEXT],
// [ZMATKL__TEXT] as [Material Group TEXT],
// [ZMATNR__TEXT] as [Planned Material TEXT],
// [ZMATNR1__TEXT] as [Prime/Non-Prime TEXT],
// [ZMTART__TEXT] as [Material type TEXT],
// [ZZGRADE__TEXT] as [Grade TEXT],
// [ZZKGPERMC__TEXT] as [KgPerMeter TEXT],
// [ZZL2ID__TEXT] as [Level II ID TEXT],
// [ZZLENGTHC__TEXT] as [Length TEXT],
// [ZZSECTION__TEXT] as [Section TEXT],
// [ZZSIZE__TEXT] as [Size TEXT],
// [ZZSTD__TEXT] as [Standard TEXT],
// [0CALDAY__TEXT] as [Calendar day TEXT],
// [0CALMONTH__TEXT] as [Calendar year/month TEXT];

SELECT [ZICPPAN_Q001]
DIMENSIONS (
[AUART],
[AUFNR],
[AUTYP],
[BLDAT],
[BOMCAT],
[BUDAT],
[BUKRS],
[BWART],
[CALWEEK],
[CHARG],
[CQUARTER],
[KDAUF],
[LGORT],
[MANDT],
[MATKL],
[MATNR],
[MBLNR],
[MJAHR],
[MONTH],
[PRCTR],
[QUARTER],
[WERKS],
[ZEILE],
[ZMATKL],
[ZMATNR],
[ZMATNR1],
[ZMTART],
[ZZGRADE],
[ZZKGPERMC],
[ZZL2ID],
[ZZLENGTHC],
[ZZSECTION],
[ZZSIZE],
[ZZSTD],
[0CALDAY],
[0CALMONTH],
)
MEASURES (
[BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
UNITS (
[CURRENCY001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
[UNIT001.BZ5JHCA0A6ZTSKRRW0ZYZ0PDL],
)
VARIABLES (
[NAME=ZCOMP_CODE11, SIGN=I, OPTION=EQ, LOW=6000],
[NAME=ZCALMONTH, SIGN=I, OPTION=BT, LOW=201812, HIGH=201901],
)
PARAMS (FORMAT=Y)
FROM [ZICPPAN];
STORE * FROM [ZICPPAN_Q001] INTO ZICPPAN_Q001.qvd;
DROP TABLE [ZICPPAN_Q001];

Please advise to resolve.

Thanks in advance.

Labels (1)
0 Replies