As my subject, I wish someone could give me the example on how I can utilize with a simple example for Dynamic data reduction.
Here with my problem,
I have an apps that could be access by 6 of our region managers (means 6 token user licenses), and each of them able to access to the data on their own region ONLY.
I have tables:
1. Sales Transaction, which is contain the data of sales transaction and the city_code included.
2. Sales structure, which is contain the master of sales structure group where city_code is to be assign into an area_code. And area_code assign into a region_code.
I figure the structure of sales would be like: National Sales - Region_Code - Area_Code - City_Code.
How to arrange the data load (for table Sales Transaction) to be reduced into each Region_Code (as it will be one to one relation with Region Manager User ID)?
I tried to search the solution and no result so far.
Thanks for the help.