Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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. This feature is only applicable for PDF, Excel and Word export formats.
Perform the following additional steps in Sigma Studio to enable password protection:

  1. 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(MIDDLE_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 middle name (getLast(MIDDLE_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.

  • No labels

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.