on 06-24-2016 7:41 AM
Good Day
I have a request to build a dashboard for HR that will show performance appraisals (KPIs) for departments, managers and employees. Requirements are that when a user selects the department they should be able to view managers KPIs then when they select managers they should be able to view their reporting lines KPI.
I was thinking of doing individual dashboards for each then put them on top of each other and use dynamic visibility to trigger which chart should be displayed. I have been doing research on the possibility of this and found that performance might be affected as there are about 18 departments, with about 30 managers each. I am now stuck, please advise a newbie on how i can do this report or if there is a way to overcome this performance issue, and by the way I am using Bex queries but will later move to universes.
I have created a similar dashboard based on your requirement. Its very simple as its create a 3 query's.
1. Department with "Year" as Prompt
2. Managers with "Year & Department" as Prompt
3. Employees with "Year, Department & Managers" as Prompt.
Now call all these query's to the dashboard and pass the selection values from each and every chart to the below chart.
Ex: column chart for department, by selecting any values from the department pass the values to the managers so that it changes dynamically, by selecting managers it should bring employees underneth it.
Hope this helps!!!
For your Reference I am attaching the screenshots of the dashboard what i have designed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.