topic Re: Disable detailed data export on regional/geo map in SAS Visual Analytics

Disable detailed data export on regional/geo map

Edoedoedo — Mon, 23 May 2016 15:15:46 GMT

Hi,

we built a report in VA which shows, among other things, a regional/geo map of customers; the underlying table is a huge dataset with all customers information, but on the map we only show their location grouped by region.

However, when a user right-click on such a map in the VA report viewer, the popup menu shows the option "export map" and in the form he can select the checkbox "detailed data" and download the entire dataset with all columns and rows!

This is a security issue since we don't want to let end users to access the dataset.

Is there a way to disable this detailed export?

[VA version is: 7.2]

Thank you

Regards

Re: Disable detailed data export on regional/geo map

Madelyn_SAS — Mon, 23 May 2016 20:37:33 GMT

You cannot turn off the option to export detailed data but you can disable exporting completely by using the SAS Visual Analytics roles.

Re: Disable detailed data export on regional/geo map

Edoedoedo — Tue, 24 May 2016 08:59:50 GMT

Thank you for you answer, however users should be able to use the export feature to export simple data to excel... So there is no way to keep export enabled while preventing the user to download detailed data?

The purpose should be that the user should be able to export only what he sees.

Example scenario: we have a table with REGION | CUSTOMER_ID; we want to show the distribution of customers on a regional map; hence, we create a report with a regional map with REGION and COUNT(CUSTOMER_ID): then, if a user wants to export this data to excel (i.e. to do something else) he should export only this grouped table in excel, and NOT the CUSTOMER_IDs themselves! This does not make sense for us since if we liked to let the user to export the entire data we would provide him with direct access to the table instead of building a report...

A hypothetical solution would be to directly load in VA the grouped table REGION|COUNT, so 1) the regional map would keep working and 2) even if the user would download the detailed data, all he would get is the grouped table REGION|COUNT. However, this "solution" requires to add a middle step of preprocessing to trasform our table REGION | CUSTOMER_ID in REGION | COUNT(CUSTOMER_ID), and this is extremely unconfortable and for all big tables and reports we use.

What would you recommend?

Thanks a lot

Regards

Re: Disable detailed data export on regional/geo map

MikeF — Tue, 18 Jul 2017 19:36:11 GMT

I see this message was written in May of 2016. It's July now 2017. I'm curious if there is a way for to remove the option to select "detailed data" from a chart download. We are showing generic data in charts for external customers but there is highly classfied data driving these charts our external customers cannot see. Is this something SAS developers are still working on?

Re: Disable detailed data export on regional/geo map

JRoman — Thu, 31 Aug 2017 15:50:13 GMT

I'm facing this same issue -- need to disable the ability to download detailed data on a map. Is this functionality available in VA yet?

Re: Disable detailed data export on regional/geo map

SASKiwi — Thu, 31 Aug 2017 23:23:56 GMT

We have just recently upgraded to VA 7.4 and as far as I can see you can't disable exporting for a particular report like a map.

Re: Disable detailed data export on regional/geo map

CameronF — Mon, 23 Oct 2017 05:16:33 GMT

Having just upgraded our organisation is currently dealing with this issue. Would be great if we could get an update from a SAS employee as to whether this is on anyone's radar. No-one's going to use VA for remotely sensitive data if administrators aren't given the ability to disable exporting the detailed data.

One workaround I've found on a report designer level is that you can select an object and uncheck the 'Enable selection in the viewers' box in the properties pane. Note, however, that this will prevent the end user from (a) exporting the formatted data, (b) saving the object as an image, or (c) maximising the view of the object. Far from ideal, but seems like your only option if it's imperative to prevent users from accessing the row-level data.

Re: Disable detailed data export on regional/geo map

Bp7801 — Mon, 20 Aug 2018 10:40:41 GMT

We have been trying to find a way to remove this for some time and have finally come across a fairly obscure workaround: tested in SAS VA 7.4 Modern Viewer.

In the report you wish to remove the "Detailed Data" export function from:

Create a Custom Category on any data item. You're not going to use it so it can be anything.
Apply a filter to the report using the Custom Category. Untick the "Include missing values" on the filter (assuming this will not remove anything from your report - if it does, you may wish to create a different custom category)
Save the report - when you export now, the "detailed data" option will be gone!

Re: Disable detailed data export on regional/geo map

DMenkveld — Mon, 26 Nov 2018 07:06:02 GMT

Hi,

We came across the same issue.

Another solution is as follow (tested in 7.4 Classic Viewer as well).

- For all charts except geomaps: add a rank with the all other option checked. Set the top count on 999 to prevent a All Other bar from displaying.

- For geomaps (since option All other in ranks is not possible): Use a aggregated filter on the object, uncheck the include missing values.

- Aggregated filter will probably also work for the charts.

This should also work for SAS VA 8.3 so when upgrading to the Viya environment this 'feature' will still work.

https://go.documentation.sas.com/?docsetId=vareportdata&docsetTarget=p0zfjjr681y96kn1ma5258d8o4td.htm&docsetVersion=8.3&locale=en

Re: Disable detailed data export on regional/geo map

Wsubki — Mon, 26 Aug 2024 06:36:44 GMT

I have used option hide from the data .. select the 3 dot from the data —>show or hide data items —> drag and drop all the data that you dont want to show —> select ok .. now if the user went to export data and selected details it will only show him the un hidden data

Re: Disable detailed data export on regional/geo map

Madelyn_SAS — Mon, 26 Aug 2024 13:22:26 GMT

In the latest release of SAS Visual Analytics, you can control access to detailed data export with rule. There is no need for a workaround.

Re: Disable detailed data export on regional/geo map

jonathan-michel — Wed, 12 Feb 2025 15:15:37 GMT

Hello!
Is the rule set in VA or is it a capability set in the SMC?
Actually, is this rule in Viya, 9.4 or both?
Thank you

Re: Disable detailed data export on regional/geo map

Madelyn_SAS — Wed, 12 Feb 2025 16:12:06 GMT

The rule is in the Viya releases. See this topic. The name of the rule is

Export detail data from reports.

/reportData_capabilities/exportDetailData

https://go.documentation.sas.com/doc/en/vacdc/v_029/varef/n0gvj6tc7l72t8n1e625v04x4vfb.htm#n1hl8pn62l04jmn1s1n7oq2mvozl

Re: Disable detailed data export on regional/geo map

jonathan-michel — Wed, 12 Feb 2025 16:15:41 GMT

Thank you!
I suppose there is no corresponding capacity in SAS 9.4?

Re: Disable detailed data export on regional/geo map

Madelyn_SAS — Wed, 12 Feb 2025 16:17:48 GMT

There is no built-in feature in 9.4. You would have to try one of the workarounds mentioned in this thread.

Re: Disable detailed data export on regional/geo map

jonathan-michel — Wed, 12 Feb 2025 16:18:19 GMT

Thank you for your quick answer!