pls suggest

[#1]

Hi,

Pls see the enclosed app.I have loaded only 10 days of days here .so its fast but if I load the entire data it is very very slow.i think its because of the ifs am using in the expressions.Is there a way to avoid these ifs and put in the load script.Pls suggest.

Pl See:Blackhawk GC Redemption Counts by Month - Fully Redeemed

Thanks,Swetha

[#2]

Hi Jai,

I have seen ur updated app clearly and its good,but when I load the entire data using qvds it says out of memory ,any ideas wud be appreciated.

Here is the script:

SET

ThousandSep=','

;

SET

DecimalSep='.'

;

SET

MoneyThousandSep=','

;

SET

MoneyDecimalSep='.'

;

SET

MoneyFormat='$#,##0.00;($#,##0.00)'

;

SET

TimeFormat='h:mm:ss TT'

;

SET

DateFormat='M/D/YYYY'

;

SET

TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

;

SET

MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

;

SET

DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

;

CONNECT

TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DMC_GIFTCARD;Data Source=DATAWHSE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MIS-DW2;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is

IQfKcZFMfA);

ODBC

CONNECT TO DMC_GIFTCARD (XUserId is fRNEeZFMLB, XPassword is

NNdaeQZOSBMKTZAGAH);

LOAD

"DATE_KEY"

,

"STORE_KEY"

,

"SEQUENCE_KEY"

,

"GC_THIRD_PARTY_FLAG"

,

"GC_BUY_OR_REDEEM"

,

"GC_CARD_NUMBER"

,

"GC_AMOUNT"

,

"GC_BALANCE"

,

"GC_AUTH_TYPE"

,

"GC_TRANS_TIMESTAMP"

,

"GC_TRANS_ID"

,

"GC_ACTIVATION_TYPE"

FROM

C:\qlikview_Old\Swetha\GIFT_CARD.qvd(qvd)

;

LEFT

JOIN

LOAD

GC_CARD_NUMBER, REDEEM_AMT, REDEEM_YEAR, REDEEM_MONTH,

GC_BALANCE1

FROM

C:\qlikview_Old\Swetha\OUT_BALANCE.qvd(qvd

)

where

exists(GC_CARD_NUMBER)

;

LEFT

JOIN

LOAD

ACTYEAR , ACTMONTH

,

Act_Total

FROM

C:\qlikview_Old\Swetha\ACTYEAR.qvd(qvd)

;

[#3]

Hi,

You didnt shared data of table..just let me know the size of each tables and how many rows you are fetching

Apart from that I hope the issues because of

1.You fetching data irectly from data base,it may slow down your application.

Try to createqvds then pull data from there

2.Logic behind "Left Join" ,It may slow down the application.

3.If possible use if conditions in back end for caluclated dimension

Let me know for further uery

Thanks & Regards

Jai