Shulou(Shulou.com)06/01 Report--

How to control the data permissions of big data report, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

To control report data access is to let different people see different data or only see the data within the scope of permission when they access the same report.

The common practice of report tools is to control the dataset (the data rendered by the report is basically from the dataset). Take the sql dataset as an example, as long as the conditions of the sql are different, the data returned will be different. For example, sql is written as:

Select... From T where ${w}

When w is defined as if (role=='admin', "1cm 1", "status=1"), the role is "administrator" to see all the data, otherwise you can only see the status field with a value of 1.

This is a function of the dynamic macro of the report tool and may allow sql to be stitched together dynamically.

By the same token, if it is another dataset type, it can be controlled by different people to return only the data within the permission according to the corresponding method.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.