BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rufmau68
Obsidian | Level 7

hi,

i need to set a report parameter in sas va , automatically ...

without a user action in control botton, but automatically

 

how can i do it ? if can i do it

 

why? because i will to know in sas report ,the user organization owner, to use it in any calculated item:

 

if category = _pOrganization  then return missing else return category

 

thanks

mauro

 

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

Ok, now I get it 🙂

 

I have tried to solve similiar tasks, but haven't found a way to get it fully automatically....

 

One thing I tested was to filter a drop-down depending on logged in user (you set this in admin tab directly on the table). I had a parameter assigned to the drop-down and made it mandatory. The problem I got was that the value did not automatically change depending on user, I had to select user manually....

 

I tested with a list but got the same result....

 

I use 7.4.

 

We fínally used the list and the users need to click on it to get the report. The good thing is that they can not see other figures before they click...

 

//Fredrik

View solution in original post

5 REPLIES 5
FredrikE
Rhodochrosite | Level 12

How do you mean automatically? Do you mean dynamically?

 

Will the organization number change depending on the logged in user?

 

What information do you have in your data?

 

How will you use this information? Which business case?

 

//Fredrik

rufmau68
Obsidian | Level 7

YES,

che organization ID its depending on logged user

 

i need to show all data to all user , but with different automatic aggregation level .

 

case study:

 

2 organization: ORG1 and ORG2

 

ORG1 User, have to see data aggregate in this way:

 

ORG2 , No Customer details, Revenue 10000

ORG1, Customer 1, Revenue 1000

ORG1, Customer 2, Revenue 500

...

 

ORG2 User, have to see data aggregate in this way:

ORG2, Customer 3, Revenue 8000

ORG2, Customer 4, Revenue 2000

ORG1, No Customer details, Revenue 1500

 

 

and in my mind a will use  a calculated item defined in this way;

if _pORG = Organization then return CustomerID else return "No Customer details"

 

in this way the "revenue" aggregation or "revenue" details its automaticaly

 

my memory contains details

ORG1, Customer 1, Revenue 1000

ORG1, Customer 2, Revenue 500

ORG2, Customer 3, Revenue 8000

ORG2, Customer 4, Revenue 2000

 

all is good, but tu set _pORG i need that user push a bottom or anything else.... no good!

rufmau68
Obsidian | Level 7
sorry, my SAS VA Version is 7.3
FredrikE
Rhodochrosite | Level 12

Ok, now I get it 🙂

 

I have tried to solve similiar tasks, but haven't found a way to get it fully automatically....

 

One thing I tested was to filter a drop-down depending on logged in user (you set this in admin tab directly on the table). I had a parameter assigned to the drop-down and made it mandatory. The problem I got was that the value did not automatically change depending on user, I had to select user manually....

 

I tested with a list but got the same result....

 

I use 7.4.

 

We fínally used the list and the users need to click on it to get the report. The good thing is that they can not see other figures before they click...

 

//Fredrik

rufmau68
Obsidian | Level 7

Yes FredriK,

the same experience that i met: to set the parameter value, user have to click filter bottom or other control object

 

no good for me

 

i reengine the report to split view in 2 step:

 

a sintetically view for all ORGx

 

and a detail view for user based on a different memory (with row level security settings...)

 

thanks

bye

 

Mauro

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 5 replies
  • 1199 views
  • 1 like
  • 2 in conversation