SSRS 2016 - KPI with profile dependencies
I try since several days to set a KPI for each user.
In fact, the user must have his number of remaining holidays. To do this, the dataset is filtering with the USERID.
But, it's not possible to refresh the KPI if the dataset contains a profile dependencies.
In my case, it is not a report but a KPI. A KPI is present at the connection of the user. The user does not need, as a report, click to launch an execution. So I can not use the user profile to display a KPI.
One topic is open in the microsoft forum : https://social.technet.microsoft.com/Forums/fr-FR/79c353e6-5f91-4608-8ee7-1da7a4bc60e6/ssrs-2016-kpi-with-profile-dependencies?forum=sqlreportingservices
Upvotes: 14<=-=Sep 8 2016 5:20PM=-=>
Thanks for your feedback – it is currently not possible to personalize KPI’s in Reporting Services, and this is implementation is by design currently. However, it is something we will consider for a future release based on customer feedback. I will mark this item as closed as by design, but we have this already on the list of features we’ll be considering to add in a future release.
The SQL BI Team<=-=Feb 25 2017 7:34AM=-=>
I’ve tried this as well – I just send the USERID to a Stored Procedure – and couldn’t get it to work – patched and tried everything… I hope it will come soon – its obvious that this is something you want?
Not that it is smart – but you can create a dataset per user and then a do a KPI for each user then let them choose the one they need as a favourite – if you have more than 20 users that might be a stupid idea – but then again you have to do a refresh cache policy for each parameter usage..<=-=May 10 2017 9:47PM=-=>
The organisation I work for would find this feature extremely useful
We've rolled out SSRS 16 for a 115 stores. We want them to be able to see the KPI's for their own store. From the way I read above it's designed that you kpi's that apply row level security doesn't work or that kpi's aren't specific for a profile?
How do you see KPI's being useful for an enterprise then?
Does microsoft plan a work around?