Help in Data Modelling, App Optimization

pradnya_amol — Sat, 16 Nov 2024 03:20:38 GMT

Hello All,

Sometimes a small, tiny thing doesn't get solve; please help me in data modelling; don't know what am I missing. Check the script and let me know what else I can do to make my Data Model perfect. I have a few conditions on UI which is making my App very slow on Access Point.

Attached is the screenshot for Data Model.

BVAFactId in BVA Table:- Information Density: 100% Subset Ratio: 1%

BVAFactId in Key Table: Information Density: 100% Subset Ratio: 31%

M14FactId in M14Table:- Information Density: 100% Subset Ratio: 99%

M14FactId in Key Table: Information Density: 100% Subset Ratio: 31%

%DATE_KEY in Master_Calendar: Information Density: 100% Subset Ratio: 75%

%DATE_KEY in Key Table: Information Density: 100% Subset Ratio: 100%

Script:

Master_Calender:
LOAD
CalendarMonthName,
Num(CalendarMonthName) as CalendarMonthNumber,
CalendarQuarter,
CalendarYear,
CalendarMonthAndYear as %DATE_KEY,
date(CalendarMonthAndYear,'MM.YY') as CalendarMonthAndYearNum,
CalendarMonthAndYear,
CalendarQuarter & '-' & Right(CalendarYear,2) as CalendarQuarterYear,
If(CalendarYear <= Year(today()) and CalendarYear>=$(vPreviousYear),CalendarYear) as FilterCalendarYear

FROM
\\deawiwqlvt041.syngentaaws.org\QlikView\QlikViewStorage\SourceDocuments\Shared Folder\Master Calendar\MasterCalendar.QVD
(qvd)
Where CalendarYear>=($(vPreviousYear)-1) and CalendarYear<=$(vNextYear);

Key:
LOAD FactId as M14FactID,
FactId as BVAFactID,
date("Calendar Date",'MMM YYYY') as %DATE_KEY
FROM
[\\deawiwqlvp041.syngentaaws.org\QlikView\QlikViewStorage\SourceDocuments\Transformation Layer\Global\MRH\Qlikmart\Sales\QVD\T_G_MRH_QM_MRH1_Consolidated_Sales_Key.QVD]
(qvd) where Year("Calendar Date") >=($(vPreviousYear)-1) and Year("Calendar Date") <=$(vNextYear);

BVA:
LOAD FactId as BVAFactID,
[BVA.ACT Value]
FROM
[\\deawiwqlvp041.syngentaaws.org\QlikView\QlikViewStorage\SourceDocuments\Transformation Layer\Global\MRH\Qlikmart\Sales\QVD\T_G_MRH_QM_MRH1_BVA_Fact.QVD]
(qvd) where Exists(BVAFactID,FactId);

M14:
LOAD FactId as M14FactID,
[Sales_PC.VAR BUD PY STD Value]
FROM
[\\deawiwqlvp041.syngentaaws.org\QlikView\QlikViewStorage\SourceDocuments\Transformation Layer\Global\MRH\Qlikmart\Sales\QVD\T_G_MRH_QM_MRH1_Sales_Product_Costing_Fact.QVD]
(qvd) where Exists(M14FactID,FactId);

Re: Help in Data Modelling, App Optimization

Brett_Bleess — Mon, 15 Jul 2019 19:37:27 GMT

This is a duplicate post, see the following post for resolution:

https://community.qlik.com/t5/QlikView-App-Development/Help-in-Data-Modelling-App-Optimization/m-p/1590352#M443520

Regards,
Brett

topic Help in Data Modelling, App Optimization in QlikView

Help in Data Modelling, App Optimization

Re: Help in Data Modelling, App Optimization