–A couple of roles are needed, they actually are divided by plant.Under each plant role(channel) are key figures ( or we can say KPIs) belong to this organization,which will be monitored by management board –For most of the KPIs, they are just different on the organization plant. The business definition and query definition are all the same When I didn’t come to the idea of query view,the first thought was creating several similar querys.Of course this is not a good solution: we need a good naming rule to manage hundreds of querys; we’ll have to save a lot of global structures which ensure the future maintainence of same KPI for different plants.It’s easy to do a calculation: If we have N KPIs, assuming that we have 10 plants, the final number of query will be: 10*N !
However,using query view could greatly reduce the number of querys and make the maintenance much more easier.The total query number will still stay at N, we just need to create more query views and assign to iView on Portal.
*The step by step practice:*
* 1.Create a query with all plants and run it in BEX analyzer*
*2.Adjust the query selection and other change on demand *
( here i just restrict a specific plant for every single query view)