topic Re: need to help in QlikView

need to help

Tue, 15 Jul 2014 06:11:44 GMT

Hello team

in my report one table is getting 21 lakhs records, but once it is getting loaded report got hanged. Can any one help me what need to be done

Re: need to help

Tue, 15 Jul 2014 06:13:59 GMT

Hi Srinivasan,

Try saving your table into qvd and then drop it.

Again load the qvd file. It might work . But not sure.

Re: need to help

its_anandrjs — Tue, 15 Jul 2014 06:18:21 GMT

You are reading the QVD file or may be direct from the source file let me know best option is QVD.

Re: need to help

engishfaque — Tue, 15 Jul 2014 06:25:59 GMT

Dear Srinivasan,

QlikView Data (qvd) file is the best solution for that kind of huge records loading and performing any action over the data quikly and efficiently.

Kind regards,

Ishfaque Ahmed

Re: need to help

sujeetsingh — Tue, 15 Jul 2014 06:28:40 GMT

QVD may be a option

Re: need to help

Tue, 15 Jul 2014 08:09:35 GMT

Team

I am not having any qvd file, i am string loading from the load script (querying from the database itself.), there are no such option to save these data in QVD files.

Re: need to help

ThornOfCrowns — Tue, 15 Jul 2014 08:15:59 GMT

Once you have loaded your data into a table, you can save that table as a QVD.

Re: need to help

its_anandrjs — Tue, 15 Jul 2014 08:16:20 GMT

You have to create the QVD makers for the tables

Ex:-

SQLTable:

SQL Load

From <SQL Source>;

STORE SQLTable into SQLTable.qvd(qvd);

DROP TABLE SQLTable;

QVDTable:

Load

From SQLTable.qvd(qvd);

Re: need to help

Tue, 15 Jul 2014 08:17:15 GMT

While loading the Script.

Store "Table Name" into "Path".qvd' (qvd);

Drop "Table Name";

then Load from the saved qvd file in the path.

Re: need to help

Anonymous — Tue, 15 Jul 2014 08:23:05 GMT

Hi Srini,

You need to do some optimization work during development.

For example,

1) You should create QVD if you have huge record set.

2) Remove unwanted columns when loading data into application.

3) Try to standardize and clean all columns in QVD creation level not in application level.

5) Simplify data modelling. Always go for star schema approach.

4) Always use Set Analysis.

Hope this helps you.

Re: need to help

its_anandrjs — Tue, 15 Jul 2014 08:28:20 GMT

1.Also check your data model by click on the Ctrl+T to view any synthetic keys created or not by checking the synthetic tables may be due to that reason the applications also hangs.

2. Or check there is huge nested If conditions on the application if so then make simple way.

3. May be check for SCD ( Slowely changing dimensions) due to that the application may be getting slow check this also.

Hope this helps

Re: need to help

ashfaq_haseeb — Tue, 15 Jul 2014 08:31:43 GMT

Hi,

May be you need to look at ram.

Are you running short of ram?

Monitor your ram consumption after reload.

If required you need to increase RAM.

Regards

ASHFAQ