Tile Audit Viewer

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.

1. 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.

2. From the Visual Designer Program: IMPFRZ program, select the Add layout section function.

3. From the Configure new layout section window, select Tile Section.

4. Optionally enter a Section title at the Widget title placeholder and assign an icon to the tile if required.

5. Select the Add section function.

6. 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.

7. Drill down into the relevant category and select the tile you want to deploy.

8. (Optional) Define the following for the tile:

   • Width

   • Text

   • Tile background color

   • Icon

9. 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.

10. Select Save and Exit.

    Your tile will be displayed in the web view, immediately showing the appropriate insight information.

1. Open the Insight Tile Definition program (SYSPRO Programs > Administration > Enterprise Reporting).

2. Select the New Tile function to create a custom tile.

   The Tile Builder program is launched:

   1. Enter the tile details within the New Tile window.

   2. 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:

      1. 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.

      2. Highlight the relevant table from the Data Sources listview 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.

      3. Select the Validate SQL and Close function to exit the Tile Builder - SQL Definition program.

   3. Select the Save and Close function to exit the Tile Builder program.

3. Exit the Insight Tile Definition program.

1. Open the Insight Tile Definition program (SYSPRO Programs > Administration > Enterprise Reporting).

2. Create a new custom tile (or select an existing business insight tile) to launch the Tile Builder program:

   1. 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.

      1. 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.

      2. Once the main data source has been defined, select the Select column function at the Value field.

      3. The Data Sources program is launched, from where you can select the relevant column from the Columnslistview.

         Once you have selected the column, the column name is displayed next to the Value field in the Tile Builder - SQL Definition program.

      4. Select the Validate SQL and Close function to exit the Tile Builder - SQL Definition program.

   2. Select the Save and Close function to exit the Tile Builder program.

3. 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.

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.

declare @Customer varchar(${Customer.Length})
set @Customer = '$Customer'

Customer = @Customer

--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