Hi,
I'm trying two type of set analysis which do the same thing: subtract a list of CustomerID (taken from an object not linked to the data model and so not influenced by selections on the document but only from the selections on that object) from another list of CustomerID (this object linked to the data model).
This subtraction is used as modifier of the set analysis for a certain dimension inside a pivot table.
The amount of CustomerID is less than 1 million.
There are no problems of performance with a small set of data.
The application freeze with more data and the calculation of object goes in time-out.
The set analysis are:
1.
if(GetSelectedCount(desc_manif_escl)>0 or GetSelectedCount(desc_ediz_escl)>0,
count({$<CustomerID={$(var_CustomerID_Selected)}-{$(var_CustomerID_Excluded)}>} Dimension),'2')
2. The same as above but with the explicitation of variables directly inside the set analysis:
if(GetSelectedCount(desc_manif_escl)>0 or GetSelectedCount(desc_ediz_escl)>0,
count({$<CustomerID_Selected = {"$(=concat(distinct Chr(39) & CustomerID_Selected, Chr(39) & ',' ) & Chr(39))"}- {"$(=concat(distinct Chr(39) & CustomerID_Excluded, Chr(39) & ',' ) & Chr(39))"}>} Dimension),'2')
3. This set analysis uses a field connected with CustomerID's instead of the CustomerID's and subtract from them a variable containing the same field taken from the object not linked to the data model
if(GetSelectedCount(desc_manif_escl)>0 or GetSelectedCount(desc_ediz_escl)>0,
count({$<Azi_manif_desc_manif={"*"}-{$(vManifestazione_esclusione)}, Azi_manif_desc_ediz={"*"}-{$(vEdizione_esclusione)}>} Dimension),'2')
Any tips or suggestions?
It's a critical problem to solve asap...
Thanks
