BI data-level permission Solution

BI data analysis is a hot application of enterprises. For enterprises, permission control is very important, especially for enterprise reports for decision-making. Currently, the BI architecture based on the Microsoft SQLServer system is IntegrationServices + AnalysisService + ReportingServices. Both IntegrationServices and Analysis belong to applications.

BI data analysis is a hot application of enterprises. For enterprises, permission control is very important, especially for enterprise reports for decision-making. Currently, the BI architecture based on Microsoft SQL Server is Integration Services + Analysis Service + Reporting Services. Both Integration Services and Analysis belong to applications.

BIDataAnalysis is currently a hot application of enterprises. For enterprises,PermissionControl is very important, especially for enterprise reports used for decision-making. Currently, the BI architecture based on the Microsoft SQL Server System is Integration Services + Analysis Service + Reporting Services. Both Integration Services and Analysis belong to the application background Services and are not displayed on the user's front-end.PermissionThe control system is not in the scope of our article (but the implementationDataLevelPermissionControl, requires the participation of Analysis Services ). For enterprise reports used for front-end display,PermissionThere are two types of control systems: Report-levelPermissionAndDataLevelPermission. Report LevelPermissionRelatively simple, mainly used to control who can view the report;DataLevelPermissionThis is complicated. Anyone can view the same report andDataHe only hasPermissionViewData. Simply put, this is what the general manager seesDataAnd what the manager seesDataThey are reading the same report. Comparison Report LevelPermissionAndDataLevelPermission, You will find that ifDataLevelPermissionIs enterprise reports required?PermissionControl is no longer important (of course, it should be controlled to make the interface friendly ).

This article focuses on SQL Server-based BIDataLevelPermissionOfSolutionSolutionThis is also a feature that I attach great importance to when implementing a BI project for a large German multinational enterprise customer. Here, I will briefly introduce this Customer and project. Out of confidentiality requirements, I call this Customer S (CS for short, haha, not that game ).

The CS project uses Sharepoint at the front end and SQL Server at the backend, mainly analyzing the sale of customer SData. The CS organizational structure is divided into departments and regions. departments and regions are cross-cutting. The headquarters staff of a department can see all regions of the country.DataWhile the regional staff can only seeData. Users can viewDataPermissionTo be configured on the webpage. This is the customer'sDataLevelPermission.

To address these needs,DataLevelPermissionSolutionSolutionThe architecture is as follows:

12 3 4 5 next page