Skip to main content

Advanced Settings

  • Updated

Advanced Settings

The Advanced Settings page allows user to

  • manage the list of data source categories
  • update system settings in related groups

Steps to config Advanced Settings

  1. In browser, log in to Izenda as a user with Advanced Settings permission.

  2. Click Settings, then Data Setup then Advanced Settings in the left menu.

  3. Select the Setting Level: either System or a specific tenant.

  4. Click on a tab to view values.

  5. Hover on information icon following the value name to see the brief guide of that value

    ../_images/Advanced_Settings_Performance_Hover_Brief_Guide.png

  6. Update the values.

  7. Click Save button at the top to save the whole settings.

Update Performance Settings

In Advanced Settings page, click on Performance tab in Middle Panel to view the items. The Performance items are list as below:

../_images/Advanced_Settings_Performance.PNG
SectionPurposeDefault Value
Query TimeoutTo limit the duration of all queries in any page.3600
Use No LockTo not use NOLOCK (dirty read) statement when querying data.True
Data Source LimitTo limit the number of data sources in a single report.1000
Field LimitTo limit the number of fields in a report part.1000
Query LimitTo limit the number of values returned from the query in Report Designer, Report Viewer, Dashboard and Export.100000
Pivot Column LimitLimit the number of columns in a pivot report part.100000
Filter LimitLimit the number of items displayed in Filter Value dropdown1000

Note: The Use No Lock setting instructs the database engine to return the current version of data immediately, instead of waiting for all pending transactions to complete. Check the possible consequences here before using this option.

Update Security Settings

In Advanced Settings page, click on Security tab in Middle Panel to view the items. The Security items are listed as below:

../_images/Advanced_Settings_Sercurity.PNG

Update common settings

  • Tick on Show Tenant Field checkbox will show the field(s) which is(are) sepcififed in Tenant Field in report/dashboard. Otherwise, those fields will be hidden.

  • For security in multi-tenant systems, set up Tenant Field then all reports and dashboards will automatically restrict data retrieval to only that of the current tenant. To enable this feature:

    - Input the name of tenant id field into the Tenant Field box
    - The Tenant Field must be enclosed in brackets: [fieldname]
    - Press Enter to add tenant field
    - You can use multiple tenant fields

  • Tick on Render HTML in Printing/Exporting checkbox will allow HTML tags to be rendered when exporting and printing.

  • Tick on Render HTML in Report Viewer checkbox will allow HTML tags to be rendered when viewing reports in browser.

Add Row-Level security rules

  1. In browser, log in to Izenda as a System Admin and go to Settings, then Data Setup, Advanced Settings in the left menu, and Security in the middle panel.

  2. Click Add button in Row-Level Security section

    ../_images/data_security_001.PNG

  3. Choose one or more available data sources and click Next to go to Step 2

    ../_images/data_security_002.PNG

  4. Choose one or more available fields and click Next to go to Step 3

    ../_images/data_security_003.PNG

  5. Type Name and Descitption (optional) for the data security rule set.

  6. Click Add Rule and configure new data security rule.

  7. Select one of the existing User Groups (Everyone, User or Role)

    ../_images/data_security_004.PNG

  8. Select some specific users or roles if you selected the corresponding values in the previous step.

  9. Type any value and press Enter to Values or select one of the preset values like - [All] - all values - [Tenant ID] - the current Tenant ID - [Tenant Name] - the current Tenant Name - [Role Name] - any role name of the current user - [User ID] - the current User ID

  10. Select access mode: Block or Allow

    ../_images/data_security_005.PNG

  11. Add more rules if necessary.

  12. Click Save and then OK on the pop-up info message about the impact of the current changes

    ../_images/data_security_006.PNG

  13. Add more data security rule sets if necessary or edit/clone/delete some of the existing rule sets.

  14. Click Save at the top-right corner to save security settings

    ../_images/data_security_007.PNG


After that, if you create a new report with fields to which blocking rules are applied or open an existing one, and print or export it, then you will see masked data instead of the actual values

../_images/data_security_008.PNG

Update Categories Settings

Add data source categories

A category should be added before showing up for assignment to a data source.

  1. In browser, log in to Izenda as a user with Advanced Settings permission.

  2. Click Settings, then Data Setup then Advanced Settings in the left menu.

  3. Select the Setting Level: either System or a specific tenant.

  4. Click Category in the Middle Panel.

    ../_images/Menu_Advanced_Settings_Category.jpg

  5. Click Add New + button and type the name into the new text box.

    ../_images/Settings_Category_Add_New.jpg

  6. Continue to click Add New + button to enter more categories.

  7. Click Save button at the top to save the whole list.

Note: User will not be able to save the list unless there is no duplication.

Delete data source categories

  1. In the category list, click the delete icon (x) on the right of each category to delete it.

    ../_images/Settings_Category_Delete.jpg

  2. Click OK in the pop-up confirmation.

    ../_images/Category_Deletion_Confirmation.jpg

  3. The category is deleted immediately. The Save and Cancel buttons at the top does not have any effect in this action.

Note: The category will be deleted even if it has been assigned to data sources. After that these data sources will have no category.

Note: To change the name of a category, the Rename data source categories feature should be used instead.

Rename data source categories

Renaming a category will only change the name and keep the assignments to data sources intact.

  1. In the category list, click the text box of any category and change the name.

    ../_images/Settings_Category_Rename.jpg

  2. Continue to change more category names

  3. Click Save button at the top to save the whole list.

Update Others Settings

In Advanced Settings page, click on Others tab in Middle Panel to view the items. The Others items are listed as below:

../_images/Advanced_Settings_Others.PNG
SectionPurposeDefault Value
Sort Colum NameWhen unselected fields in field tab of report designer, join dropdown and input paramters in filters sort alphabecitally. When selected, these fields sort based on position in the databse.0
Trim Time In JoinsTick on this checkbox to trim the time portion form the Date Time field in each join statement in Report Designer - Relationship page. Otherwise, system will use Date Time field in each sort statementTrue
Timezone for Data OffsetTo set default value for the Timezone Data Offset in Settings > User Setup page. And this setting will effect to displayed data value of Datetime/Time fields in the report part. As of v2.9.5 offset will accept partial hours as .25, .5 or .75
For example:
In database the data value is 11:00. If user sets “5” in the textbox of this section then the data value will be shown as 16:00 in the report part.		0
Timezone for Timestamp OffsetTo set default value for the Timezone Data Offset in Settings > User Setup page. And this setting will effect to all Datetime/Time field in system. As of v2.9.5 offset will accept partial hours as .25, .5 or .75
For example:
The created date of report is 11:00. If user sets “5” in the textbox of this section then the created date will be shown as 16:00 in the system.		0
Convert Null to Empty StringTick on this checkbox to convert all null values to blank (empty) in reports or dashboards. Otherwise, null values keep the orginal values.False
Show Schema NameTick on this checkbox to show schema name together with the the data source name in any place. Otherwise, the schema name will be hiddenFalse
Show Introduction TextTo show the Introduction Text in the following section:
- Report Designer > Data Source tab > Content Panel > under Report Name
- Report List > Content Panel > under each report name		False
Send to Disk Path

To define the path to save files for all Scheduled/Subcribed instances with Send to Disk delivery method, input path in the textbox of that section.

Note

  • When the report is saved into this location, system will save report name together data time so that saving the new version of this report will not overwrite this report. The format when saved: <report name>_<mmddyyyy>_<hhmmss>
  • For example:
    If report “ABC” is saved to disk path at 10/22/2016, 23:59:00 then the report will be saved with name = ABC_10222016_235900
Null
Determine common filter for the same field based on

To determine how the filters considered whether different or the same in the dashboard so they will be common filter and shown in dashboard filter section or not. There are three available options:
- Same field of the same data object from the same database schema
- Same field name regardless of database schema or connection string
- Same alias name regardless of database schema or connection string

Note

Stored Procedure stored procedures input parameters are only considered common when they are from the same stored procedure.

Please see Dashboard Filters for more details about common filter in dashboard.

Same field of the same data object from the same database schema
Allow Multiple Sorts on Grid HeaderBy selecting this checkbox, user can sort on multiple columns when clicking on Grid header in Vertical/Horizontal report. Otherwise, user can only sort by one column at a time.True
Show Preview section in Configuration ModeBy selecting this checkbox, both Configuration and Preview sections display in the report part’s backside and setting popups. Otherwise, system only shows Configuration section. This is useful when working with very large datasets as the database is not called until the report part is flipped to the front side.True
Hide report header and footer by defaultBy selecting this checkbox, report header and footer sections are hidden in both Report Viewer and Report Designer - Design. Otherwise, these sections are displayed by default (if any).False

Cancel the changes

To cancel any changes without saving:

  1. Click the Cancel button at the top.
  2. Click OK in the confirmation pop-up.

../_images/Cancel_Confirmation.jpg

Related articles