topic Re: MAX RAM Usage for Report in QlikView

MAX RAM Usage for Report

ramasaisaksoft — Mon, 28 Jul 2014 09:26:16 GMT

Hi Experts,

I have a report(size is 45,781KB QVW file).For this report script is fetch data from 5 QVD files and 4 small tables(No.Of records fetched is 23,380,293) and Elapsed time is taken 3:53 sec.

Note:-There is no Syn Keys and Syn Tables

My Problem is, if i open or select any field in the report automatically RAM of the server is reaches to 9GB to 15 GB approximately in Qlikview (Actually i have 16 GB in My Server) and in Qlikview Accesspoint if the end user select any item in the list box ,Then automatically he lost his connection.

What happens inside i don't know can any one help me.

Re: MAX RAM Usage for Report

avinashelite — Mon, 28 Jul 2014 09:31:33 GMT

Hi Sai,

Please check with the data model once..... This kind of situation occurs when completely independent data sets trying to make association.

Please post your app.

Re: MAX RAM Usage for Report

Mon, 28 Jul 2014 09:46:36 GMT

Hi Sai,

Usualy this happens if your subset ratio and Information Density is very low. You can check this by going in the Table View and then hower over your data links.

Another reason is that you are trying to display to much expresssions in a graph?

Regards,
Marius

Re: MAX RAM Usage for Report

ramasaisaksoft — Mon, 28 Jul 2014 10:38:13 GMT

friends here i mentioned with some example data

Service_Type:
LOAD distinct
Parent_Entity_Id as "Service Type"
FROM
D:\Entity.qvd
(qvd)
where Parent_Entity_Type = 'SERVICE TYPE';

Financial_Entity:
LOAD
Entity_Id as "Financial Entity Id"
FROM
D:\Entity.qvd
(qvd)
where Entity_Type = 'FINANCIAL ENTITY';

Service_Entity:
LOAD
Entity_Id as "Service Id",
Entity_Name as "Service Name"
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'SERVICE';

Vendor_Entity:
LOAD Entity_Id as "Vendor Id",
Entity_Name as "Vendor Name",
Entity_Type
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'VENDOR';

Category_Entity:
LOAD Entity_Id as "Category Id",
Entity_Number as "Category Number",
Entity_Name as "Category Name"
FROM
D:\Entity.qvd
(qvd)
Where Entity_Type = 'CATEGORY';

Fact_Reservation:
LOAD DISTINCT
Reservation_Number as "Reservation Number",
Reservation_Item_Number,
Reservation_SubItem_Number,
Date(date#(Book_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Book Date" ,
Date(date#(Travel_Begin_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Travel Begin Date" ,
Item_Status_RESITTB as "Item Status",
Party_Name as "Party Name",
Brand_Id,
Financial_Entity_Id_RESHDTB as "Financial Entity Id" ,
Date(date#(Service_Begin_Date,'YYYYMMdd'), 'MM/DD/YYYY') as "Service Begin Date",
Service_Duration as "Service Duration",
Service_Id_RESITTB as "Service Id",
Service_Type as "Service Type",
Item_Cost_Exchange_Rate as "Item Cost Exchange Rate",
Item_Cost_Currency as "Item Cost Currency",
Vendor_Id as "Vendor Id",
Number_of_Passengers_RESITTB as "Number of Passengers",
Total_Cost_Amount_RESITTB as "Total Cost Amount",
(Total_Cost_Amount_RESITTB/Item_Cost_Exchange_Rate) as "Cost Vendor Currency",
Category_Id as "Category Id_",
Category_Number as "Category Number"
FROM
D:\Fact_Reservation.qvd
(qvd)
where Service_Type <> 'PACKAGE';

is there any way, shall i load Entity. QVD only once and use with different parameter conditions

like case statement/Switch statement.please help me it is urgent

LOAD Entity_Id as "Category Id",
Entity_Number as "Category Number",
Entity_Name as "Category Name"

from

case1:

where Parent_Entity_Type = 'SERVICE TYPE'

case 2:

Where Entity_Type = 'SERVICE'

case3:

Where Entity_Type = 'VENDOR'

case4:

Where Entity_Type = 'CATEGORY'

Re: MAX RAM Usage for Report

Mon, 28 Jul 2014 10:46:47 GMT

Hi Sai,

This does not help us much as we do not know what the data behind this looks like.

You have to look at the subset ratio and Information Density as mentioned above.

Regards,
Marius

Re: MAX RAM Usage for Report

avinashelite — Mon, 28 Jul 2014 11:46:30 GMT

Hi Sai,

Can post the data model and test data, so that it will help us to identify the issue.

Regards,

@vi