This topic applies to the Admin Console > Roles settings.
This topic explains how to use the Roles to control access to data and override the General Settings.
Create, Edit, Delete Roles
- To add a new role click Roles in the Main Menu and either:
- click the Add icon at the top of the main menu
- right-click and select Add from the context menu
- To edit a role either:
- double click it
- select it, expand the sections (Main, General, Folders, Objects or Filters) and click the Edit icon at the top of the main menu
- To delete a role either:
- select it and click the Delete icon at the top of the main menu
- right-click it and select Delete from the context menu
- To save changes and new joins click the Apply or Okay buttons.
The Role that is currently active will be highlighted under the Roles menu of the Admin Console.
Roles are created to specify how a user or group of users interfaces with Exago BI. Roles can restrict access to folders or data objects. Roles can also override the General Settings.
Exago BI is designed as an integrated reporting solution for other applications using the application’s own security and authentication methods. Although you can create Roles through the Admin Console, Roles are typically created through the API to dynamically set a user’s access. For more information see the sections regarding the various APIs.
Roles have five sections to control access: Main, General, Folders, Objects, and Filters.
The Main settings control the broad properties of the Role.
A name for the role.
Check to activate the role.
Include All Folders
If checked, all folders that are not listed in Folder Access will be available. If unchecked, only those listed in Folder Access will be available.
All Folders Read Only
If checked, all folders that are not specified in Folder Access will be execute-only. If unchecked, only those specified in Folder Access will be execute-only.
Allow Folder Management
If True, users will be able to create root and child folders, rename folders and delete folders in the user interface. If False, users cannot take action on folders and the Add Folder buttons are hidden from the user interface.
Include All Data Objects
If checked, all Data Objects that are not listed in Objects section will be available. If unchecked, only those listed in Objects Access will be available.
The General settings of a Role override the some of the global General Settings. Utilize the API in order to overwrite additional settings for a user or group of users.
In Exago BIpre-v2020.1:
Report Path pre-v2020.1
The parent folder for all reports. The Report Path can be:
- Virtual Path
- Absolute Path: Used to provide increased security (ex. C:\Reports)
- Web Service URL or .NET Assembly: Using a Web Service or .NET Assembly allows reports and folders to be managed in a database. For more information see Folder Management. A Web Service should be formatted as ‘url=http://WebServiceUrl.asmx’. A .NET Assembly should be formatted as ‘assembly = AssemblyFullPath.dll;class-Namespace.ClassName’.
The format of date values. Can be any .NET standard (ex. MM/dd/yyyy). If left blank, this setting will inherit the environmental settings.
The format of time values. Can be any .NET standard (ex. h:mm:ss tt). If left blank, this setting will inherit the environmental settings.
Date Time Format
The format of date-time values. May be any .NET standard (ex. M/d/yy h:mm tt). If left blank, this setting will inherit the environmental settings.
For more details on .NET Date, Time and DateTime Format Strings, review the Standard date and time format string document on Microsoft’s website.
Numeric Separator Symbol
Symbol used to separate 3 digit groups (ex. thousandths) in numeric values. The default is ‘,’.
Numeric Currency Symbol
Symbol prepended to numeric values to represent currency. The default is ‘$’.
Numeric Decimal Symbol
Symbol used for numeric decimal values. The default is a period (.).
Server Time Zone Offset
Value that is used to convert server to client time (the negation is used to convert client to server time). If left blank, this setting will use server time to calculate value.
Time Zone Name v2019.1+
Default geopolitical location of the client as determined by the IANA time zone database (for example, America/New_York). Utilized by Exago BI to properly combat scheduling issues centering around DST and other non-linear time zone conflicts.
Sets the default value for the HTML output option Show Grid. This can be modified in the Options Menu of the Report Designer.
Allow Creation/Editing of Advanced Reports
Displays/Hides the Advanced Report Wizard and Report Designer.
If Allow Creation/Editing of Advanced Reports is False then attempts to edit Advanced or CrossTab reports will cause an ‘access denied’ message. Additionally, if False, users will not be able to create CrossTab reports.
When True, users can select to add a new CrossTab Report from the New Report icon in the main menu. When False, CrossTabs may only be added to an Advanced Report, provided that Show CrossTab Wizard is also True.
Show CrossTab Wizard
When True, users can add CrossTabs to their existing Advanced Reports from within the Advanced Report Designer, with the Insert menu.
Allow Creation/Editing of Dashboards
Allow Creation/Editing of Chained Reports
Enables/Disables the Chained Report wizard.
Allow Creation/Editing of ExpressViews
Enables/Disables the ExpressView designer.
Allow Editing ExpressView with Live Data
When True, users are allowed to make changes to an ExpressView when the in Live Data (Run) mode. When False, users must click the Stop button on the toolbar before changes may be made.
The default value isfalse for pre-v2021.1.1 ortrue for v2021.1.1+
Prior to v2021.1.1 we recommend setting this to False. Editing live ExpressViews will cause an increase in Data Source requests, and may reduce performance.
This setting was removed from the Admin Console in v2019.2 but remains available here in the config file. No other functionality was removed.
Show Express Reports pre-v2019.2
Displays/Hides the Express Report Wizard.
Show Styling Toolbar pre-v2019.2
Displays/Hides the styling tools in the Layout tab of the Express Report Wizard.
Show Themes pre-v2019.2
Displays/Hides the Theme drop-down in the Layout tab of the Express Report Wizard.
Show Grouping pre-v2019.2
Displays/Hides the grouping tools in the Layout tab of the Express Report Wizard.
Maximum number of seconds for a single query to run.
This value is passed on to the data source driver when the report is executed. Each data source driver, data source or individual database may interpret this setting slightly differently. Consult the official product documentation associated with the data source implementation for complete details how this setting will impact the environment.
Read Database for Filter Values
Enable/Disables filter drop-downs to contain values from the database. Set to False only if retrieving values for the drop-down will take more than a couple of seconds.
Show Report Scheduling Option
Show Email Report Options
Displays/Hides the email report icon on the Main Menu. Set to False to disable users from emailing reports.
Show Schedule Reports Manager
Scheduler Manager User View Level
Controls what information each user can see in the Schedule Manager. These levels utilize the Parameters companyId and userId. There are three possible values:
- Current User: Can only view and delete report jobs that have been created by that user.
- All Users in Current Company: User can only view and delete report schedules for their company.
- All Users in All Companies: User can view and delete report schedules for all companies (administrator).
Allow Creation of Custom SQL Objects in Advanced Reports v2018.1+
Allow this role to create and execute reports with report-level custom SQL objects.
Carefully review Report-Level SQL Objects before enabling.
Controls what visibility permissions users can assign to Execution Caches. Available levels utilize the parameters companyId and userId. See Scheduler Settings for more information.
The Folder Access controls which report folders are visible and executable for the Role.
For the best user experience, keep the number of items in the Report Tree less than 1000.
All folders available in the Storage Management database will be available for selection here, regardless of the values of the identity keys. Access can only be granted to content that a user would already have access to through the Storage Management system.
If Include All Folders is checked this list will deny access to the folders added. If unchecked, the list will allow access to the folders added. If All Folders Read Only is checked this list will overwrite the setting when a folder is added without the ‘Read Only’ option checked.
To add a folder to the list:
- Click the Add button.
- Click in the Folder Name column and select the folder you want to add.
- To make the folder execute only check the box in the Read Only column.
To delete a folder click the Delete
The Objects Access controls which data objects are accessible to the Role. A report can only be executed if the Role has access to all the data Objects on the report.
If Include All Data Objects is checked this list will deny access to the data objects added. If unchecked the list will allow access to the data objects added.
To add a data object click the Add button.
Click in the Data Object Name column and select the object you want to add.
To delete an object click the Delete icon at the end of the row.
Allow User to View Report-Level Custom SQL Objects v2018.1+
If Allow Creation of Custom SQL Objects in Advanced Reports is False, enable this setting to allow this role to run reports with report-level custom SQL objects. (Otherwise users will receive an “Access Denied” message when running such reports).
Filter Access provides a means to filter a Data Object by Role. Filters can be added to data objects so that users can only view specific rows in the data object. To set row-based tenancy in Exago BI:
- To add a filter click the Add button.
- Select the Data Object Name from the dropdown.
A Data Object may only appear in the list once. Adding the same Data Object multiple times is not allowed and will return an error message, “Please address the following errors before saving: Filters table contains the same object in multiple rows.”
- Enter the Filter String. The filter string should be valid, standard SQL to be added to the ‘WHERE’ clause sent to the Data Source. This filter string can include Exago BI system parameters (for example
@userId@) or custom SQL including subqueries (for example
IN (SELECT EmployeeID FROM Employees WHERE EmployeeID <4)). The Filter String must contain the actual name of objects in the Data Source (for example tables, views, columns, etc…) rather than their Exago BI aliases.
To delete a filter click the Delete icon at the end of the row.
- Admin Support Lab — Roles (video)