Best way to integrate a report-package in an angular website, with differrent data per user

[Pim2]

Hi there,

After a previous question I managed to integrate a report-package-export in my Angular website.

Next chalange is that I need different data per end user for this report. It is not an option to filter in javascript, because the data is sensitive and should not be shared between users.

What option is the best way to approach this?

kind regards.

[FalkoSchulz]

I don't think that is possible. Exporting a report package always happens at run-time given a certain user session. It's that session which determines what data is included in the resulting package. If you have row-level security configured for example - the package will only contain data accessible by this user. As per SDK FAQ's - it's "..it is the responsibility of the hosting web server to provide adequate authentication to the contents".

Instead of generating offline packages, you may also consider leaving the security aspect to SAS Viya and connect from your Angular website directly to a live SAS Viya system. You can use API methods such as  like connectToServer and objects like SASReportElement in your web page directly. This method also gives you full flexibility which visual element you want to include in your web page.

Hope this helps. Falko