I couldnt come up with a better subject... but heres the whole story..
Below 2 tables are loaded as part of my application. Dynamic data reduction is configured based on TEAM fields.
TEAM -------- T_4_ID, T_3_ID, T_2_ID, T_1_ID, T_4_NM, T_3_NM, T_2_NM, T_1_NM,...
EVENT -------- TEAM_ID, TEAM_LEVEL, ...
Problems - 1) Dynamic data reduction logic should be applied on EVENT data also. For example, a person having access to 4th level team should be allowed to see all teams and events underneath that 4th level team. 2) Any selection made on TEAM fields should be applied on EVENT fields also.
I am trying to solve this by denormalizing EVENT table and create a view with expanded team fields. If an event is defined for a team at 3rd level, the expanded event view will have all possible records underneath that 3rd team. Later will apply the same dynamic data reduction logic on the view and for runtime, may be write a macro to copy selection made on TEAM fields onto view fields
Would appreciate if someone can suggest any alternatives! We are still using QlikView 8.2
