Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you elaborate a bit more detailed what the difference between the aggregates in script and front end is?
What do you mean by "I am not getting expected data"?
No data at all? Inconsistent one?