QPR ProcessAnalyzer Project Workspace: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
(34 intermediate revisions by the same user not shown)
Line 1: Line 1:
In QPR ProcessAnalyzer, ''dashboards'', ''models'', ''datatables'' and ''scripts'' are organized into projects. '''Project Workspace''' shows all projects in a hierarchy (on the left side) and contents of the selected project (on the right side). Different types of entities are available as tabs. Currently, there are tabs for dashboards, models, datatables and scripts. Dashboards and datatables are described in this page and script are described in [[Managing Scripts]].
In QPR ProcessAnalyzer, ''dashboards'', ''models'', ''datatables'' and ''scripts'' are organized into projects. '''Project Workspace''' shows all projects in a hierarchy (on the left side) and contents of the selected project (on the right side) divided into tabs based on the type of the entity. There are tabs for dashboards, models, datatables and scripts. Dashboards and datatables are described in this article and script are described in [[Managing Scripts]].


The Project Workspace can be opened by clicking the ''QPR Software'' logo on top left, or in the '''Home''' screen by clicking the '''Workspace''' button.
The Project Workspace can be opened by clicking the ''QPR Software'' logo on top left, or in the '''Home''' screen by clicking the '''Workspace''' button. All actions, such as open, create, modify and delete, are available as buttons in the toolbar and also in the context menu, which can be opened by right clicking the target project, dashboard, datatable or script.


All actions, such as open, create, modify and delete, are available as buttons in the toolbar and also in the context menu, which can be opened by right clicking the target project, dashboard, datatable or script.
The projects hierarchy can be hidden by clicking the blue ''Collapse'' button in the top of the divider, to make more space for the contents table. If the Collapse button is not visible, hover the upper side of the divider with the mouse to make the button visible. To show the projects hierarchy again, click the grey ''Expand'' button on the top left of the screen.
 
There are the following requirements for names given to objects: it cannot be empty, maximum length is 440 characters, and it cannot contain the slash (/) character.


== Projects ==
== Projects ==
Projects are organized into a hierarchy, where projects can contain child projects. The hierarchy is visible in the left side of the workspace, where a project can be selected to see its contents on the right side. In addition, there is the '''Projects''' tab showing child projects of the selected project.


[[File:Workspace.png|1100px]]
[[File:Workspace.png|1100px]]
=== Opening Project ===
Project can be opened in the workspace to see its contents, by clicking the project in the left side hierarchy. Alternatively the '''Projects''' tab can be used browse projects by drilling down into child projects by double-clicking projects.


=== Creating Project ===
=== Creating Project ===
# On the left side projects hierarchy, select the project where you want to create a project.
# On the left side projects hierarchy, select the project where you want to create a new project.
# Click the '''New''' button and click either '''Project'''.
# Click the '''New''' button and click '''Project'''.
# Define a name for the projects and click '''Create'''.
# Define a name for the projects and click '''Create'''.


=== Deleting Project ===
=== Deleting Project ===
# Either select a single project on the left side hierarchy (only one can be selected), or one or several projects (and optionally other objects depending on which tab is open) on the right side list.
# Either select a single project on the left side hierarchy (only one can be selected), or one or several projects in the '''Projects''' tab.
# Click the '''Delete''' button and click '''Delete''' for the confirmation message. (The deleted project goes to the recycle bin.)
# Click the '''Delete''' button and click '''Delete''' for the confirmation message. (The deleted project goes to the recycle bin.)
Note that project cannot be deleted if the project or its child projects contain the currently selected model.


=== Renaming Project ===
=== Renaming Project ===
# Select the project to be renamed (either in the left side hierarchy or in the right side table).
# Select the project to be renamed either in the left side hierarchy or in the '''Projects''' tab.
# Click the '''Rename''' button.
# Click the '''Rename''' button.
# Change the project name in the opening dialog and click '''OK'''.
# Change the project name in the opening dialog and click '''OK'''.


=== Moving Project ===
=== Moving Project ===
Projects can be moved by dragging them with a mouse from the right side list to the target project in the left side hierarchy. A project can be seen in the right side list by opening its parent project in the left side projects hierarchy.
Projects can be moved by dragging them with a mouse from the '''Projects''' tab to a new parent project in the left side hierarchy. Projects can also be moved by selecting the project in the left side hierarchy or in the '''Projects''' tab, selecting the '''Move''' option in the context menu, and then selecting the new parent project in the opening list of projects.


== Dashboards ==
== Dashboards ==
Line 64: Line 73:


=== Importing Dashboard ===
=== Importing Dashboard ===
Dashboards can be exported and imported as .qprpa files containing the dashboard structure, e.g. charts with their settings (data shown by the dashboard is not included). Dashboard file can be imported if it has been exported using same or earlier QPR ProcessAnalyzer version. If the dashboard was exported using later version, it might not be possible to import it, if the dashboard structure supported by QPR ProcessAnalyzer has been improved between the versions.
To import a dashboard:
# From the left side projects hierarchy select the project where you want to import the dashboard.
# From the left side projects hierarchy select the project where you want to import the dashboard.
# Open the '''Dashboards''' tab.
# Open the '''Dashboards''' tab.
Line 75: Line 87:


== Models ==
== Models ==
Models can be created, opened, moved, deleted, imported, exported in the '''Models''' tab, which shows all models in the selected project. See an end-to-end description how to [[Creating_Process_Mining_Model|create model from eventlog data from a CSV file]].
'''Models''' tab shows all models in the selected project. Models can be opened, created, edited, deleted, imported and exported (you can go through an end-to-end instructions how to [[Creating_Process_Mining_Model|create model from eventlog data from a CSV file]]).


Model status icon is visible left of the model name, informing whether the model is in the server memory or being loaded into memory. To open dashboards and run analysis for a model, the model needs to be in the memory. Loading a model into memory might take a while depending the model size. Model can be on one of the following statuses:
Model status is important as in-memory processed models need to be ''online'' to use them on dashboards and run calculation on them. Model status is visible as an icon left of the model name, denoting whether the model is in the server memory or being loaded into memory. The memory capacity of the server limits how many models there can be in the memory at the same time. Also loading a model into memory might take a while depending the model size. Model is one of the following statuses:
* '''Online''': Model is currently in the memory and available to calculations.
* '''Online''': Model is currently in the memory and available to dashboards and analyses. Applicable only for in-memory models.
* '''Offline''':  Model is currently not the memory (and thus it's not consuming any memory resources).
* '''Offline''':  Model is currently not the memory (and thus it's not consuming any memory resources). Applicable only for in-memory models.
* '''Loading''': Model is currently being loaded into the memory. User needs to wait the loading to complete until the model can be used for calculation.
* '''Loading''': Model is currently being loaded into the memory. The loading needs to complete until the model can be used. Applicable only for in-memory models.
* '''Snowflake''': Model is a Snowflake stored model, and processing is done in the Snowflake. Thus the model will not be loaded into QPR ProcessAnalyzer memory and the model doesn't have any of the other statuses that are for in-memory models.


Note that in QPR ProcessAnalyzer, processing is performed in the server/cloud side, so the model does not need to be loaded into user workstation (and thus it doesn't consume any resources in the workstation).
Note that in QPR ProcessAnalyzer, all processing is performed in the server/cloud side, so the model does not need to be loaded into user workstation, and thus it doesn't consume resources in the workstation side.


=== Opening Model ===
=== Opening Model ===
# Select the project where the model to be opened is located.
# Select the project where the model to be opened is located.
# Open the '''Models''' tab.
# Open the '''Models''' tab.
# Double-click the model in the list, or select the model with a single click and click the '''Open''' button. Model is opened in the ''Process Discovery'' view.
# Double-click the model in the list, or select the model with a single click and click the '''Open''' button. Model is opened in the [[Navigation_Menu#Process_Discovery|Process Discovery]] view.


=== Editing Model Settings ===
=== Editing Model Settings ===
Model level settings are organized into following dialogs: Properties (general settings), Attributes, Notifications and Business calendar. Most settings can be changed while the model is in the memory, but changing datasource related settings and attribute settings will drop the model from the memory. Steps to edit settings:
# Select the project where the model is located.
# Select the project where the model is located.
# Open the '''Models''' tab.
# Open the '''Models''' tab.
# Select the model and select one of the following '''Properties''', '''Attributes''', '''Notifications''', '''Business Calender''' (model level settings are divided into these dialogs).
# Select the model and select one of the following options: '''Properties''', '''Attributes''', '''Notifications''' or '''Business Calendar''' (model level settings are organized into these dialogs).
# After viewing or editing properties, close the dialog by clicking '''OK'''.
# After viewing or editing properties, close the dialog by clicking '''OK'''.


See more:
See more about model level settings:
* [[Setting up datasources|Setting up datasources QPR_ProcessAnalyzer_Model_Datasources]]
* [[QPR_ProcessAnalyzer_Model_Datasources|Setting up datasources]]
* [[Case level permissions|Case_Level_Permissions]]
* [[Case_Level_Permissions|Case level permissions]]
* [[Automatic_Model_Loading_on_Server_Startup|Automatic_Model_Loading_on_Server_Startup]]
* [[Automatic_Model_Loading_on_Server_Startup|Automatic model loading on startup]]
* [[Calculated case and event attributes|Calculated_Attributes_in_QPR_ProcessAnalyzer]]
* [[Calculated_Attributes_in_QPR_ProcessAnalyzer|Calculated case and event attributes]]
* [[Email notifications|Email_Notifications]]
* [[Email_Notifications|Email notifications]]
Note that Attributes, Notifications, Business calendar and Case level permissions are not available for Snowflake models.


=== Loading, Dropping and Reloading Model ===
=== Loading, Dropping and Reloading Model ===
This functionality is only available for in-memory models.
# Select the project where the model is located.
# Select the project where the model is located.
# Open the '''Models''' tab.
# Open the '''Models''' tab.
# Select the model and select one of the following:
# Select the model and select one of the following options:
#* '''Load''' (available only when the model is ''offline'')
#*'''Load''' to start loading the model into memory. This option is available when the model is ''offline''.
#* '''Drop''' (available only when the model is ''online'' or ''loading'')
#*'''Drop''' to drop the model from the memory (for example to free memory resources). This option is available when the model is ''online'' or ''loading''.
#* '''Reload''' (available only when the model is ''online'' or ''loading'')
#*'''Reload''' to reload the model into the memory (i.e. drop and immediately start loading). Reloading is needed in order to get the latest data into the model after new data is imported to datatables. This option is available when the model is ''online'' or ''loading''.
 
The model status left of the model name is changed accordingly.


=== Creating Model ===
=== Creating Model ===
Line 118: Line 132:


=== Deleting Model ===
=== Deleting Model ===
When a model is deleted, it's not permanently removed, and can be recovered from the [[#Recycle_Bin|recycle bin]]. Note that possible datatables used by the deleted models, are not deleted. Note also that the currently selected model cannot be deleted.
Steps to delete models:
# Select the project where the model(s) to be deleted are located.
# Select the project where the model(s) to be deleted are located.
# Open the '''Models''' tab.
# Open the '''Models''' tab.
# Select one or several models to be deleted.
# Select one or several models to be deleted.
# Click the '''Delete''' button and click '''Delete''' to the confirmation message. Note that possible datatables used by the deleted models, are not deleted.
# Click the '''Delete''' button and click '''Delete''' to the confirmation message.


=== Renaming Model ===
=== Renaming Model ===
Line 134: Line 151:


=== Duplicating Model ===
=== Duplicating Model ===
When a model is duplicated, datatables that are possibly used by the model, are not duplicated so the duplicate model will refer to the same datatables as the original model (datatables can be duplicated separately if desired). Steps to duplicate a model:
# Select the project where the model to be duplicated is located.
# Select the project where the model to be duplicated is located.
# Open the '''Models''' tab.
# Open the '''Models''' tab.
# Select the model to be duplicated.
# Select the model to be duplicated.
# Click the '''Duplicate''' button. A duplicate of the model is created. Note that datatables that are possibly used by the model, are not duplicated.
# Click the '''Duplicate''' button. A duplicate of the model is created.


=== Importing Model ===
=== Importing Model ===
When a model is imported (from a .pacm file), a new model is always created (thus it's not possible to import data to an existing model).
When a .pacm file is imported, a new model is created from the file, so it's not possible to import data from .pacm file to an existing model.


Steps to import model:
Steps to import model:
Line 149: Line 167:


=== Exporting Model ===
=== Exporting Model ===
Models can be exported to a .pacm file (QPR ProcessAnalyzer compressed model file) to easily move models between QPR ProcessAnalyzer environments. The file contains all the eventlog data and also all model related settings. Steps to export:
# Navigate to the project where the model to be exported is located.
# Navigate to the project where the model to be exported is located.
# Open the '''Models''' tab and select the model.
# Open the '''Models''' tab and select the model.
Line 154: Line 173:


== Datatables ==
== Datatables ==
'''Datatables''' are used to store any tabular data in QPR ProcessAnalyzer. The data in datatables can be loaded into models by linking models to the datatables. Datatables can also be used as part of the ETL process to store intermediate results. Datatable names are unique within a project.
'''Datatables''' store tabular data in QPR ProcessAnalyzer. Datatables containing events and cases data, can be loaded into a model by selecting an events and cases datatable for the model. Datatables can also be used as part of the ETL process to store intermediate results. Datatables can be created, moved and deleted in the '''Datatables''' tab, which shows all datatables in the selected project.
 
Datatables can be stored internally in the QPR ProcessAnalyzer environment (they are called ''Local'' datatables). In addition, if the [[Snowflake Connection Configuration|Snowflake connection]] is available, datatables can be created to the Snowflake, which enables to create models that perform calculations in the Snowflake. Snowflake datatables can be distinguished in the Workspace by the snowflake icon (left of the datatable name). When a datatable is created, the datasource needs to be selected (either local or Snowflake), and after that managing the datatables, such as importing data, moving, renaming and deleting, works identically between the local or Snowflake datatables.


To create datatables, the global ''Create models'' permissions is needed (by default system administrators have it), and for deleting datatables, the project-specific ''Delete models'' permission is needed (by default projects administrators have it).
To create datatables, the global ''Create models'' permissions is needed (by default system administrators have it), and for deleting datatables, the project-specific ''Delete models'' permission is needed (by default projects administrators have it).


Data stored to datatables have the following limitations: Maximum number of columns in a datatable is '''300''', and maximum string length that can be stored into a datatable cell is '''4000''' characters.
Data stored to datatables have the following limitations: Datatable names are unique within a project. Maximum number of columns in a datatable is '''300''', and maximum string length that can be stored into a datatable cell is '''4000''' characters.
 
Datatables can be created, moved and deleted in the '''Datatables''' tab, which shows all datatables in the selected project.


=== Opening Datatable ===
=== Opening Datatable ===
Line 180: Line 199:
# On the left side projects hierarchy, select the project where you want to create a datatable.
# On the left side projects hierarchy, select the project where you want to create a datatable.
# Open the '''Datatables''' tab.
# Open the '''Datatables''' tab.
# Click the '''New''' button and click '''Datatable'''. Define a name for the datatable and click '''Create'''. Note that datatable names must be unique within a project.
# Click the '''New''' button and click '''Datatable'''.
# Define '''Name''' and '''Datasource''' for the datatable. Note that datatable names must be unique within a project. If the [[Snowflake Connection Configuration|Snowflake processing]] is available, datatables can be created to the Snowflake.
# Click '''Create'''.


=== Importing Data to Datatable from CSV File ===
=== Importing Data to Datatable from CSV File ===
Line 186: Line 207:
# Open the '''Datatables''' tab, and select the datatable where to import data.
# Open the '''Datatables''' tab, and select the datatable where to import data.
# Click the '''Import''' button, and select the CSV file to be imported.
# Click the '''Import''' button, and select the CSV file to be imported.
# Check the suggested data type and conversion settings for the columns, and adjust them if needed. You can import data to the existing datatable columns, new datatable columns, or ignore individual CSV file columns in the import (more information about [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]]).
# Check the suggested data type and conversion settings for the columns, and adjust them if needed. You can import data to the existing datatable columns, new datatable columns, or ignore individual CSV file columns in the import (see: [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]]).
# Click '''Start import'''.
# Click '''Start import'''.



Revision as of 21:36, 16 November 2022

In QPR ProcessAnalyzer, dashboards, models, datatables and scripts are organized into projects. Project Workspace shows all projects in a hierarchy (on the left side) and contents of the selected project (on the right side) divided into tabs based on the type of the entity. There are tabs for dashboards, models, datatables and scripts. Dashboards and datatables are described in this article and script are described in Managing Scripts.

The Project Workspace can be opened by clicking the QPR Software logo on top left, or in the Home screen by clicking the Workspace button. All actions, such as open, create, modify and delete, are available as buttons in the toolbar and also in the context menu, which can be opened by right clicking the target project, dashboard, datatable or script.

The projects hierarchy can be hidden by clicking the blue Collapse button in the top of the divider, to make more space for the contents table. If the Collapse button is not visible, hover the upper side of the divider with the mouse to make the button visible. To show the projects hierarchy again, click the grey Expand button on the top left of the screen.

There are the following requirements for names given to objects: it cannot be empty, maximum length is 440 characters, and it cannot contain the slash (/) character.

Projects

Projects are organized into a hierarchy, where projects can contain child projects. The hierarchy is visible in the left side of the workspace, where a project can be selected to see its contents on the right side. In addition, there is the Projects tab showing child projects of the selected project.

Workspace.png

Opening Project

Project can be opened in the workspace to see its contents, by clicking the project in the left side hierarchy. Alternatively the Projects tab can be used browse projects by drilling down into child projects by double-clicking projects.

Creating Project

  1. On the left side projects hierarchy, select the project where you want to create a new project.
  2. Click the New button and click Project.
  3. Define a name for the projects and click Create.

Deleting Project

  1. Either select a single project on the left side hierarchy (only one can be selected), or one or several projects in the Projects tab.
  2. Click the Delete button and click Delete for the confirmation message. (The deleted project goes to the recycle bin.)

Note that project cannot be deleted if the project or its child projects contain the currently selected model.

Renaming Project

  1. Select the project to be renamed either in the left side hierarchy or in the Projects tab.
  2. Click the Rename button.
  3. Change the project name in the opening dialog and click OK.

Moving Project

Projects can be moved by dragging them with a mouse from the Projects tab to a new parent project in the left side hierarchy. Projects can also be moved by selecting the project in the left side hierarchy or in the Projects tab, selecting the Move option in the context menu, and then selecting the new parent project in the opening list of projects.

Dashboards

Dashboards can be created, opened, moved, deleted, imported and exported in the Dashboards tab, which shows all dashboards in the selected project.

Opening Dashboard

  1. Select the project where the dashboard to be opened is located.
  2. Open the Dashboards tab.
  3. Double-click the dashboard in the list, or select the dashboard with a single click and click the Open button.

Creating Dashboard

  1. On the left side projects hierarchy, select the project where you want to create the dashboard.
  2. Open the Dashboards tab.
  3. Click the New button and click Dashboard. The dashboard designer opens.
  4. The dashboard can be named by opening the menu on the right and clicking Dashboard properties. The name can be defined in the General tab. The dialog can be closed by clicking the Done button.
  5. The dashboard is saved when clicking the Save button.

Deleting Dashboard

  1. Select the project where the dashboard(s) to be deleted are located.
  2. Open the Dashboards tab.
  3. Select one or several dashboards to be deleted.
  4. Click the Delete button and click Delete to the confirmation message.

Renaming Dashboard

  1. Select the project where the dashboard to be renamed is located.
  2. Open the Dashboards tab.
  3. Select the dashboard to be renamed.
  4. Click the Rename button.
  5. Change the dashboard name in the opening dialog and click OK.

Moving Dashboard

Dashboards can be moved by dragging them with a mouse from the right side list to the target project in the left side hierarchy. Alternatively, dashboards to be moved can be selected and from the context menu, select Move to and then select the target project.

Duplicating Dashboard

  1. Select the project where the dashboard to be duplicated is located.
  2. Open the Dashboards tab.
  3. Select the dashboard to be duplicated.
  4. Click the Duplicate button. A duplicate of the dashboard is created.

Importing Dashboard

Dashboards can be exported and imported as .qprpa files containing the dashboard structure, e.g. charts with their settings (data shown by the dashboard is not included). Dashboard file can be imported if it has been exported using same or earlier QPR ProcessAnalyzer version. If the dashboard was exported using later version, it might not be possible to import it, if the dashboard structure supported by QPR ProcessAnalyzer has been improved between the versions.

To import a dashboard:

  1. From the left side projects hierarchy select the project where you want to import the dashboard.
  2. Open the Dashboards tab.
  3. Click the New button, and select Import Dashboard.
  4. Select a .qprpa file to be imported.

Exporting Dashboard

  1. Navigate to the project where the dashboard to be exported is located.
  2. Open the Dashboards tab and select the dashboard.
  3. Click the Export button. The exported file can be downloaded.

Models

Models tab shows all models in the selected project. Models can be opened, created, edited, deleted, imported and exported (you can go through an end-to-end instructions how to create model from eventlog data from a CSV file).

Model status is important as in-memory processed models need to be online to use them on dashboards and run calculation on them. Model status is visible as an icon left of the model name, denoting whether the model is in the server memory or being loaded into memory. The memory capacity of the server limits how many models there can be in the memory at the same time. Also loading a model into memory might take a while depending the model size. Model is one of the following statuses:

  • Online: Model is currently in the memory and available to dashboards and analyses. Applicable only for in-memory models.
  • Offline: Model is currently not the memory (and thus it's not consuming any memory resources). Applicable only for in-memory models.
  • Loading: Model is currently being loaded into the memory. The loading needs to complete until the model can be used. Applicable only for in-memory models.
  • Snowflake: Model is a Snowflake stored model, and processing is done in the Snowflake. Thus the model will not be loaded into QPR ProcessAnalyzer memory and the model doesn't have any of the other statuses that are for in-memory models.

Note that in QPR ProcessAnalyzer, all processing is performed in the server/cloud side, so the model does not need to be loaded into user workstation, and thus it doesn't consume resources in the workstation side.

Opening Model

  1. Select the project where the model to be opened is located.
  2. Open the Models tab.
  3. Double-click the model in the list, or select the model with a single click and click the Open button. Model is opened in the Process Discovery view.

Editing Model Settings

Model level settings are organized into following dialogs: Properties (general settings), Attributes, Notifications and Business calendar. Most settings can be changed while the model is in the memory, but changing datasource related settings and attribute settings will drop the model from the memory. Steps to edit settings:

  1. Select the project where the model is located.
  2. Open the Models tab.
  3. Select the model and select one of the following options: Properties, Attributes, Notifications or Business Calendar (model level settings are organized into these dialogs).
  4. After viewing or editing properties, close the dialog by clicking OK.

See more about model level settings:

Note that Attributes, Notifications, Business calendar and Case level permissions are not available for Snowflake models.

Loading, Dropping and Reloading Model

This functionality is only available for in-memory models.

  1. Select the project where the model is located.
  2. Open the Models tab.
  3. Select the model and select one of the following options:
    • Load to start loading the model into memory. This option is available when the model is offline.
    • Drop to drop the model from the memory (for example to free memory resources). This option is available when the model is online or loading.
    • Reload to reload the model into the memory (i.e. drop and immediately start loading). Reloading is needed in order to get the latest data into the model after new data is imported to datatables. This option is available when the model is online or loading.

Creating Model

  1. On the left side projects hierarchy, select the project where you want to create the model.
  2. Open the Models tab.
  3. Click the New button and click Model. Define a name for the model and click Create. Note that model names must be unique within a project.

Deleting Model

When a model is deleted, it's not permanently removed, and can be recovered from the recycle bin. Note that possible datatables used by the deleted models, are not deleted. Note also that the currently selected model cannot be deleted.

Steps to delete models:

  1. Select the project where the model(s) to be deleted are located.
  2. Open the Models tab.
  3. Select one or several models to be deleted.
  4. Click the Delete button and click Delete to the confirmation message.

Renaming Model

  1. Select the project where the model to be renamed is located.
  2. Open the Models tab.
  3. Select the model to be renamed.
  4. Click the Rename button.
  5. Change the model name in the opening dialog and click OK.

Moving Model

Models can be moved by dragging them with a mouse from the right side list to the target project in the left side hierarchy. Alternatively, models to be moved can be selected, from the context menu select Move to and then select the target project.

Duplicating Model

When a model is duplicated, datatables that are possibly used by the model, are not duplicated so the duplicate model will refer to the same datatables as the original model (datatables can be duplicated separately if desired). Steps to duplicate a model:

  1. Select the project where the model to be duplicated is located.
  2. Open the Models tab.
  3. Select the model to be duplicated.
  4. Click the Duplicate button. A duplicate of the model is created.

Importing Model

When a .pacm file is imported, a new model is created from the file, so it's not possible to import data from .pacm file to an existing model.

Steps to import model:

  1. From the left side projects hierarchy select the project where you want to import the model.
  2. Open the Models tab.
  3. Click the New button, and select Import Model.
  4. Select a .pacm file to be imported.

Exporting Model

Models can be exported to a .pacm file (QPR ProcessAnalyzer compressed model file) to easily move models between QPR ProcessAnalyzer environments. The file contains all the eventlog data and also all model related settings. Steps to export:

  1. Navigate to the project where the model to be exported is located.
  2. Open the Models tab and select the model.
  3. Click the Export button. The exported file can be downloaded.

Datatables

Datatables store tabular data in QPR ProcessAnalyzer. Datatables containing events and cases data, can be loaded into a model by selecting an events and cases datatable for the model. Datatables can also be used as part of the ETL process to store intermediate results. Datatables can be created, moved and deleted in the Datatables tab, which shows all datatables in the selected project.

Datatables can be stored internally in the QPR ProcessAnalyzer environment (they are called Local datatables). In addition, if the Snowflake connection is available, datatables can be created to the Snowflake, which enables to create models that perform calculations in the Snowflake. Snowflake datatables can be distinguished in the Workspace by the snowflake icon (left of the datatable name). When a datatable is created, the datasource needs to be selected (either local or Snowflake), and after that managing the datatables, such as importing data, moving, renaming and deleting, works identically between the local or Snowflake datatables.

To create datatables, the global Create models permissions is needed (by default system administrators have it), and for deleting datatables, the project-specific Delete models permission is needed (by default projects administrators have it).

Data stored to datatables have the following limitations: Datatable names are unique within a project. Maximum number of columns in a datatable is 300, and maximum string length that can be stored into a datatable cell is 4000 characters.

Opening Datatable

Datatable contents can be viewed as follows:

  1. On the left side projects hierarchy, select the project where the datatable to be opened is located.
  2. Open the Datatables tab.
  3. Double-click the datatable in the list, or select the datatable with a single click and click the Open button.
  4. If you want to change the shown information, click the Settings button and edit the settings.
  5. The dialog can be closed by clicking Close button.

Following settings are available:

  • Visible columns can be removed and changed in the Columns tab.
  • Number of shows row can be changed.
  • Sorting of the data can be changed.
  • Dimensioning can be taken into use which will show the Measures tab (for more information, see the chart.
  • Datatable can be exported as an .xlsx or .csv file.

Creating Datatable

  1. On the left side projects hierarchy, select the project where you want to create a datatable.
  2. Open the Datatables tab.
  3. Click the New button and click Datatable.
  4. Define Name and Datasource for the datatable. Note that datatable names must be unique within a project. If the Snowflake processing is available, datatables can be created to the Snowflake.
  5. Click Create.

Importing Data to Datatable from CSV File

  1. On the left side projects hierarchy, select the project where the target datatable is located.
  2. Open the Datatables tab, and select the datatable where to import data.
  3. Click the Import button, and select the CSV file to be imported.
  4. Check the suggested data type and conversion settings for the columns, and adjust them if needed. You can import data to the existing datatable columns, new datatable columns, or ignore individual CSV file columns in the import (see: CSV file import).
  5. Click Start import.

Deleting Datatable

  1. Select the project where the datatable(s) to be deleted are located.
  2. Open the Datatables tab.
  3. Select one or several datatables to be deleted.
  4. Click the Delete button and click Delete to the confirmation message.

Renaming Datatable

  1. Select the project where the datatable to be renamed is located.
  2. Open the Datatables tab.
  3. Select the datatable to be renamed.
  4. Click the Rename button.
  5. Change the datatable name in the opening dialog and click OK.

Moving Datatable

Datatables can be moved by dragging them with a mouse from the right side list to the target project in the left side hierarchy. Alternatively, datatables to be moved can be selected, from the context menu select Move to and then select the target project.

Duplicating Datatable

Datatable duplication (copying) creates a full copy of the datatable where also the data contents is duplicated. If the datatable contains lot of data, duplicating the data might take some time. Copying the data from the original datatable to the new datatable is performed in the background, so the user doesn't need to wait for it. Note that during the data copying, the workspace might temporarily show that the new datatable has less rows than the original.

  1. Select the project where the datatable to be duplicated is located.
  2. Open the Datatables tab.
  3. Select the datatable to be duplicated.
  4. Click the Duplicate button. A duplicate of the datatable is created.

Recycle Bin

Deleted projects and models go to the Recycle bin, where they can be either deleted forever or restored. Purpose of the recycle bin is that accidentally deleted items can still be restored. Note that currently dashboards and scripts don't go to the recycle bin, but they are deleted forever right away. Note also that when a project is deleted (moved to the recycle bin), also models in the project appear in the recycle bin.

Only the system administrators can see the recycle bin, and delete forever and restore items from there.

Emptying Recycle Bin

  1. Click Bin in the left side projects hierarchy.
  2. Click the Empty bin button on top right.
  3. Click Delete forever for the confirmation dialog.

Deleting Items Forever

  1. Click Bin in the left side projects hierarchy.
  2. Select items in the recycle bin that you want to delete forever.
  3. Click the Delete forever button.
  4. Click Delete forever for the confirmation dialog.

Restoring Items

  1. Click Bin in the left side projects hierarchy.
  2. Select items in the recycle bin that you want to restore.
  3. Click the Restore button. (Selected items are restored to their original locations.)