Forum Discussion
Advocate IISame Dataset multiple reports (or same report different filters)
After building the model how can I use same model = same report from the same dataset for different business users limiting what they can see?
E.g. sales example. Data from same ERP updated daily - how different store managers could have a look on the report/dashboard, but with filters (for that region) that could not be changed?
Europe - could see only Europe Sales, but everything else work same way
Asia - only Asia sales
I guess there is no such solution so far - but maybe any plans or workarounds?
9 Replies
- Greg_Deckler
Community Champion
So, you could definitely do this for dashboards, not sure about reports yet. So, load up your data model and create 2 dashboards. Focus on one dashboard then switch to your report, filter the report/page by the country and pin it to the dashboard. Switch to the other dashboard, switch back to report, update filter and pin to this 2nd dashboard. Now, share the 2 dashboards with the appropriate people.
btodresAdvocate I
actually, I beleive that in the scenario suggested by smoupre that the filters would still be available to the reader to select different data therefore the data would not be locked down as required.
- Greg_Deckler
On the report side, yes, but dashboard visualizations do not provide that interface.
AlexNYExcelGreg_Deckler thanks for suggestions, this could partly work, but btodres has good points about links to reports (remove them is doable) and "In Focus Mode" - any ideas how to delete it?
But main interest of course in reports because static dashboards not good enough in long term
- Greg_Decklershare it as read only. then you should not get the interface for in focus mode
- Greg_Deckler
Your only other real option is to hook it up to an SSAS cube and use the Analysis Services Connector, which can enforce per user (row level) security.
