Adding a New Report to SAS Solution for IFRS 17 Dashboard

SAS Solution for IFRS 17 provides a comprehensive dashboard covering a variety of reports. The system provides a flexibility of creating custom reports and plug them as a menu item in the dashboard workspace. The objective of the article is to provide an overview of steps to configure a new custom report in the dashboard menu of the SAS Solution for IFRS 17. The article assumes a fair amount of knowledge of SAS solution for IFRS 17 and underlying products.

New to SAS Solution for IFRS 17 or need more information? Click for training –> Course Outline.

or SAS® Solution for IFRS 17

Out of the Box Dashboard The out of the box dashboard workspace provides a variety of reports. Mainly the reports provided cover many areas and are listed as follows:

Data Quality Reports – Provides overall view of data quality for completeness, accuracy, and integrity of data including data violations
Input Data Reports – Provides details of cash flows in the input data.
Grouping Reports – Provides details of the produced insurance contract portfolios and the related groups.
Management Reports – Provides a variety of financial dashboard covering several aspects like balance sheet, statement of comprehensive income, past and currents movements and so on.
Disclosure Reports – Provides a variety of disclosure reports as per the standard requirements like balance sheet, roll forward liabilities, discounting curves, CSM runoff, PCA runoff and so on.
Detailed Postings Reports – Provides an overview of the insurance contract groups, related accounting events as well as the generated journal entries.
Trail Balance Reports – Provides a snapshot of the balance between debits and credits for the current report along with detailed list of journal entries.
Control Framework Dashboard –Provides full details of established business, technical or IT based controls.
Process Analysis Reports – Provides details of ongoing and completed cycles including task status and task completion details.

Apart from the above reports, the SAS solution provides flexibility to build more reports and configure them in the dashboard menu.

Creating and Adding a Custom Report

The user who wishes to create and add the report to the dashboard menu must have:

Skills in SAS Visual Analytics report creation.
Knowledge of SAS Content Server
Basic XML knowledge
Necessary edit access rights and roles for both metadata access for SAS Risk and Governance Framework, SAS Visual Analytics and SAS Content Server.

The image depicts an overview of configuration steps in respective SAS Platforms

These steps are briefly described as follows:

1. Create a new custom report and save.

The new report can be produced using Report Builder present in SAS Visual Analytics. Click here for more information on report creation. For most of the data requirements for custom reports existing SAS Visual Analytics report mart tables are good enough. If the new reports required additional columns, then the appropriate tables can be enriched accordingly for example, IFRS17_SL_JOURNAL_FLAT table can be enriched with new additional columns. For report customization, following activities are supported for the existing or new reports:

Create new calculated measures
Create new OCI (other comprehensive income) and PL (profit and loss) derived measure
Create new income statement level
Create new delta currency based on bs
Create new custom category
Create new hierarchy

Most of the above listed activities involves skills for report creation using SAS Visual Analytics. You can acquire these skills by completing the following training programs:

SAS Visual Analytics 1 for SAS9: Basics, Course Content and Course Outline
SAS Visual Analytics 2 for SAS9: Advanced ,Course Content and Course Outline

Specific examples of the listed activities are present in the solution user guide in Appendix 5: Customizing SAS Visual Analytics Reports. All the visual reports should be kept in a same location for consistency purposes. Usually, the reports are available on a designated metadata location for example, SAS Folders > Products > SAS Solution for IFRS 17 > IFRS17.2022.07 > Visual Analytics Reports

2. Update the dashboard screen definition.

The screen definition provides the instructions to the screen definition to showcase a report with in a menu tab. You need to set the report for initialization and then define a tab for it to display. You can access the screen definition file directly from dashboard screen or from the Administration workspace using the screen definition tab. You have to update the following sections:

a. Update the initialize section

You must update the report in the initialize section of the report. You can replicate the existing syntax for previous reports. For example, we are configuring Report 10 as a placeholder for our new report in the xml. The entry in the initialize section is as following:

Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.

b. Update the tab section

You must update the report in the initialize section of the report. You can replicate the existing syntax for previous reports. For example, we are configuring tab for Report 10 as a placeholder for our new report in the xml. The entry in the initialize section is as following:

3. Update Dashboard.json file.

The JSON file provides the actual location and name to be fetched by the SAS Solution.

a. Access DAVTree (Typical Location: D:\SAS\Config\Lev1\Web\Utilities.

b. Open the JSON file.(Typical location: Sasdav > products > SASRiskGovernanceFramework > RiskGovfFrwrkMid-Tier > rmc > frs17 > Resources > screen_config)

c. Append the file with the following lines just before the ] (square bracket) in the end of the file. Or you can copy the lines from the existing entries (for example, you can use entries for other existing report like Report 😎 and make changes for id and reportName:

,

{

"id": "Report10",

"reportPath": "'/Products/SAS Solution for IFRS 17/ifrs17.2021.10/Visual Analytics Reports'",

"reportName": "'IFRS17 - My Report'",

}

d. Save the file.

4. Update customMessage.properties

Within the DAVTree, in the frs17 folder, expand the Config
Right-click properties and select Edit.
Scroll to the middle of the file and locate the Dashboard Page section, which has message keys corresponding values for report names.
Add the following line to the list of Dashboard Page message keys: tab.Report10.displayName.txt = My Report
Save the file.

5. Flush caches and verify the new menu and report.

Using SAS Solution for IFRS 17, click the Administration workspace and click the Site Maintenance.
Click Flush Caches.
Click the Dashboard workspace . Verify that the new tab My Report is added to the dashboard.

Further Reading

For more details and demonstration on all the above steps refer to the following training program: Technical Overview of the SAS Solution for IFRS 17 Course Outline

or

SAS® Solution for IFRS 17SAS Training