BookmarkSubscribeRSS Feed
Konu-Tec
Obsidian | Level 7

Hello everyone. Just want to say that brand new SAS VA in Viya is fun.

But going back to my question. Let's asssume that I have:
report R

data source D_i

users U_i

parameter P_i

Now I wonder if user U_1 can get his very own "view" of D_i (meaning D_1) basing on passed values P_i without overwrting D_0?
My understanding of dashboards here is very Classic. By above I mean to have just one data source D assigned to one Report R.

I have already built a HTML form where user U_i can pass values to parameters P_i to get brand new D_i. So in my case data source D of dim nxM has volatile n and fixed M.
The problem I might experience now is that U_1 can overwrite D_0 by his D_1. So after few moment U_0 can see diffrent data than he expected since D_1 is filling up the visualizations now.

I'm open for Python ideas

Thanks in advance for any advices and the time spend over my question.
Happy data crunching

2 REPLIES 2
Patrick
Opal | Level 21

I believe if the loaded table is session scope then there won't be any risk of overwriting - and it could have the same name in different sessions/for different users. Question is if you want to re-load the table for every new session.

Not sure if/how you can define a report that dynamically can use differently named data sources.

Konu-Tec
Obsidian | Level 7
Thank you Patrick for your reply
The first part about session scope tables sounds really interesting. Maybe that would be possible if the data source used by the Report would be stored in CASUSER caslibs? In my current understanding CASUSER caslib works kind of as WORK library of SAS BASE. The concept of session scope tables seems worth checking - thanks. The "challenge" here seems to be a possibility to keep the very same name of the Report (R) along with multiple "session scope" data sources (D_i)

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 681 views
  • 1 like
  • 2 in conversation