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
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
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
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!
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.