How can we Aggregate when there is Huge Records

[#1]

Hi Friends,

I am Reloading data. It had up to 20lakh Records. I want to do sum(Particular qty)  for Particular Dimension

for example Creation Date

Created_Data:

Load [Creation Date],

      sum(Quantity)  as Total_Quantity

Resident Xyz

Group by [Creation Date];

Application is Running successfully but I am not getting expected data. If I do the same thing in front end side by taking

[Creation Date] as Dimension and  Sum(Quantity) as Expression then I am getting expected data.

Is there any method to resolve this when there is huge number of records . I just want to do this only in scripting.

Can any of you friends can please help me to resolve this it's bit priority

Thank you,

Swarup Raj

[swuehl]

Can you elaborate a bit more detailed what the difference between the aggregates in script and front end is?

[Clever_Anjos]

What do you mean by "I am not getting expected data"?

No data at all? Inconsistent one?