I have a dashboard in which i implemented some KPI's.
Some of those KPI's are actually not depending on a user but doing a calculation for the existing Data.I succeed this by using set analysis.
the basic idea of those KPI's is to give a user the possibility to compare his performance against other user's performance.
Till now everything works fine for me.However when i implemented section access based on the user,the data get reduced and then those KPI's data,which are not depending on a user but to the whole user ,get also reduced and my set analysis expression is not working anymore.
I was wondering if you guys faced the same issue before and if there is a way to get around this.