Configuring Password Protection for Reports
It is necessary to secure reports based on the sensitivity of the report data. 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 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 Sigma Studio.
Copyright © Intellect Design Arena Limited.
All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.