SSRS to Qlikview

[#1]

Hi All,

We use SSIS 2012, SSRS 2012 and SQL Server 2012.

Below is how our project is set up.

Our users access our dashboard thorugh a portal which is built on .Net framework. The role and hiearchy are stored in tables. Any user addition or modification is done through the portal by Admin. So basically, our user database and the respective access level are set up through .Net interface. E.g Say when a store manager logs in, he would be redirected to the Store Dashboard and when a district manager logs in, he would be redirected to the District Dashboard which will list all the stores in the district and he would be able to view the store dashboard by drillthrough.

Since we have the security layer set up and access in .Net, I need your guidance on whether we can use the same functionality in qlikview.

[Gysbert_Wassenaar]

It should possible to use your database with users and access levels for the section access tables of your qlikview documents. See this document for an introduction to section access: Introduction to Section Access

Here are some more resources:

• A Primer on Section Access
• Data Reduction – Yes, but How?
• Data Reduction Using Multiple Fields
• Sheets Security with Section Access
• Sheets Security with Section Access File
• Basics for complex authorization
• Authorization using a Hierarchy
• Section Access - Hide Sheet Level
• Video - Section Access best practice
• Chart Level Access by user
• Sheet level access
• Section Access: Desktop vs Server
• Section Access: Strict Exclusion
• QlikView Section Access Examples

[qlikviewwizard]

g‌ood collection

[#4]

Hi,

Thank you for the suggestion.

We do have the authorized list of users in our database. Our user login with the LDAP credentials and if the user is authorized (i.e, he is in our user database), then he is given access.  Is this possible using Qlikview?