Prerequisites for Managing Resource Bundle:
When adding display names for a new language, a new entry (record) must be added for that language with the correct language ID (LANG_ID column) in the LANGUAGEMASTER table in the Canvas schema. For the changes to get applied, users must choose their primary language as the preferred language in the functional application, Sigma. A sample entry in the LANGUAGEMASTER table for the Arabic language is shown for reference:

APPLICATION_ID	LANG_ID	LANGUAGE	CREATED_DATE	CREATED_BY	UPDATED_DATE	UPDATED_BY	DIRECTION
SIGMA	ar_SA	ARABIC	2019-12-29	MAKER			RTL

Adding an entry for the new language in the LANGUAGEMASTER table is mandatory, without which that language will not appear in the functional application.

In order to create a complex report as shown, perform the following steps in Sigma Studio:

Click Create > Report.

The Information Report page appears with the Report Maintenance tab open by default.
In the Report Maintenance tab,
1. Enter a unique ID for the report in the Report Id field.
2. Enter a display name for the report in the Report Name field.
3. Click the Data Source Name field and select a data source. Refer Creating Data Connections to create a database or web service connection and data source.
  
  Here, Transaction (M) which is created manually is used as the data source.
  If you select a multilevel data source, Data Grid field appears near the Template Design icon.
4. Click the Data Grid field and select a data source. Here, we have chosen D_TRANSACTION_DS as the data grid in order to display their data in the report.
  
  To define who can access the reports in Sigma application, you need to set the appropriate entitlements. Sigma uses the combination of Product code, Sub Product code, and Function code as the entitlement. To set the entitlement for the report, click the Data Entitlements () icon.
  The Entitlement Configuration page appears.
  
  Click outside the pop-up to save the entitlement configurations.
  By default, the configuration is provided to be as CANVAS. This can be changed by selecting the alternatives in the drop-down list. Refer Configuring Entitlements for more information on creating a new entitlement in Sigma Studio.
5. Click Template Designer ( ) icon to design the template.
  
  The Template Designer feature is only applicable for the PDF format.
  
  The Template Designer page appears with the list of header and footer options on the left-hand side of the page and the list of columns from the selected data source on the right-hand side of the page.
  1. Select the type of the field to be designed.
  2. Select the column layout. By default, a section with single-column (stack) layout is displayed and they can be altered from single-column (stack) to six-columns.
  3. Select the data source required from the given drop-down list.
  4. Drag and drop those columns into the section.
  5. If you want to add additional sections, click Add Sub-Section, drag and drop the required columns into that section.
  6. Click Save icon and go back to the Report Maintenance tab.
6. Click the Select Columns to Display field and select the columns for the report.
  
  When generating reports in the application, end users will be able to select only the columns selected here for the report. Similarly, the following fields behave in the same manner - Select Groupable Columns, Select Sortable Columns, and Select Filterable Columns.
7. If you want to use resource bundles for the entire report or the column headers (column labels) specified in Select Columns to Display field, enter the name of the resource bundle property name in the Resource Bundle field and click the Add Labels ( ) icon.
  
  The Resource Bundle Entries page appears. By default, English language is selected in the Language drop-down list. You can select any other language for your application from the Language drop-down list.
8. Enter the labels (captions) for each of the report headers in their respective fields and click Save.
9. Click the Select Allowed Formats field and select the formats in which the report can be generated. The following formats are supported: CSV, DOCX, HTML, PDF, XLS and XML.
  
  End-users can generate reports in the application in the formats configured in the Select Allowed Formats field. For example, if CSV and HTML are selected for a report, end users can generate reports in the application in CSV and HTML formats only.
10. Click the Select Filterable Columns field and select the column(s) for which the report results are to be filtered.
11. Click the Select Groupable Columns field and select the column(s) by which the report results are to be grouped.
12. Click the Select Sortable Columns field and select the column(s) by which the report results are to be sorted.
Click Save.

A confirmation message appears.
Click Ok for the message.

The new report is made available for the end users in the Information Reports workspace in the end application.

Request approval for the reports can be enabled through Sigma Studio. Refer Administration for more information on initiating, approving, rejecting and re-submission of requests.

Browser not supported