Set Analysis-Two Many Set Analysis

[#1]

Hi,All!

I,m from China.

I got a big problem.I have a big table which contains nearly 100 million data .This table contains all the purchase,sales,returns and other types data and they are separated by one field.So in my project almost every expression contains a set analysis.

I want to know using too many set analysis is good for my project or not!

.

[#2]

Hi,

Usage of complex set analysis can cause server overhead sometimes. This is dependent on the complexity of the calculation and the volume of data involved in the set analysis.

I guess from your post that all your fact information are available in a single field 'SummaryID' and you are applying set analysis for every calculation you create. As a work around, try creating individual columns for each fact in script level (example: if(summaryID='Sales',value) as Sales and vice versa for other facts also)

Let me know if my understanding is wrong.

Cheers,

Haneesh

[#3]

Thanks Haneesh?

I know what you mean and I will have a try!