Reports Overview[edit]


= Reports Overview =

ICI provides a number of&nbsp;out-of-the-box reports that have been strategically articulated to cater specific business needs. They provide an insight to different entities, states and progress of your Agreements, Clauses and Templates so that you can take necessary actions. They enable you make informed decisions by analyzing processes, cycle times, deviations, risks (expiry, renewal, actions pending, and so on.) and SLA’s at each level of an Agreement. Using the right filters to generate vital Reports provides clarity, allows you to correlate functionalities, and improve response time. Such information is valuable to the organization and has a positive impact on your business. It helps you identify future direction, improve performance, mitigate risk and increase revenue.

In ICI, Reports have been grouped based on their usage into Admin, Legal and&nbsp;Compliance, and Workflow for ease-of-use. You can view only those Reports that you are authorized to. You can either view all Reports together or you have the option to filter the reports based on the grouping, using the drop-down or the tabs. You can access individual Reports by clicking&nbsp;them and providing filters for each of them based on your specific requirement.&nbsp;

Reports are now enhanced to be displayed as per the language selected in the Locale Settings in the User Preferences. These reports are driven on the basis of user profile Language settings.

You also have the option to export the Reports to Excel, CSV or PDF formats.&nbsp;

ICI offers the functionality to classify Business Type/ Contracting agreement type at contract type level. With this release, core reports will be limited to Contracting business application type. Users with access to standard and insights reports will only be able to see data related to agreements with Contracting business application type. Thus, the reporting data would not contain any sourcing agreements.<br/> &nbsp;

== Types of Reports ==

In this section, let us understand ICI Reports in detail.

Reports are mainly divided into 2 groups:

1. '''Default Reports:&nbsp;'''ICI provides a number of&nbsp;out-of-the-box&nbsp;Reports that have been strategically designed to cater to specific business needs. Although these Reports are default, the user will only be able to view the Reports that they are authorized to. Based on their usage, these Reports are displayed on the Agreement Details page or the Report tile.
<div class="note-box">'''Note''':&nbsp;Even if the users are authorized to view/access a specific report, the privileges of the Reports further follow the authorization that the user has in ICI. If the user does not have the privileges to view a particular set of Agreements in ICI, for example, they would not see those in the Report even though they have the view privileges for Reports.</div> 
2. '''Custom Reports: '''Customized Reports may be deployed in ICI based on the requirements of the customer by editing default reports or by creating entirely new custom reports or by deploying reports provided by the customer. These reports are customized for a customer based on their requirement.
<div class="image-green-border">[[File:Custom reports.png|720px|Custom reports.png]]</div> 
&nbsp;
<div class="image-green-border">&nbsp;</div> <div class="image-green-border">3.&nbsp;'''Dynamic Reports: '''These&nbsp;reports&nbsp;can be generated by the user&nbsp;through a configurable option (that can be turned On/Off) of providing the Advanced Analytics tile on the Dashboard as an additional entity with access controlled through Security Groups. This Power Business Intelligence (BI) integration with ICI&nbsp;allows the user to generate dynamic reports on the fly, save the reports and access them quickly using the Advanced Analytics tile, control access to generated reports through Security group, and query the database in the form of normal questions and get results. To know more, click on the related topic below.<br/> &nbsp;</div> 
Here is the list and a brief description of Reports in ICI.&nbsp;

*'''Detailed Report: '''This Report is Agreement specific and provides details of all the Associations of an Agreement entity-wise. It provides detailed view of all related entities to the Agreement such as, Commitments, Rules,&nbsp;History, and so on. It provides a complete view of the Agreement without the user having to navigate to multiple tabs for the same information. It is extremely convenient when the Agreement along with associations are required to be sent for offline reviews and audits. It helps to assess the accuracy of Associations. This helps in performing compliance checks to correct the outliers (where associations are not made). 
*'''Attributes Value Report:&nbsp;'''Captures the values of the attributes and all the edits made to this over the lifecycle of the Contract till date. This Report actually replaces the earlier Export Attribute values on the Agreement entity. 
*'''Clause Deviations Report:''' This Report is Agreement specific&nbsp;and provides a text comparison of the standard and the deviated Clause and highlights the difference between them for the specific Agreement from which it was accessed.&nbsp;It provides visibility into the Clauses that are deviated, by whom, the date and time, in what state, the approver and the approval date and time. It helps a legal person detect Clauses that get deviated frequently and make appropriate changes in the library to further reduce cycle times during contract negotiations.&nbsp; 
*'''Expiring Agreements:''' Displays a list of executed Agreements that will expire in next 30,60 or 90 days.&nbsp; 
*'''Agreement Deviation:''' Provides details related to Agreements that have registered deviations from the standard Clause language definitions in the library. 
*'''Agreement Clause Content Report:''' Provides the Clause content (Clauses used in the Agreement Templates) for selecting&nbsp;a single or multiple Contract Type. 
*'''Attribute Information Report:'''&nbsp;This is an existing Report that provides details of the attribute properties or metadata across its usage in different Contract Types. There are filters that help streamline the attribute information for the user – “Group by” the report data by “Attribute” name or “Contract Type”. 
*'''Expired Agreements Report:''' This is a new Report that displays all the contracts that expired in the last 30, 60 or 90 days.It helps you to make informed decisions on the renewals or terminations of contracts. The mapping of these Agreements with expiring Agreements helps make important revenue decisions.&nbsp; 
*'''Average Agreement Turn Around Time:'''&nbsp;Provides information on the average number of days required for executing an Agreement or Amendment, from the date of its creation till the date of its execution. 
*'''Clause Profiling Report:'''&nbsp;Helps in the mapping of Clauses to the corresponding Templates, with respect to the selected Contract Types.&nbsp;It helps application administrators&nbsp;to view the impact of a particular Clause on all the Templates that have the Clause added in the system. It displays the Clause, its corresponding version, and the Template details in which that Clause has been incorporated. The base entity for the Report is Clause. Even if the Clause does not have an associated Template, it would appear in the Report.&nbsp;&nbsp; 
*'''Clause Summary Report''': The Clause Summary Report helps clause administrators to understand the impact any changes made to a clause would have. This would enable them to assess how any clause has been used across different agreements, amendments, associations and templates. Further, these users would be able to identify which version of a clause was used in a particular entity. 
*'''Template Clause Report:''' Helps in the mapping Templates to the corresponding Clauses, with respect to the&nbsp;Contract Types. It helps application administrators&nbsp;to view the impact when a particular Clause or Template is changed in the system. It displays the Template, its corresponding version and the Clauses present in the respective Template. The base entity for this Report is the Template.&nbsp; 
*'''Cycle Time Report:''' Shows the cycles for an Agreement and the change of states from the date of creation to the date of execution as well as the elapsed time. The purpose of this Report is to enable&nbsp;the user to detect the deficiencies in the processes and turnaround time for tasks. It helps in identifying the patterns that lead to longer cycle times and take corrective actions in the process and streamline it better.&nbsp; 
*'''User Profiling Report''':&nbsp;Helps you to find details associated to an individual user such as the role, groups and the associated entities.&nbsp;This enables&nbsp;the user to interpret the impact of the user on the system, impact of de-provisioning a user and so on. This Report helps analyze the critical actions pending for a user that may have a big impact. It also provides a direct link to the records and configuration modification that can help in curbing the impact. This Report can also a prerequisite to the Replace User functionality.&nbsp; 
*'''User Login Report:'''&nbsp;Provides information of all user logins for a selected date range. It provides an insight on the adoption of the tool by providing details for the user as well as which function, unit and region is using the tool. 
*'''Signature Type Report:'''&nbsp;Provides information on the percentage of Contracts that have been executed manually compared to&nbsp;electronically. Since this involves&nbsp;the entire ecosystem and is a time-consuming process, this Report&nbsp; provides visibility into the number of contracts that are signed manually against those signed electronically to facilitate compliance and adoption. 
*'''Clauses Pending Approval:'''&nbsp;Provides information on the number of Clauses that are pending approval for an Agreement or Amendment along with the duration and the version. 
*'''Agreements Pending Execution:'''&nbsp;Yields data on the number of Agreements or Amendments that await “Internal Signature”, “External Signature”, and/or “Waiting for Signature”, along with the duration and status changed date. 
*'''Templates Pending Approval:''' Provides details&nbsp;related to Templates pending approvals, along with the duration and version. 
*'''Agreements Pending Approval:'''&nbsp;Yields information on the number of Agreements or Amendments that are in the Waiting for Approval state. 
*'''Approved Requests Waiting For Contract Creation''': Provides a consolidated list of Requests for which the contract initiation has not begun.This Report enables the user the user to view all the actions that need to be taken and reduce chances of missing pending Requests to create Contracts.&nbsp;However, if the correct filters are applied for the Contract Type, date of request creation, approvals and request submission, this Report provides a consolidated list of Requests that are pending action. Without this Report, the user would need to apply the right filters in the Search field to get the desired outcome. 
*'''CLM Activity Report:'''&nbsp;Provides&nbsp;a quick view for the CTOs, CFOs, etc. on the current high level status of the Agreements, Contract Requests and user activity to gauge the adoption of the ICI platform in their organization and take corrective action to increase adoption of the platform. The report can be filtered on the Frequency either Day Wise (default), Week Wise and Month Wise. &nbsp; 
*'''Masterdata Information Report:&nbsp;'''Displays a summary of Masterdata and helps the user easily identify all the areas that will be affected or need to be modified by any change to the Masterdata Attribute values. The user can update and extract this detailed report on Masterdata and subsequently any reference of it in Rules, Contract Types, Contract Request, Masterdata, Agreements/ Amendments, Associations and User Groups where the given Masterdata Attribute value to make informed decisions. To access this report, users must have Configuration and Security group access.&nbsp; 

ICI provides the ability to define sub-roles for the Approver role. With this, all the capabilities of the Approver are were enabled for users at the sub-role level. This capability has now been extended to reports so that users can have relevant information and make informed decisions.&nbsp;<br/> With this release, the Detailed Report, User Profiling Report and Agreements Pending Approval Report have now been modified to display the Approver sub-roles such as Contract Admin, Legal Approver and others.

&nbsp;

== [[Types_of_Reports|Categories of Reports]] ==

Reports that are available on different tabs of the Reports tile are further categorized into the following groups:&nbsp;

*Legal and Compliance 
*Admin 
*Workflow 
*Obligation Management 
*Sourcing 

Reports that are Agreement specific are available on the Agreement Details page.&nbsp;
<div class="note-box">'''Note:''' Although these reports are default, you can only&nbsp;view the reports that you&nbsp;are authorized to.&nbsp;</div> 
&nbsp;

&nbsp;

== Localization of Reports ==

To change the localization settings of a report:

1.&nbsp;'''Select''' Preferences to view your preferences. The My Preferences window opens.

2.&nbsp;'''Click '''Locale Settings to view the options.

3.&nbsp;'''Select '''Language to choose a language that you would like to view the report in.

4.&nbsp;'''Select '''the Time Zone, Date Format and Time Format options for the drop-down list for the selected language.

5.&nbsp;'''Click '''Save to save your options.
<div class="image-green-border">[[File:Localization 1.png|720px|Localization 1.png]]</div> 
6.&nbsp;'''Click '''the Reports tab.

7.&nbsp;'''Select '''the report that you want to view.

8.&nbsp;'''Click '''the chart to view the details of the selected report.
<div class="image-green-border">[[File:Localization 2.png|720px|Localization 2.png]]&nbsp;&nbsp;</div> 
&nbsp;The report columns will be displayed based on the selected filters.
<div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Wiki reports localization 4.png|720px|Wiki reports localization 4.png]]&nbsp;</div> <div>&nbsp;</div> 
== Improving localization on reports ==
<div>&nbsp;</div> <div>The ICI platform is widely used to manage contracts across the globe. Hence, adapting existing products to new markets through translation and localization management is key for global business growth. In this view, localization support is now being enhanced in reports.</div> <div>&nbsp;</div> <div>Localization has now been enabled for the following attributes:</div> 
*Type of Paper (Own/ Third Party) 
*Signature Type (Electronic Signature, Manual Signature and Hybrid Signature) 
*Signature Sequence (External First, Internal First and Mixed Signature) 
*Choice/ multi-choice attributes&nbsp; 
*Status/ Business Status (for example, Agreement status, Amendment status, and so on) 
<div>&nbsp;</div> <div>This is applicable to the following Core reports – Agreement Clause Content Report, Agreement Deviation Report, Agreement Pending Execution Report, Attribute Information Report, Average Agreement Turnaround Time Report, Clause Profiling Report, Clauses Pending Approval Report, CLM Activity Report, Expired Agreements Report, Expiring Agreements Report, Masterdata Information Report, Signature Type Report, Template Clause Report, User Login Report and User Profiling Report.</div> <div>&nbsp;</div> <div>For example, the below screenshot displays the Agreements Pending Execution Report with its input fields and values localized from English to German&nbsp;:</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Improving localization 1.png|720px|Improving localization 1.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Improving localization 2.png|720px|Improving localization 2.png]]</div> <div><br/> In another example, the Signature Type Report is displayed as shown below in English and French respectively:</div> <div class="image-green-border">[[File:Improving localization 3.png|720px|Improving localization 3.png]]</div> <div class="image-green-border">&nbsp;</div> <div>&nbsp;</div> <div class="image-green-border">[[File:Improving localization 4.png|720px|Improving localization 4.png]]</div> <div>&nbsp;</div> 
== Displaying Date and Time as per User Preferences ==
<div>
Previously, all Date related columns and parameters in all ICI reports were displayed in the UTC Time Zone in the mm/dd/yyyy format. ICI allowed users to set the Date and Time format as per their preferred locale settings.

With this release, all reports will display the Date and Time as per the Time Zone set by the user in the user preferences.
<div class="image-green-border">[[File:Displaying Date 1.png|720px|Displaying Date 1.png]]</div> </div> <div>
However, the following points need to be noted:

*When reports are exported to CSV format, due to the inherent property of the CSVS files, the Date and Time format of the Date columns will be as per the user's local machine format, not as per the User Preferences set in ICI. 
*In all reports, where the parameters to generate the reports have dates (for example, Created Start Date andCreated End Date in the Cycle Time Report), the default value in these fields are displayed in the UTC time zone. However, when the user changes values in these fields and generates the reports, the dates will then be displayed as per the user’s local time. 
</div> <div>
*If the Date Format selected in the user’s preferences is dd-mmm-yy, the date value in the field gets converted to the month & vice-versa. As a workaround, the date format in this field has been set as mmmm-dd-yyy, so that the default value is displayed as per the user’s expectations. However, the date format when the report is generated is displayed as per the user’s preferences. For example, if the user selects the Date Format as dd-MMM-yy in My Preferences, then the dates displayed in the Cycle Time Report fields Created Start Date and Created End Date are actually set as mmmm-dd-yy. 
</div> <div class="image-green-border">[[File:Displaying Date 2.png|720px|Displaying Date 2.png]]</div> 
&nbsp;

&nbsp;

== Using the Timezone filter ==

1.&nbsp;'''Click''' the Reports tile on the Dashboard. The Reports page opens.
<div class="image-green-border">[[File:Time Zone Filter 1.png|720px|Time Zone Filter 1.png]]</div> 
2.&nbsp;'''Click''' a report Dashboard tile, for example User Login Report. The report opens in a new tab.
<div class="image-green-border">&nbsp;</div> <div class="note-box">'''Note''':&nbsp;The Time Zone parameter is only available in the following default reports - Agreements Pending Execution Report, Agreements Pending Approval Report, Clauses Pending Approval Report, Templates Pending Approval Report, Agreement Clause Content Report, User Login Report, Signature Type Report, Cycle Time Report, Approved Requests Waiting For Contract Creation Report, Masterdata Information Report, Clause Deviations Report, Clause Summary Report and Detailed Report.</div> 
3.&nbsp;'''Enter''' a User Name&nbsp;for which you want to view the report.
<div class="image-green-border">[[File:Time Zone Filter 2.png|720px|Time Zone Filter 2.png]]</div> 
4.&nbsp;'''Click''' View Report. The default time zone of the report is (UTC) Coordinated Universal Time, based on which the Login Date & Time column is displayed.&nbsp;
<div class="note-box">'''Note''':&nbsp;The default time zone is based on the Time Zone selected under Locale Settings under Preferences.</div> <div class="image-green-border">[[File:Time Zone filter 4.png|720px|Time Zone filter 4.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> 
5.&nbsp;'''Click''' the Time Zone drop-down. The available time zones will be displayed.
<div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Time Zone filter 3.png|720px|Time Zone filter 3.png]]</div> 
6.&nbsp;'''Select''' the time zone in which you want to view the report, for example (UTC -08:00) Pacific Time (US & Canada).
<div class="image-green-border">[[File:Time Zone filter 4.png|720px|Time Zone filter 4.png]]</div> 
7.&nbsp;'''Click''' View Report. The Login Date & Time column values will be displayed according to the newly selected time zone.
<div class="image-green-border">[[File:Time Zone filter 7 A.PNG|720px|Time Zone filter 7 A.PNG]]</div> 
The tool-tip for the Report Generated On time-stamp also displays the selected time zone.
<div class="image-green-border">[[File:Time Zone filter 8.PNG|720px|Time Zone filter 8.PNG]]</div> 
8.&nbsp;'''Click''' the Export drop down menu to download the report in Excel, PDF or CSV format.
<div class="image-green-border">[[File:Time Zone filter 6.png|720px|Time Zone filter 6.png]]</div> 
== Adding Reports as KPIs ==
<div>
In addition to the reports that are already available on the Dashboard as KPIs (Agreement Deviation Report, Agreements Pending Approval Report, Agreements Pending Execution Reports, Average Agreement Turn Around Time Report, Clauses Pending Approval Report, Expiring Agreement Report, and Templates Pending Report), users can now also add the following reports:
<div class="image-green-border">[[File:7.12 Reports 4.PNG|720px|7.12 Reports 4.PNG]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">This can be achieved by providing access through Security Groups.</div> 
For example, the Signature Type Report KPI depicts the percentage of electronic signatures in ICI. If the number of electronic signatures is 6 and the number of manual signatures is 83, then the KPI is calculated as 6/83+6 = 6/89 (total number of agreements). Therefore, the percentage of electronic signatures displayed on the KPI tile on the Dashboard is 6 (rounded off to nearest digit).
<div class="image-green-border">[[File:Adding reports as KPI 2.png|720px|Adding reports as KPI 2.png]]</div> <div class="image-green-border">
Other reports that are available&nbsp;KPIs on the Dashboard include:
</div> 
*Agreement Deviation Report 
*Agreements Pending Approval Report 
*Agreements Pending Execution Report 
*Average Agreement Turn Around Time Report 
*Clauses Pending Approval Report 
*Expiring Agreements Report 
*Templates Pending Approval Report 

&nbsp;

== Enabling access to platform analytics report&nbsp; ==

To enable access to platform analytics reports&nbsp;through the Reports tile:

1.&nbsp;'''Click'''&nbsp;"Admin" > Security Groups > Security Groups. The Security Groups page opens.
<div class="image-green-border">[[File:Enabling Access PAR 1.png|720px|Enabling Access PAR 1.png]]</div> 
2.&nbsp;'''Click''' the view record icon next to the Security Group for which you want to enable the report access. The Security Group Details page opens.
<div class="image-green-border">[[File:Enabling Access PAR 2.png|720px|Enabling Access PAR 2.png]]</div> 
3.&nbsp;'''Click''' Edit. The edit view is displayed.
<div class="image-green-border">[[File:Enabling Access PAR 3.png|720px|Enabling Access PAR 3.png]]</div> 
4.&nbsp;'''Click''' on the Report&nbsp;tab.
</div> <div class="image-green-border">[[File:Enabling Access PAR 4.png|720px|Enabling Access PAR 4.png]]</div> <div>&nbsp;</div> <div>The 6 reports mentioned earlier are available in 3 versions. For example:&nbsp;</div> 
*Agreements Pending Approval: This is the existing core report. 
*Agreements Pending Approval – Import: In this mode, data can be imported into Power BI. In order to get latest updates, the report needs to be refreshed. 
*Agreements Pending Approval – Direct: This displays live data and does not need to be refreshed to display latest updates. 
<div class="note-box">'''Note''':&nbsp;Configurators are expected to enable only one version of a report at a time to avoid duplicate reports from being displayed to users.</div> <div>&nbsp;</div> <div>&nbsp;</div> 
== Editing a platform analytics report ==

On the Reports page, '''click''' the tile of the report which you want to view, for example Agreement Deviation.&nbsp;
<div class="image-green-border">The report opens in a new tab.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Editing 1.png|720px|Editing 1.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="note-box">'''Note''':&nbsp;By default, these reports are available in read-only mode. To enable editing for a user, they need to be provided with Manage&nbsp;access to Power BI reports through&nbsp;Edit Security Groups > Privileges > Power BI Reports. A user having this Manage&nbsp;access can edit the platform analytics reports as well.</div> 
In edit mode, users can select or change Visualizations and add or remove Fields and customize the report as required.
<div class="image-green-border">[[File:Editing 2.png|720px|Editing 2.png]]</div> 
To save these customizations, click File > Save as. The Save your report&nbsp;popup is displayed.
<div class="image-green-border">[[File:Editing 3.png|720px|Editing 3.png]]</div> 
Enter a name for your report.
<div class="image-green-border">[[File:Editing 4.png|720px|Editing 4.png]]</div> 
'''Click''' Save. The report gets saved and is displayed in the My Reports&nbsp;section on the reports page.

&nbsp;
<div class="note-box">Note: The My Reports section is only displayed to users who have Power BI reporting privilege set to Manage mode.</div> 
Once the report is saved, reopening it displays two options in the File menu:
<div class="image-green-border">[[File:Editing 5.png|720px|Editing 5.png]]</div> 
*Save: '''Click''' to save any changes made to your report, in this example, the Agreement Deviations Q1. 
*Save as: '''Click''' to save as a new report, separate from the previously created one. 

On the Reports page, users can also edit the report name or delete a report.
<div class="image-green-border">[[File:Editing 6.png|720px|Editing 6.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="note-box">'''Note''': These options are available only in the My Reports section.</div> 
Customized reports created and saved in the My Reports section can further be shared with other users through Security Groups. These reports are indicated with a shared report icon and will be available to other users under Custom Reports on the Reports page.
<div class="image-green-border">&nbsp;</div> 
&nbsp;






== Viewing Platform Analytics Report ==

This release introduces multiple core reports as part of platform analytics in direct query and import mode such as:

*Agreement Clause Content Report 
*Agreement Deviation Report 
*Agreements Pending Approval 
*Agreements Pending Execution 
*Approved Requests Waiting for Contract Creation Report 
*Average Agreement Turn Around Time Report 
*Clause Profiling Report 
*Clauses Pending Approval Report 
*Clause Summary Report 
*CLM Activity Report 
*Cycle Time Report 
*Expired Agreements Report 
*Expiring Agreements Report&nbsp; 
*Signature Type Report&nbsp; 
*Tagged Attribute Report 
*Template Clause Report 
*Templates Pending Approval Report 
*User Login Report 

To view Platform Analytics Reports follow steps as shown in following example.

Example: Tagged Attribute Report

For ICI user with “View” access:&nbsp;

On “Tagged Attribute Report” page

#'''Click''' on “Reports” tile on Home page, observe “Tagged Attribute Reports” tabs. Click on PowerBI report.&nbsp; 

On report page

#“Clauses” and “Templates” tabs are displayed&nbsp; 
#Report data is refreshed once a day. Last refresh Date and Time is displayed at the top right corner of the report with title “Report Generated On”. &nbsp; 
#“Attribute Name”, “Clause Created By” and “Contract Type” filters are provided&nbsp; 
#“Count of Clauses”, “Data Type” and “Is Global” cards are displayed below the filters&nbsp; 
#A table containing following columns – &nbsp; 
#Clause code, Clause name, Clause version, Clause created by, Clause created on, Version updated on, Is template variable, Is extended attribute, Attribute display name&nbsp; 
<div class="image-green-border">[[File:Tagged Attribute 2.PNG|720px|Tagged Attribute 2.PNG]]</div> <div class="image-green-border">&nbsp;</div> <ol start="2">
<li>'''Select''' appropriate filter criteria to generate the report.</li>
</ol>
<div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:8.1 Tagged Attribute 3.PNG|720px|8.1 Tagged Attribute 3.PNG]]</div> <div class="image-green-border">&nbsp;</div> <ol start="3">
<li>'''Click '''on “Templates” tab, to open Templates report. Similar filters and cards are displayed with Last refresh Date and Time along with title “Report Generated On”. Also, “Single Attribute Name” selected on “Clauses” tab remains same on “Templates” tab.&nbsp;</li>
</ol>
<div class="image-green-border">[[File:8.1 Tagged Attribute 4.PNG|720px|8.1 Tagged Attribute 4.PNG]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">For ICI user with “Manage” access:&nbsp;</div> <div class="image-green-border">&nbsp;</div> 
#Click on “Reports” tile on Home page, click on “Tagged Attribute Reports” with PowerBI tag.&nbsp; 
#Observe that it has all the functionalities same as when user had “View” access but now user can edit and save report with different name.&nbsp; 
<div class="image-green-border"><ul style="margin-left: 40px;">
<li>Observe “Visualization” and “Fields” additional right navigation pane.&nbsp;&nbsp;</li>
<li>User can add or remove these fields in the report – Attributes, Clause Contract Type, Clauses, Template Contract Type, Templates from “Fields”&nbsp;</li>
<li>User can add visual effects to a report by using “Visualizations”&nbsp;</li>
</ul>

[[File:8.1 Manage access 5.PNG|720px|8.1 Manage access 5.PNG]]
<ol start="3">
<li>User can change view from left corner drop down “View”&nbsp;</li>
</ol>

[[File:8.1 Tagged Attribute View 6.PNG|720px|8.1 Tagged Attribute View 6.PNG]]
<ol start="4">
<li>User can save the report with different name by clicking on “File” > “Save as”&nbsp;</li>
</ol>

[[File:8.1 Tagged Attribute Save 7.PNG|720px|8.1 Tagged Attribute Save 7.PNG]]

A new window is popped where user can write the name of the file he wants to save. Click on “Save” button.&nbsp;&nbsp;

Agreement Clause Content Report

In this report,&nbsp;a visualization depicting top clauses which caused most agreement deviations is displayed. Clause description, original clause text and deviated agreement clause text is available on drilldown too.

'''For ICI user with “View” access:'''

[[File:ACCR 02.png|720px]]

'''For ICI user with “Manage” access:'''

[[File:ACCR 06.png|720px]]

&nbsp;
</div> 
Agreement Deviation Report

This report provides details related to Agreements that have registered deviations from the standard Clause language definitions in the library.
<div class="image-green-border">[[File:Agreement Deviation.png|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">
Agreements Pending Approval Report: This report contains the following parameters:

*Pending with: You can apply multiple filters such as users from the available list. This displays the count of agreements created by selected users that are pending for approval per contract type and the count of agreements created in the last 30 or 31 to 60 days (count of agreements by ageing days). 

[[File:Agreement Pending Approval 2.png|RTENOTITLE]]

You can view the agreement details by scrolling down on the Agreements Pending Approval&nbsp;page.

[[File:Agreement Pending Approval 1.png|RTENOTITLE]]

You can view more details about the agreements by clicking the specific agreement and then clicking Drill Through. This opens the list of agreements associated with the specific contract type. Follow the same process to know more about the agreements by ageing days.

[[File:Agreement Pending Approval 2.png|RTENOTITLE]]

Follow the same process to filter agreements per organization unit, contract type, ageing days.&nbsp;<br/> You can follow the same process to view the other reports.&nbsp;

Agreements Pending Execution&nbsp;

[[File:Agreement Pending Execution.png|RTENOTITLE]]

Approved Requests Waiting for Contract Creation Report

This report provides a consolidated list of Requests for which the contract creation has not begun. It enables the user to view all the actions that need to be taken and reduce chances of missing pending Requests to create Contracts.

[[File:Approved Request waiting for Contract creation.png|RTENOTITLE]]

Average Agreement Turn Around Time Report

This report provides information on the average number of days required for executing an Agreement or Amendment, from the date of its creation till the date of its execution.

[[File:Average Agreement Turnaround Time.png|RTENOTITLE]]

Clause Profiling Report

This report helps in the mapping of Clauses to the corresponding Templates, with respect to the selected Contract Types. It helps application administrators to view the impact of a particular Clause on all the Templates that have the Clause added in the system.

[[File:Clause Profiling Report.png|RTENOTITLE]]

Clauses Pending Approval Report

This report provides information on the number of clauses that are pending approval for an Agreement or Amendment along with the duration and the version.

[[File:Clauses pending Approval.png|RTENOTITLE]]

&nbsp;

Clause Summary Report

This report provides summerized information based on “Clause Name” and “Clause Version”.

[[File:8.1 Clause Summary Report page.PNG|520px|8.1 Clause Summary Report page.PNG]]

CLM Activity Report

This report provides a quick view for the business leaders on the current high level status of the Agreements, Contract Requests and user activity to gauge the adoption of the ICI platform in their organization and take corrective action to increase adoption of the platform.

[[File:1080px-CLM Activity 10.png|720px|1080px-CLM Activity 10.png]]

Cycle Time Report

This report shows the cycles for an Agreement and the change of states from the date of creation to the date of execution as well as the elapsed time.

[[File:Cycle Time.png|RTENOTITLE]]

Expired Agreements Report&nbsp;

[[File:Expired Agreements.png|RTENOTITLE]]

Expiring Agreements Report&nbsp;

[[File:Expiring Agreements.PNG|720px|Expiring Agreements.PNG]]

Signature Type Report&nbsp;

[[File:Signature Type.png|RTENOTITLE]]

Template Clause Report

This report helps in the mapping templates to the corresponding Clauses, with respect to the Contract Types. It helps administrators to view the impact when a particular Clause or Template is changed in the system.

[[File:Template Clause Report.png|RTENOTITLE]]

Templates Pending Approval Report

This report provides details related to Templates pending approvals, along with the duration and version.

[[File:Template Pending Approval.png|RTENOTITLE]]

User Login Report&nbsp;

[[File:User Login Report.png|RTENOTITLE]]
</div>



== AI Model Training Performance Report ==

To help administrators to monitor the DiscoverAI’s self-learning progress, a new AI model training performance report has been introduced for each AI model defined in ICI. The report provides a check over the discovery performance for attributes and the need to train AI model with more examples.
<div class="note-box">'''Note''': Access to this report is based on purchase of DiscoverAI app and requisite security permissions.</div> 
To access the report:&nbsp;

1.&nbsp;'''Click'''&nbsp;"Configure"&nbsp;> Masterdata&nbsp;&nbsp;on the Home page. The Masterdata index page opens.
<div class="image-green-border">[[File:AI1.png|720px|AI1.png]]</div> 
2. '''Click'''&nbsp;"View Details" icon corresponding to the AI Model you want to view report for. For example, Payment Terms data. The masterdata aka AI Model Details page opens.
<div class="image-green-border">[[File:AI 2.PNG|720px|AI 2.PNG]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">3.&nbsp;'''Click''' the link in the Model training performance report field under the Advanced section. For example, the View report link. The Report page opens.&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">This report link with the link text are seeded and preconfigured in the AI Configuration Master Contract Type.</div> <div class="image-green-border">The report represents the current AI Model’s (Payment Terms data) week wise accuracy trend in a chart and table form for up to 24 weeks. The graph is plotted as accuracy&nbsp;% against the last 24 weeks in the YYYYWW format.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.16-Accessing the Report4.png|720px|7.16-Accessing the Report4.png]]</div> 
The report’s table includes below mentioned details as columns with the total for each column:&nbsp;

*Attributes name&nbsp; 
*Number of times&nbsp;attributes are discovered in the model 
*Number of times the attribute value is accepted by a user as they are. 
*Number of times a new attribute value is specified by a user 
*Accuracy percentage as number of times the attribute value accepted by user as they are/number of times attributes discovered in the model 

You can filter the report to view results for specific Attributes either from the Attribute filter provided at the top or by clicking the specific attribute name in the Attributes column in the report table.
<div class="image-green-border">[[File:7.16 AI Training Report.png|720px|7.16 AI Training Report.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">The chart will represent the AI Model Accuracy graph for selected Attributes in different colors. For example, the report below shows the Payment Terms and Late Payment attributes accuracy trend.</div> <div class="image-green-border">&nbsp;</div> 

= Configuring Dynamic Reports =

In Icertis Contract Intelligence, you can view preconfigured reports by navigating to the Reports tile. ICI currently offers two types of dynamic reports: Power BI reports and SQL Server Reporting Services (SSRS) reports.&nbsp;&nbsp;

Starting from version 8.2, Icertis provided the tools to create agreement-based SSRS reports and customize dynamic views. These views, in turn, can be used in&nbsp;Power BI datasets and SSRS reports.&nbsp;&nbsp;

== Dynamic views ==

Dynamic views contain data from one or more objects, giving you an integrated view across the environment. For example, you can create a view showing all the agreements pending approval. This saves you the hassle of opening each agreement to look up its approval status.&nbsp;

<br/> Dynamic views are also automatically updated when related objects or extended objects are created or changed. &nbsp;

<br/> With dynamic views, you can create new views or update existing views for generating Power BI and SSRS reports. You can download and view the dynamic view definition in JSON format. This topic covers the SSRS-based report management. For information about Power BI reports, see <[https://ici-us-wiki01.icertis.com/ICIHelp8.2/index.php?title=Power_BI_Integration_with_ICI Power BI Report]s>.
<div>&nbsp; 
== SSRS-based dynamic reports ==
</div> 
SQL Server Reporting Services (SSRS) is a server-based report generating software system made by Microsoft and is used as a solution to build custom reports from a variety of data sources such as SQL databases and other external sources. Administrators can share reports with users based on access permissions and user groups.

In ICI, you can create custom SSRS reports by uploading a new report definition in a JSON file. SSRS reports can use data from dynamic views.

== Structure of a dynamic view-based report&nbsp;&nbsp; ==

This section helps you understand the structure of dynamic reports when they are generated from dynamic views. Each dynamic view is defined in a JSON file. Thus, if we identify and modify the JSON file for a dynamic view, we can modify the report created using that particular dynamic view.
<div class="image-green-border">[[File:SSRS 01.png|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> 
== Preparing for report configuration&nbsp; ==

*To view and access the report configuration settings, you must have the Report Admin technical role in Icertis Contract Intelligence.&nbsp;&nbsp; 
<div class="image-green-border">[[File:SSRS 10.png|720px]]</div> 
*You must have access to all the agreements from which data is extracted to create reports. &nbsp; 

&nbsp;

== Accessing report configuration settings&nbsp; ==

These quick steps show you how to access the report configuration settings and summarize the purpose of the tabs on the '''Report Configuration''' page.&nbsp;&nbsp;

#On the '''Configure''' tile, click '''System Configuration''' 
<div class="image-green-border">[[File:SSRS 02.png|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp; &nbsp;2. Click '''Report Configurations'''.&nbsp;&nbsp;</div> <div class="image-green-border">[[File:SSRS 03.png|RTENOTITLE]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">
The Report Configurations page is displayed, containing subtabs where you can view and configure reports:&nbsp;

*'''Dynamic Views:''' This tab contains&nbsp;view definitions you can use to create or update dynamic views. 
*'''Dynamic Reports:''' This tab shows a list of templates or existing report definitions that have been uploaded. You can download any of the existing templates or report definitions, and use it to build your own report definition file in JSON format. 
*'''History:''' This tab contains a log&nbsp;of updates made to the dynamic views and reports. 
<div class="note-box">Note: In version 8.2, only agreement and amendments-related report templates are supported.</div> 
[[File:History section.PNG|720px]]

&nbsp;

== Managing dynamic views ==

As a Report Admin, you can modify dynamic views in ICI. These changes are made in the JSON file for the dynamic view. You can make changes such as add or remove columns and change the data that is fetched from different source agreements.

Changes to the views reflect in the dynamic reports that use data from these views. You can view the available dynamic views by navigating to '''Configure '''tile > '''System Configuration''' > '''Report Configurations''' > '''Dynamic Views'''.

To modify a dynamic view:

1.&nbsp;&nbsp;&nbsp;&nbsp; Go to '''Configure''' tile > '''System Configuration''' > '''Report Configurations''' > '''Dynamic Views'''.

2.&nbsp;&nbsp;&nbsp;&nbsp; Download the JSON file for the dynamic view: click the three-dot menu to the far right in the report name row and select '''Download'''.<br/> The view JSON file is downloaded to your local system.

3.&nbsp; &nbsp; &nbsp;Open the JSON file in a text editor, make the required configuration changes, and save the file.

For example, to add a column, you can copy one of the existing JSON objects for a column and change the attribute values such as column display name.

&nbsp;

[[File:SSRS 06.png|720px]]


== Managing SSRS reports ==

The ability to create your own custom SSRS reports and update them as required gives you more control over reporting.

=== Creating and updating SSRS reports ===

You can download any of the existing templates or report definitions and use them to build your own report definition file in JSON format. You can also upload a new JSON file to create a custom SSRS report.

#Go to Configure tile > System Configuration > Report Configurations > Dynamic views, and download a template or an existing view. 

The template JSON file is downloaded on your local system.
<ol start="2">
<li>Open the JSON file in a text editor.</li>
</ol>
<div class="note-box">Note: When creating a new SSRS report from an existing report, ensure that you remove &nbsp; the VersionID and enter a unique value for the ReportNameOnTile attribute.<br/> &nbsp;</div> <div class="image-green-border">&nbsp;</div> 
3.&nbsp;&nbsp;&nbsp;&nbsp; Change the JSON objects as required and save the file.

4.&nbsp;&nbsp;&nbsp; &nbsp;Navigate back to the '''Reports Configurations''' > '''Dynamic Reports''', click '''Upload '''and attach the modified JSON file.
<div class="image-green-border">[[File:SSRS 07.png]]</div> 
On successful upload of the JSON file, a new custom SSRS report is created.

(Optional) To verify whether the changes have been successfully implemented, click '''History''' in the left pane and view the generated logs.

== Updating SSRS reports that use a dynamic view&nbsp; ==

If you want to make changes in an SSRS report that is fetched from a dynamic view, you must first update the dynamic view JSON file and then update the report JSON file.

To know which dynamic view is used in your SSRS report, download the report JSON file and look for the '''SourceEntityName '''attribute value.
<div class="image-green-border">[[File:SSRS 08.png|720px]]</div>

=== Update the dynamic view JSON file ===

After identifying the dynamic view that’s linked to the dynamic report, the next step is to update the dynamic view. The configuration properties of a dynamic view are stored in a JSON file. To update a dynamic view, you must download the JSON file, make changes, and upload it back.&nbsp;

#Go to Configure tile > System Configuration > Report Configurations > Dynamic Views, and download the JSON file for the dynamic view.&nbsp; 
#Click the three-dots on the right of the view name row and select Download. The view JSON file is downloaded to your local system.&nbsp; 
#Open the JSON file in Notepad C++, make the required configuration changes, and save the file. &nbsp;<br/> For example, to add the Signature Type column to the existing view, add a column attribute for the new column.&nbsp; 

[[File:SSRS 06.png|RTENOTITLE]]

&nbsp; &nbsp; 3. On Report Configurations > Dynamic Views, click the Upload button and attach the modified JSON file.&nbsp;

[[File:SSRS 07.png|RTENOTITLE]]

After the JSON file is uploaded, a success notification is displayed in the lower-right corner of the window.&nbsp;
<ol start="4">
<li>(Optional) To verify whether the changes have been successfully implemented, click Audit Logs in the left pane and view the generated logs.</li>
</ol>

=== Update the dynamic report JSON file&nbsp;&nbsp; ===

Just modifying the dynamic view is not sufficient. To display the changes, you must update the changes in the dynamic report JSON file.&nbsp;

#&nbsp; 

Go to Configure tile > System Configuration > Report Configurations > Dynamic Reports, and download the JSON file for the dynamic report.&nbsp;
<ol start="2">
<li>Open the JSON file in Notepad C++, make the required configuration changes, and save the file. &nbsp;<br/> For example, to add the Signature Type column to the existing report, add a JSON object&nbsp; for the new column.&nbsp;</li>
</ol>

Tip: To add a column, you can copy one of the existing JSON objects for a column and change the attribute values such as column name and column position.&nbsp;&nbsp;&nbsp;
<ol start="3">
<li>On Report Configurations > Dynamic Reports, click the Upload button and attach the modified JSON file. After the JSON file is uploaded, a success notification is displayed in the lower-right corner of the window.&nbsp;</li>
</ol>
<ol start="4">
<li>(Optional) To verify whether the changes have been successfully implemented, click Audit Logs in the left pane and view the generated logs.&nbsp;</li>
</ol>

== Creating new custom SSRS reports&nbsp; ==

You can download any of the existing templates or report definitions, and use it to build your own report definition file in JSON format. You can also upload a new JSON file to create a custom SSRS report.&nbsp;

#&nbsp; 

Go to Configure tile > System Configuration > Report Configurations > Dynamic views, and download a template or an existing view.&nbsp;<br/> The template JSON file is downloaded on your local system.&nbsp;
<ol start="2">
<li>Open the JSON file in Notepad++.&nbsp;</li>
</ol>
<div class="note-box">Note: Ensure that you change/remove the VersionID and enter unique values for the ReportNameOnTile attribute.&nbsp;</div> 
[[File:SSRS 08.png|RTENOTITLE]]
<ol start="3">
<li>Change the JSON objects as required and save the file.&nbsp;</li>
</ol>
<ol start="4">
<li>&nbsp;Navigate back to the Reports Configurations > Dynamic Reports, click Upload and attach the modified JSON file.&nbsp;</li>
</ol>

[[File:SSRS 09.png|RTENOTITLE]]

On successful upload of the JSON file, a new custom SSRS report will be created.&nbsp;
<ol start="5">
<li>(Optional) To verify whether the changes have been successfully implemented, click Audit Logs in the left pane and view the generated logs.&nbsp;</li>
</ol>

&nbsp;
</div> 
'''Related Topics:'''&nbsp;[[Agreement_Management|Agreement Management]]&nbsp;|&nbsp;[[Agreement_Details_Page_Reports|Agreement Details Page Reports]]&nbsp;|&nbsp;[[Legal_and_Compliance|Legal and Compliance Reports&nbsp;]]| [[Admin_Reports|Admin Reports]] | [[Workflow_Reports|Workflow Reports]]&nbsp;| [[Power_BI_Integration_with_ICI|Power BI Integration with ICI]]&nbsp; |&nbsp;[[Clause_and_Deviation_Insight_Reports|Clause and Deviation Insight Reports]]&nbsp;| [[Obligation_Management_Reports|Obligation Management Reports ]]| [[Sourcing_Reports|Sourcing Reports]]&nbsp;|&nbsp;[[Release_Notes|Release_Notes]]&nbsp;|