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,

I am not able to down load your doc.Can you attach the doc seperately

Thanks & Regards

Jai

[#3]

Pls find teh doc attached.

[#4]

Hi,

As per our company policy I was not able to download any '.zip' doc. if possible attach one by one.Sorry for the in convenience

Thanks & Regards

Jai

[#5]

pls see the app.

[#6]

Hi,

In your pivot table "grouping" function is missing.With out grouping function it will be very hard to load the data.So I have updated one of your pivot table of "Blackhawk GC Redemption Counts by Month - Fully Redeemed_updated_jai " and attached here.Have a look and if you have any query let me know the same.

Thanks & Regards

Jai

[#7]

Thanks for the reply Jai.But when I open your report it shows allocated memory exceeded,Thats also one of teh problem am facing.

[#8]

Hi,

If possible select some values in list box.That time you will get some values.Better create qvd's then pull the data.And also have a look in data model.It may help you.For further query reply back.

Thanks & Regards

Jai

[#9]

And also the data does not match with the original report I have sent.

Thanks

[#10]

I have only selected one day .And I guess you have added the expression:

=only(if(CALENDAR_DATE>=VSTARTDATE and CALENDAR_DATE<=VENDDATE and

GC_BALANCE1='0',GC_CARD_NUMBER))

to the dimensions tab.Whenever I did that it just says it exceeded memory even If I select only one day.