05-04-2018 08:12 AM
I am not sure but as it turns out neither of these statements work as filters in a VA Report or on a table at the row level;
( 'InstrID'n Contains 'SUB:AS.Userid' )
('SUB:AS.Userid' Contains 'InstrID'n)
In either row level security on a table or as a filter. I would really like to use a filter on a report so that I can use the same table for multiple reports and restrict access to the reports themselves.
Is there any way, at all, (and I have looked and cannot find it) to see what the value is for SUB:AS.Userid or SUB:AS.ExternalIdentity in VA? Our User Ids are eight numeric values saved as text. Something like '12345678'. I have attempted to use GETLENGTH and REMOVEBLANKS with the SUB:AS.Userid before comparing it using a CONTAINS statement as listed above. I have even tried an "=" assignment.
I can't find a way to "see" what the SUB:AS.Userid value is. I have to think there is some change or manipulation that occurred but without validating what I am comparing to I can't be sure. Both fields are eight characters in length. In SAS EG I can see the userid value and it is indeed eight characters long matching what I have in my table.
Thanks for the help.
SAS VA 7.3 (Soon 7.4)
SAS EG 9.4
05-04-2018 10:18 AM
I have had the same problem with "StartsWith".
There looks to be some problem with functions and SUB::-identities.
My solution was to clean the data so that it was the same as in metadata.
I started a track to SAS, but let go when I got it to work :0
05-14-2018 02:55 AM
Sorry if I was a bit unclear.
I mean that the name in your dataset should be exactly the same as the name registered in metadata via Management console.
Make sure that you have the same length without spaces and also that the case is the same.
05-14-2018 08:20 AM
Yes, my table name is the same, the field names are the same, the lengths are the same, and the case is the same.
Madelyn_SAS sent me some code to run on the server in debug mode to show the actual value of SUB:AS.USERID value but our IT group does not see the results she referred to. They are still trying to produce the results she explained.
SAS does some great things but it is these small "basic/fundamental" things that escape me as to why? Exporting a chart to Excel without having to use Flash, see the value of a user id variable, drop results or a value into a text box in a report.
05-07-2018 11:43 AM
If a filter for an individual identity does not work as expected, the most likely causes are case sensitivity and the suffix. Specifically, the SAS.Userid property normalizes the value to all uppercase. For Windows, look for problems with how the domain is specified. For more information, see Windows User ID Formats in the SAS Intelligence Platform: Security Administration Guide.
05-09-2018 04:44 PM - edited 05-09-2018 04:46 PM
Thank you as always Madelyn_SAS!
I have checked all of the possibilities I can and all turn up the same; eight characters in length as well as defined that way. It seems I cannot "see" the value for SUB:AS.UserID or SUB:AS.ExternalID to validate what the report is capturing, If anything.
It seems that I should be able to dump the value into a text box or something but SAS does not have that functionality. We are upgrading to SAS VA 7.4 next week. I hope this will solve this problem.
I have attached a document that better explains what I am doing.