It is necessary to secure reports based on the sensitivity of the report data. eMACH.ai-Sigma enables you to protect your data by configuring the password protection for reports in Studio. Here, you can set up your convenient way of encryption in order to ensure security.

Applicable formats

The password feature is applicable for PDF, XLS, and DOCX formats only. XLS reports when password protected must be opened in Microsoft Excel only.

Perform the following steps in eMACH.ai-Sigma Studio to enable password protection for reports:

In Report Parameters tab, select Yes from the Is Password Protected? drop-down list.

A Password Pattern field appears.

2. Now, enter the function and attributes patterns in the Password Pattern field.

3. Enter '#' to view the list of functional patterns available for the password and select any from the list.

s:getFirst can be used to read the starting characters from the selected attribute.
s:getLast can be used to read the end characters from the selected attribute.
d:day can be used to read days.
d:month can be used to read the months in numbers. For example, 11 for the month November.
d:monthabbr can be used to read the months in abbreviations. For example, Nov for the month November.
d:monthfull can be used to read the months in words. For example, November for the month November.
d:year can be used to read years.
d:year2 can be used to read the last two digits of the year. For example, 21 for the year 2021.

4. Enter '@' to view the list of password attributes available for the functions. Select any one from the attribute list.

The following password attributes are available here:

FIRST_NAME
MIDDLE_NAME
LAST_NAME
DATE_OF_BIRTH
LOGIN_ID

For example, if you provide d:day(DATE_OF_BIRTH) as the password pattern, the expression informs the system to read the day from the user's date of birth and form it as a password.

Here, s:getFirst(LOGIN_ID,4)+getLast(FIRST_NAME, 3) is provided as the password pattern. The expression informs the system to read the first four characters from the Login ID (s:getFirst(LOGIN_ID, 4)), last three characters from the first name (getLast(FIRST_NAME, 3)) and concatenate them to form a password.

5. Perform the other configurations and save the report.

Refer Configuring a Simple Report for more information on configuring a simple report in eMACH.ai-Sigma Studio.

Browser not supported