Profiling data and global access to associative schema

[#1]

Hi,

I need to profile data by user (for which I could use Section Access) but at the same time I need to show user information that are retrieved by formula that need to works on the overall data.

For example I need to show to a user his revenue against the country revenue.

If I use Section Access I can't evaluate country revenue.
Use Data Island could be difficult because I have a lot of KPI's that are going to work in this way.

What do you suggest?

Thanks a lot

[Gysbert_Wassenaar]

I don't understand why you think you need Section Access for data profiling. Section Access is used for access to the document and access to data in a document. Data profiling as I know it (Data profiling - Wikipedia, the free encyclopedia‌‌) has little to do with organizing access to date.

[Colin-Albert]

You may need to load the data twice.

One set that details the user, and would be restricted by Section Access, and a second set of data that does not identify the user, but is summarised by country.

This would allow all users to analyse by country without the ability to get to a user level of granularity.