self service reporting
1 Topic
Preventing hostile self service reporting on privacy sensitive data
The root problem I have is to provide self service reporting on privacy sensitive data and prevent hostile attempts to breech privacy by filtering. The data set has low amounts of data which would make report complately useless if distributions does not show small amounts. My aim is to show small amounts only as part of distribution which is big enough and as reporting is self service, the problem need to be addressed at measure, not at the report. Basically what I need is to hide all data that would have row total or column total at visual less than limit constant in case data is not hidden. And that recardless of axis and filter chosen at report. I would start the idea from something like: my_protected_measure = VAR unprotected_measure = ... VAR column_total = CALCULATE( unprotected_measure, REMOVEFILTERS(current visual row dimension) ) VAR row_total = CALCULATE( unprotected_measure, REMOVEFILTERS(current visual column dimension) ) RETURN IF(AND(row_total >= 5, column_total >= 5), unprotected_measure, BLANK()) How can I refer to current visual row and column dimensions at the measure? If that is not possible, is there some out-of-the-box solution for handling privacy data at self service reporting?Solved466Views0likes1Comment