Data reduction using mnultiple fields

[nikhilgarg]

HEy,

I was going thru the following article:

Data Reduction Using Multiple Fields

But couldn't understand how we decide where we put authorization key? How OrdersDetails table is selected for Authorization key.

Can somebody help me here.

Thanks

[Gysbert_Wassenaar]

Beacuse OrderDetails is the only table where that key makes sense. There can be multiple products per order so multiple productgroups per order are possible. Therefore the key cannot be part of the Orders table. Country is not related to Product so the key can't be part of the Products table. The only place where that key can be created is in the OrderDetails table.

[nikhilgarg]

Hey,

I have a qstn. In my application section access working fine as per reduction field but when i reload then all data is being shown. Why is it so?