QPR ProcessAnalyzer Project Workspace: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 97: Line 97:
# 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 a name for the datatable and click '''Create'''. Note that datatable names must be unique within a project.


=== Importing Data from CSV File to Datatable (available in 2021.6) ===
=== Importing Data to Datatable from CSV File (available in 2021.6) ===
# On the left side projects hierarchy, select the project where the target datatable is located.
# On the left side projects hierarchy, select the project where the target datatable is located.
# Open the '''Datatables''' tab.
# Open the '''Datatables''' tab, and select the datatable where to import data.
# Select the datatable where to import data.
# Click the '''Import''' button, and select the CSV file to be imported.
# Click the '''Import''' button.
# 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 Datatables|CSV file importing]]).
# Select the CSV file to be imported
# Check the data type and conversion settings. You can import data to new datatable columns, existing datatable columns or ignore CSV file columns (more information about the [[Importing Data to Datatables|CSV file importing]]).
# Click '''Start import'''.
# Click '''Start import'''.



Revision as of 23:01, 21 June 2021

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, datatables and scripts (and in future also for models). Dashboards and datatables are described in this page 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 that can be performed to the entities (e.g. open, modify, 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.

Projects

Workspace.png

Creating Project

  1. On the left side projects hierarchy, select the project where you want to create a project.
  2. Click the New button and click either 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 (and optionally other objects depending on which tab is open) on the right side list.
  2. Click the Delete button and click Delete for the confirmation message. (The deleted project goes to the recycle bin.)

Renaming Project

  1. Select the project to be renamed (either in the left side hierarchy or in the right side table).
  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 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.

Dashboards

Dashboards can be created, opened, moved, deleted, imported and exported in the Dashboards tab, which shows all dashboard 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.

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

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.

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.

Datatables can be created, moved and deleted in the Datatables tab, which shows all datatables in the selected project.

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. Define a name for the datatable and click Create. Note that datatable names must be unique within a project.

Importing Data to Datatable from CSV File (available in 2021.6)

  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 (more information about CSV file importing).
  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.

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