This is an old revision of the document!
Users in Versago identify specific persons that can access the Versago environment and use its various functions.
The Users page provides a list of existing users in the system
Use the standard icons to the search, filter and show/hide columns.
Your Versago license limits the number of active users. If you exceed the number of licensed users, an error message is displayed. Contact Third Wave if you need to upgrade your Versago license.
Roles define user access to Configured Content. Every user and object must be associated with at least one role.
The Roles page provides a list of existing roles in the system
User Account Filters are used to filter Data Views that contain a field that matches the account filter. It allows to control row-level data access for each user.
For example, assume you have a Data View that lists customer invoices. You want to allow your customers to log into Versago and only see a list of their invoices. By using a Account Data Filter in the Data that filters on the customer code associated with the user you can automatically limit the invoices in the list to those that have reference the user’s customer code.
The User Account Filters page provides a list of existing account filters in the system
Versago User Account Filters are used to automatically filter data view results based on specific values associated with a user. A typical example of how a profile could be used is for reports used by salespersons. The reports should only show the information associated with the salesperson running the report. Another example might be a report that shows information to customers. Again, the reports should only show the information for the customer running the report.
To illustrate how a profile works we will use the salesperson example. We will be using the SAP Business One data structures.
In SAP Business One, a salesperson is assigned an internal numeric code. The database name of this value is “SlpCode.” When a sales document (order, invoice, etc.) is created, the numeric code of the salesperson is included in the document record. SAP Business One’s design is such that the salesperson code in the sales documents is also named “SlpCode.”
There are three things that need to happen in Versago for the process to work.
First, a Versago profile is created. The profile uses the SAP Business One salesperson table (OSLP) as the source of valid values.
The “Profile Field Identifier” value is the field (column) name that the profile filtering process expects to see in the report data.
Once a profile has been defined, we must tell Versago what values are valid for a given user. This is done in the user setup as described elsewhere in this document.
In some cases, a user may need to see information for more than value. This would be the case where a sales manager needs to see not only their information, but also the information for salespersons that report to them. In these cases you simply assign multiple profile values as shown above.
Since the filtering process takes place when a report is executed, we need to also define what profile(s) to use in the report. This is done in the report maintenance process.
As shown in this example, you simple indicate the “Filter Type” as Profile and select the desired profile as the “Filter Name.”
Using our example, if the user described above runs a report using the “SlpCode” profile, they will only see records where the “SlpCode” value equals 3 or 5.
Note: Both profiles and parameters can be used in a report
In the examples above, the value “SlpCode” has been present in the data being reported (the sales document). So, the profile filtering works with no issues. However, there may be situations where the name of the filtering column does not match This value in the source table. This situation can be addressed using multiple values in the profile setup.
In this example, we have some documents where the column to be filtered is named “SlpCode” and others where the column to be filtered is named “SlpCodeX.” As shown in the image below, we have created two profile entries.
One shows that the filtering column name might be “SlpCode” and the second shows that the filtering column name might be “SlpCodeX.” Now, we can use the same profile and the filtering will occur if a column name “SlpCode” or “SlpCodeX” is found.
When Versago Forms are being used, you may want to restrict a report that shows the records created via a form to the user that is running the report. You will need to do three things for this to work.
Third Wave suggests that when you create a Versago form you include three values: CreatedBy, CreatedById, and CreateDate. The column names are not significant; they are just suggestions. “CreatedBy” is the user name (Email). “CreatedById” is the numeric ID assigned to each Versago User. “CreateDate” is the date (or date time) the record is created. See the document “Versago Forms – Default Values” for information on how to capture these values automatically.
Here is a sample of how a profile for this purpose would be set up.
In this case the column name being used for filtering is “CreatedBy.”
Use this profile in a report of records created via a Versago form. The records will automatically be filtered based on the user running the report.