Tile Audit Viewer
This program lets you view changes made to business insight tiles, which are stored in the AdmTileAudit table.
Exploring
Things you can do in this program include:
-
View the time and date of when a business insight tile was created, changed and deleted.
-
View the differences before and after the changes were made to a business insight tile using the Preview Audit Differences program.
This program is accessed from the Program List of the SYSPRO menu:
- Program List > Administration > General Setup
Business insight tiles (also called insight tiles or just tiles) are essentially SQL scripts displayed in a tile format within a SYSPRO web view. These tiles are context-driven and let you act instantly on events, facilitating informed business decisions and sound business behavior.
KPIs on tiles can be used to highlight values approaching or exceeding pre-determined objectives or thresholds. This lets you proactively keep an eye on approaching targets. These targets could be a certain value, company-wide goal or a specific target agreed for a person or a role within the organization.
Starting
The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.
SYSPRO Ribbon bar > Setup > Operators
-
Tile KPI definition access control
Solving
In SYSPRO 7 Update 1 and SYSPRO 8 standard tiles are shipped in the \Base\Samples folder and custom tiles are designed to be located in \Plugin\CustomStore folder.
Some custom tiles may have been created by copying and renaming existing tiles in \Base\Samples folder instead of moving the custom tile to the \Plugin\CustomStore folder.
During the minor database upgrade to SYSPRO 8 2021 R2 (or later) these non-standard tiles are detected and automatically migrated to the \Plugin\CustomStore folder with the appropriate file prefix. Standard tiles located in \Base\Samples and custom tiles in \Plugin\CustomStore are also uploaded to the new system-wide AdmTileDefinition table.
In addition, once each custom tile has been uploaded to SQL, the custom tile definition files in \Plugin\CustomStore are moved to the \Plugin\CustomStore\Tile_Backup folder.
If any problems are found during the tile upload process, the tile definition file is moved to the \Plugin\CustomStore\Tile_Backup_Upload_Failed folder. An explanation of the failure is stored in a separate file with the file suffix _Upload_Failed_Reason.TXT.
-
Select the Design Web View (or Edit Web View) option from the Customize and control this application icon ().
This icon is available on the toolbar of the main SYSPRO window, as well as on each SYSPRO program's toolbar.
-
From the Visual Designer program, select the Add layout section function.
-
From the Configure new layout section window, select Tile Section.
-
Optionally enter a Section title at the Widget title placeholder and assign an icon to the tile if required.
-
Select the Add section function.
-
Click in the Add tile block (designated by the icon).
A list of KPI and Metric categories are displayed.
The number of available insights are indicated by a number in brackets alongside each tile category.
-
Drill down into the relevant category and select the tile you want to deploy.
-
(Optional) Define the following for the tile:
-
Width
-
Text
-
Tile background color
-
Icon
-
-
Select the Add tile function to assign the tile to the current layout section.
Continue adding tiles to the current layout section or to a new layout section.
-
Select Save and Exit.
Your tile will be displayed in the web view, immediately showing the appropriate insight information.
-
Open the Insight Tile Definition program (SYSPRO Programs > Administration > General Setup).
-
Select the New Tile function to create a custom tile.
The Tile Builder program is launched:
-
Enter the tile details within the New Tile window.
-
Select the Edit Tile Summary function.
You can also manually edit the SQL statement by selecting the Edit Tile Detail button.
The Tile Builder - SQL Definition program is displayed:
-
Select the Select data source function at the Primary data source field in the From section to indicate the anchor data source. The Data Sources program is displayed.
-
Highlight the relevant table from the Data Sources list view and click on Select.
Once you have selected the data source it is displayed in square brackets next to the Primary data source field in the Tile Builder - SQL Definition program.
-
Select the Validate SQL and Close function to exit the Tile Builder - SQL Definition program.
-
-
Select the Save and Close function to exit the Tile Builder program.
-
-
Exit the Insight Tile Definition program.
-
Open the Insight Tile Definition program (SYSPRO Programs > Administration > General Setup).
-
Create a new custom tile (or select an existing business insight tile) to launch the Tile Builder program:
-
Select the Edit Tile Summary function to launch the Tile Builder - SQL Definition program:
You can also manually edit the SQL statement by selecting the Edit Tile Detail button.
-
Indicate the anchor data source at the Primary data source field.
You can use the Select data source function to search for and select the data source using the Data Sources program.
-
Once the main data source has been defined, select the Select column function at the Value field.
-
The Data Sources program is launched, from where you can select the relevant column from the Columnslist view.
Once you have selected the column, the column name is displayed next to the Value field in the Tile Builder - SQL Definition program.
-
Select the Validate SQL and Close function to exit the Tile Builder - SQL Definition program.
-
-
Select the Save and Close function to exit the Tile Builder program.
-
-
Exit the Insight Tile Definition program.
Certain business insight tiles (e.g. Number of users logged into SYSPRO or Total Accounts Receivable balance for the company) only display holistic information and therefore don't require any context (i.e. defined parameters or keys).
While other tile types are context driven and therefore require additional information (such as keys or parameters) to display the appropriate values.
For example:
-
Customer outstanding balance
When a business insight tile is added to the Customer Query program to display the current customer balance, the customer key (from the ArCustomer table) is required so that the relevant condition can be included in the SQL statement.
The SYSPRO user interface gathers a list of the key fields provided in the various forms and toolbars. Therefore, when a user selects a tile, the list of keys (together with their current values) are then passed to the tile.
You can access the key value and use it within your SQL query by defining an appropriate key type field against the tile.
For example:
For the Customer balance for a customer business insight tile, you could do the following:
-
Define the Key type field as Customer.
This means, that if there is a customer key available at run time then the value can be used by the SQL query of the tile to select the current customer code.
Sample SQL Preamble:
declare @Customer varchar(${Customer.Length})
set @Customer = '$Customer'
The ${Customer.Length} variable will be replaced at run time with the length of the customer key in SYSPRO (currently 15 characters).
The $Customer variable that will be replaced at run time by the actual customer key.
SQL Condition:
Customer = @Customer
Sample SQL query script:
--SQL=Generated
--SQL=Preamble
declare @Customer varchar(${Customer.Length})
set @Customer = '${Customer}'
--SQL=Select
select
@Customer as 'SubTitle',
CurrentBalance1 as 'Value'
from
[ArCustomerBal] with nolock
where
Customer = @Customer
GO
If you select a key type and then edit the tile summary's SQL statement, an appropriate SQL preamble is provided. The SQL preamble shows how to take the key of the item at run time and create a SQL variable that can be used in the SQL select statement condition (WHERE statement).
Due to this automatic SQL preamble creation, we recommend that you select the key type before defining your tile summary or tile detail SQL statement.
Using
-
Columns in a list view are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the list view). Select and drag the required column to a position in the list view header.
-
Press Ctrl+F1 within a list view or form to view a complete list of functions available.
Referencing
This lets you select a time frame for which you want to view the changes made to business insight tiles.
This lets you indicate how many data records you want to view.
Column | Description |
---|---|
Date and time |
This indicates the date and time on which the tile was created, updated or deleted. |
Tile name |
This indicates the name of the tile. |
Description |
This indicates the description of the selected tile. |
Type |
This indicates the type of the tile:
|
In development |
A tick mark or Yes in this column indicates that the tile is still being developed (i.e. it isn't available to use yet and can only be viewed by the person who is creating the tile). |
Operator name |
This indicates the name of the operator who added, deleted or changed the tile. |
Operator |
This indicates the operator code of the operator who added, deleted or changed the tile. |
Action |
The View hyperlink in this column opens the Preview Audit Differences program, from where you can view the differences before and after the changes made. |
Change type |
This indicates the type of changes made:
|
Custom flag |
This indicates whether the tile is a Standard tile that was shipped with the software, or a Custom tile that has been created manually. This displays AI tile if the tile is an Artificial Intelligence tile. |
Change flag |
This indicates the changes that were made to the tile:
|
Date |
This indicates the date on which the tile was created, updated or deleted. |
Time |
This indicates the time at which the tile was created, updated or deleted. |
Tile id |
This indicates the unique, 6-character tile identification code. |
Copyright © 2022 SYSPRO PTY Ltd.