How can we Aggregate when there is Huge Records

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How can we Aggregate when there is Huge Records

swuehl — Thu, 05 May 2016 17:23:44 GMT

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

Clever_Anjos — Thu, 05 May 2016 17:59:53 GMT

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

No data at all? Inconsistent one?