topic Reload issue with more feilds in load statement??? in QlikView

Reload issue with more feilds in load statement???

Thu, 17 Dec 2009 22:11:11 GMT

Hi ALL,

Is there any limit to load the number of feilds into the QV script?

As in my case i have more than 20 fields and its not at all loading also.

Could anyone please help me giving any suggestions?

Is this the limitation in QV?

Thanks,

Mahasweta

Reload issue with more feilds in load statement???

Thu, 17 Dec 2009 22:14:07 GMT

I personally have applications with well over 100 calculated dimensions (fields), so I know it's not an issue with QlikView's treatment of quantity of fields. Please upload your qvw (or a reduced copy) so we can have a look. Thanks!

Reload issue with more feilds in load statement???

Thu, 17 Dec 2009 22:14:08 GMT

Hi,

This is my script.once i am reloading its not at all loading (it took minimum 20 minutes,so i stopped)

Absorption:

LOAD "DATE_ID",
Year(DATE_ID) as Year,
'Q ' & Ceil(Month(DATE_ID)/3) as Quarter,
Month(DATE_ID) as Month,
Date(Monthstart(DATE_ID), 'MMM-YYYY') as MonthYear,
'Q' & Ceil(Month(DATE_ID)/3) & ' - ' & Year(DATE_ID) as QuarterYear,
1 AS ABSORPTIONBYPERIOD,
0 AS CUMULATIVEABSORPTION,
0 AS CUMULATIVEPRODUCTION,
0 AS CUMULATIVEDELIVERIES,
0 AS CUMULATIVEDELIVERIESQTY,
0 AS PURCHASINGBYMATERIAL,
0 AS PURCHASINGBYLOCATION,
0 AS PURCHASINGBYLOCATIONQTY,
0 AS CAPACITYUTILIZATION,
0 AS CAPACITYOFFER,
0 AS PLANTCAPACITY,
0 AS MPSBYLOCATION,
0 AS INVENTORYBREAKOUT,
0 AS INVENTORYBYLOCANDMATERIAL,
0 AS INVENTORYRMSOPERATIVE,
0 AS DEMANDANDRMS,
0 AS PRODUCTIONDEMAND,
0 AS SUMMARYKPI,
"LOCATION_NAME",
"LOCATION_NUM",
"PRODUCT_NAME",
PNO,
SUPPLIER_NUM,
0 AS SCENARIO_NUM,
'' AS SCENARIO_NAME,
"PRODUCT_API",
"PRODUCT_FAMILY",
"ACTUAL_HOURS_CBMH",
"ACTUAL_PRODUCTION",
"PLANNED_PRODUCTION",
"ACTUAL_ABSORPTION",
"PLAN_ABSORPTION",
"BUDGET_ABSORPTION",
"BUDGET_PRODUCTION";
SQL SELECT *
FROM ABSORPTION_VW;

Purchasing:
LOAD "DATE_ID",
Year(DATE_ID) as Year,
'Q ' & Ceil(Month(DATE_ID)/3) as Quarter,
Month(DATE_ID) as Month,
Date(Monthstart(DATE_ID), 'MMM-YYYY') as MonthYear,
'Q' & Ceil(Month(DATE_ID)/3) & ' - ' & Year(DATE_ID) as QuarterYear,
0 AS ABSORPTIONBYPERIOD,
0 AS CUMULATIVEABSORPTION,
0 AS CUMULATIVEPRODUCTION,
0 AS CUMULATIVEDELIVERIES,
0 AS CUMULATIVEDELIVERIESQTY,
1 AS PURCHASINGBYMATERIAL,
0 AS PURCHASINGBYLOCATION,
0 AS PURCHASINGBYLOCATIONQTY,
0 AS CAPACITYUTILIZATION,
0 AS CAPACITYOFFER,
0 AS PLANTCAPACITY,
0 AS MPSBYLOCATION,
0 AS INVENTORYBREAKOUT,
0 AS INVENTORYBYLOCANDMATERIAL,
0 AS INVENTORYRMSOPERATIVE,
0 AS DEMANDANDRMS,
0 AS PRODUCTIONDEMAND,
0 AS SUMMARYKPI,
"LOCATION_NAME",
"LOCATION_NUM",
PNO,
"SUPPLIER_NUM",
0 AS SCENARIO_NUM,
'' AS SCENARIO_NAME,
PRODUCT as PRODUCT_NAME,
API as PRODUCT_API,
"PRODUCT_FAMILY",
"SUPPLIER_NAME",
"ACTUAL_PURCHASED",
"FIRM_PURCHASE_ORDERS",
"PURCHASE_QTY",
"PURCHASE_COST",
"PURCHASING_COST";
SQL SELECT *
FROM PURCHASING_VW;

Please help me.

Thanks,

Mahasweta

Reload issue with more feilds in load statement???

Thu, 17 Dec 2009 22:20:18 GMT

Hi ,

You can have a look here.

One note please : i have section access here also.

What i can see here the data is loading but the SYn keys are not getting(i mean the SYn key formation is taking time i hope)

Could you please put some thought into this?

Thanks,

Mahasweta

Reload issue with more feilds in load statement???

Thu, 17 Dec 2009 22:46:29 GMT

Mahasweta,

Looking at that script, it looks like you have a ton of synthetic keys, which could be causing loops. One idea would be to concatenate these tables to prevent this. See this thread: http://community.qlik.com/forums/p/16217/63137.aspx, or search for synthetic keys.