Confidentiality issue with the data

[mayankraoka]

Hi Team,

I have below mentioned requirement:

I have state ,customer shops,time as dimensions.Sales and Market share are the metrics.

If the state is associated with 1 customer shop we cant show market share data.Suppose there are 4 state for ex states A,B,C,D .User Selected 4 states but the 1 state for ex A is associated with only 1 customer so the resultant data should not add the market share value for state A as it breaks confidentiality rule of 1 customer only.Is there any way user can select only that state which passes confidentiality rule:

Please let me know in case of any other information required.

Regards,

Mayank

[swuehl]

Try a filter in your aggregations using set analysis like

=Sum({<State = {"=Count(DISTINCT Customer)>1"}>} Amount)

[mayankraoka]

Thanks swuehl,

How can we restrict to select that state(From list box and straight table) if that fails the confidentiality?

Regards,

Mayank

[swuehl]

If you use the set analysis in all aggregations, the state should not appear in your dimensions.

In a list box, you can restrict the State names like

=Aggr(Only( {<State = {"=Count(DISTINCT Customer)>1"}>} State),State)

You can also filter your states in your script or use a flag field to filter your records.

[mayankraoka]

Thank you Swuehl,

I will test this and let you know in case of any issue.I can not remove the record as I can show other Metrics like sales amount.The confidentiality rule is applicable only for 1 metrics that is Market share.So restrictions will also wont allow to get data for other metrics?

Is there any way they cannot select that state which fails confidentiality rule.For example state B passes the rule But state A wont.So if user select both the states together the rules passes as no of customers are more than 1 .So in this case I dont want user able to select state A and by default selection stays for only state B though they select 2 states.

Regards,

Mayank

[swuehl]

The Count of distinct customers in above advanced search is evaluated per state, hence B passes and A is not taken as part of the resulting set.