Friday - last edited Friday
I have a drop dwon list that I have set to required that is also assigned a parameter. The data soruce feeding the drop down has row level security. When a user logs in the drop down is set to missing and the paramter is still storing the value last saved on in the report designer. How do I get the drop down and parameter to popluate correctly?
It sounds like you have two issues. 1. The row level permissions is not working for the user since no values are returned. 2. The prompt is retaining the last value used if no values are returned.
I think you need to focus on item 1 first. You need to see what row level permission is being applied to the table. If you have access to SASAdmin then this is easy to do and does not require a restart of the web app server. Here are the steps
Once the logging is set, run the report. Then navigate to the location of the Designer log. That is typically located in a folder similar to -configuration-directory/Lev1/Web/Logs/SASServer12_1.
Here is an example of what my log looks like when I login with my sasdemo account. Notice the part in bold below. The most common issue with identity based row level permissions is that the server is appended to the end of the id. If that is not the form of your id data item on the source table then you won't get any results.
DESIGNER ] DEBUG [tomcat-http--41] 2017-03-10 16:02:11,418 [ST-24703-DYdaVmmpcHUUMKP1TGvL-cas:sasdemo] com.sas.services.information.OMIServer
- checking authorization for to Read on OMSOBJhysicalTable/A5XB46DX.BN0001LX
[DESIGNER ] DEBUG [tomcat-http--41] 2017-03-10 16:02:11,419 [ST-24703-DYdaVmmpcHUUMKP1TGvL-cas:sasdemo] com.sas.services.information.OMIServer
- Authorization check result is id CONTAINS 'SASDEMO@SASBI'/*VA<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ex opId="contains"><ex v="id"
t="1"/><ex v="SASDEMO@SASBI" t="3"/></ex>*/ true
[DESIGNER ] DEBUG [tomcat-http--41] 2017-03-10 16:02:11,419 [ST-24703-DYdaVmmpcHUUMKP1TGvL-cas:sasdemo] com.sas.lasr.services.logging.Performance
- Performance: Retrieve permission conditions: 1 ms
The drop down list is popluating correctly based on row level security but it is not selecting from the avaliable rows into the drop down or paramter correctly.
So in this example, the Row level permissions is working correctly and the results for the data item used for the drop down list should have values. If that is the case, please do the following:
1. Create a new report.
2. Add the RLS table.
3. Add a list table and a drop down list.
4. Drag the data item over to both the list table object and the drop down list.
Do both of the objects populate?