The dimensions in my model are emp, process. In emp dimension the heirarchy is emp-centre. my fact contains output, effort. productivity rate = output/effort.
benchmark for a process in a centre is, productivity rate of that centre which is, (sum of the output of all the employees in that centre )/(sum of effort of all the employees in that centre). i have taken bench mark as (emp-centre.parent, measures.productivity rate). this works fine
so benchmark for any employee should be same in a centre for a particular process. but when i am displaying a single employee, the benchmark is dynamically changing. benchmark should be static for all the employees for a particular process.
How should I achieve that
Thanks in advance
benchmark for a process in a centre is, productivity rate of that centre which is, (sum of the output of all the employees in that centre )/(sum of effort of all the employees in that centre). i have taken bench mark as (emp-centre.parent, measures.productivity rate). this works fine
so benchmark for any employee should be same in a centre for a particular process. but when i am displaying a single employee, the benchmark is dynamically changing. benchmark should be static for all the employees for a particular process.
How should I achieve that
Thanks in advance