Abonnieren

UiPath Insights

Das UiPath Insights-Handbuch

Automation Hub-Datenmodell

Begriffe und Konzepte


Die Struktur des Automation Hub-Datenmodells basiert auf den folgenden Konzepten:

ConceptDescription
Explore The starting point for exploration.

The data is surfaced via Explores, which you can think of as a general entity that corresponds to the fields within it.

For example, to build dashboards around the Automation Hub data, pick Automation Ideas or Idea Ageing Explores first and the fields containing the needed information and choose the proper visualization in order to display the results.
View A view represents a table of data, whether that table is native to your database or was created using Looker’s derived table functionality.

Within each view are field definitions, each of which typically corresponds to a column in the underlying table or a calculation in Looker.
Dimension As part of a View within the Explore, the Dimension is a groupable field and can be used to filter query results.

It can be one of the following:
An attribute, which has a direct association to a column in an underlying table.
A fact or numerical value.
A derived value computed based on the values of other fields in a single row.
Measure As part of a View within the Explore, the Measure parameter declares a new measure (aggregation) and specifies a name for that measure.

Examples of measures types: average, count, date, max, sum.
Custom Fields Custom Dimension
Custom Measure
Table calculation

Start from scratch or use existing Dimensions and Measures to create new fields in the Data Model. Perform enhancements and data transformations by using formulas, filters, sorts.

ALTERUNGSVERLAUF


ALTERUNGSVERLAUF

DimensionDescription
Autogenerated-IDUnique ID generated when creating the idea in Automation Hub
Is Current Phase Status (Yes / No)Indicates whether the phase & status combination is the current one for the idea
Last Change TimeTime the idea was updated to the indicated phase & status
Repeated Phase & Status (Yes / No) Indicates whether the idea was in the indicated phase & status combination before.
In case the idea was in the indicated phase & status before, the information around the timestamp and the time spent on that phase & status before are not exposed in the data model.
Time in Phase StatusTime spent by the idea in the indicated phase & status
MeasureDescription
CountCount of ideas corresponding to the selected idea ageing filters

ALTERUNGSVERLAUF-Phase

DimensionDescription
Phase is ActiveShowing if the Phases are in use or not:
1 active
2 inactive
Phase NamePhase Name as displayed in the user interface
Phase OrderPhase Order in the idea's lifecyle
MeasureDescription
CountTotal number of times the phase appears for the selected pool of ideas

ALTERUNGSVERLAUF Status

DimensionDescription
Phase Status is ActiveShowing if the Statuses are in use or not:
1 active
2 inactive
Status NamePhase Status name as displayed in the user interface
Status OrderPhase Status order
MeasureDescription
CountTotal number of times the status appears for the selected pool of ideas

AGING HISTORY-Benutzer – Autor ändern

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last LoginUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

KOMPONENTE


KOMPONENTE – ALLE

DimensionDescription
Average of ReviewsAverage of the ratings given by the reviewers
BenefitsBenefits of the component
CompatibilityVersions of the products added as dependencies of the component
Component URLURL of the component
Creation DateDate when the component was created
DependenciesDependencies of the component
DescriptionDescription of the component, as defined by the author
Is Active (Yes / No)Showing if the component is deleted or not (Yes = component is not deleted, No = component was deleted)
NameName of the component, as defined by the author
Number of ApplicationsNumber of applications referenced to be used by the component
Number of CategoriesNumber of categories for which the component is available
Number of CommentsNumber of comments added in the component’s profile
Number of ManualsNumber of manuals uploaded by the author in the component profile
Number of Media FilesNumber of media files uploaded by the author in the component profile
Number of ReviewsNumber of reviews added by the users who downloaded the component
SlugComponent’s slug used to construct the URL. It is unique, auto-generated from the name of the component.
SummarySummary of the component, as defined by the author
TypeType of component: custom activity, snippet, workflow template, connector, dashboard, ML model, solution
MeasureDescription
CountTotal number of components

COMPONENT-Anwendungen

DimensionDescription
Application Full NameConcatenation of the application name, version and language for easier search
Application LanguageLanguage of the application as defined in the Application Inventory
Application NameName of the application as defined in the Application Inventory
Application VersionVersion of the application as defined in the Application Inventory

COMPONENT-Kategorien

DimensionDescription
Category Creation DateDate when the Category was created
Category Level NameDefault name “Business Area“ - can be customized in the user interface - find here the latest name
Category NameBusiness area name
Category Order NumberThe order in which the categories are displayed in the Automation Hub user interface

COMPONENT-Benutzer – Autor

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last LoginUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

COMPONENT-Benutzer – Kurator

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last LoginUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

COMPONENT-Benutzer – Updater

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last LoginUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

COMPONENT-Versionen

DimensionDescription
Number of DownloadsNumber of component downloads performed by the users
StatusStatus of the component's version
VersionVersion number for the component
Version Creation DateDate when the component's version was created
Version Last Update DateDate when the component's version was last updated
Version Publication DateDate when the component's version was published
MeasureDimension
CountCount of component's versions

Idee


Idee

DimensionDescription
Auto-generated ID Unique ID assigned to each idea, in the Tenant DataBase.
Creation DateIdea Creation Date. Can be different than the Submission date, in case of ideas saved of draft first.
Idea Name Idea Name, as defined in the field Automation Name.
Idea Slug Idea's slug used to construct Idea URL. It is unique.
Idea SourceThe source type.
Idea URLURL of the idea.
Last Update DateLast idea update - can be a change in the Phase, Status, details in the automation profile, Cost-Benefit Analysis, documentation.
Priority Idea's Priority
Submission DateIdea Submission Date
MeasureDescription
CountTotal number of submitted Ideas

IDEA-Anwendungen

DimensionDescription
Application Full NameConcatenation of the application name, version and language for easier search
Application LanguageLanguage of the application as defined in the Application Inventory
Application NameName of the application as defined in the Application Inventory
Application VersionVersion of the application as defined in the Application Inventory

IDEA-Kategorie – Ebene 1

DimensionDescription
Category Creation DateDate when the Category was created
Category Level Name Default name “Business Area“ - can be customized in the user interface - find here the latest name
Category Name Business area name
Category Order Number The order in which the categories are displayed in the Automation Hub user interface
MeasureDescription
Count Total number of categories on Level 1

IDEA-Kategorie – Ebene 2

DimensionDescription
Category Creation DateDate when the Category was created
Category Level Name Default name “Category“ - can be customized in the user interface - find here the latest name
Category Name Category name
Category Order Number The order in which the categories are displayed in the Automation Hub user interface
MeasureDescription
Count Total number of categories on Level 2

IDEA-Kategorie – Ebene 3

DimensionDescription
Category Creation DateDate when the Sub-category was created
Category Level Name Default name “Sub-category“ - can be customized in the user interface - find here the latest name
Category Name Sub-category name
Category Order Number The order in which the categories are displayed in the Automation Hub user interface
MeasureDescription
Count Total number of categories on Level 3

IDEA-Kategorie – Ebene 4

DimensionDescription
Category Creation DateDate when the Sub-category was created
Category Level Name Default name “Sub-category“ - can be customized in the user interface - find here the latest name
Category Name Sub-category name
Category Order Number The order in which the categories are displayed in the Automation Hub user interface
MeasureDescription
Count Total number of categories on Level 4

IDEA-Kategorie – Stufe 5

DimensionDescription
Category Creation DateDate when the Sub-category was created
Category Level Name Default name “Sub-category“ - can be customized in the user interface - find here the latest name
Category Name Sub-category name
Category Order Number The order in which the categories are displayed in the Automation Hub user interface
MeasureDescription
Count Total number of categories on Level 5

Ideenphase

DimensionDescription
Phase is Active Showing if the Phases are in use or not:
1 active
2 inactive
Phase Name Phase Name as displayed in the user interface
Phase Order Phase Order in the idea's lifecyle
MeasureDescription
Count Total number of times the phase appears for the selected pool of ideas

IDEA – Fragen und Antworten – Alle Typen

DimensionDescription
Answer Data Type The Answer's data type
Answer Display Value The Answer value as displayed in the Automation Hub user interface
Answer Raw Value The Answer's backing raw value as stored in Automation Hub
Creation DateDate when the Answer was submitted
Last Update DateDate when the Answer was updated
Question Assessment Source This will indicate the type of Assessment the question belongs to (Overview, high-level assessment etc.)
Question Key The unique identifier of a Question of type date, corresponding to the Variable name in the user interface. Title is not guaranteed to be unique.
Question Title The Question Title as configured in the Assessment
MeasureDescription
CountCount of unique answers

IDEA – Q&As – DateTime-Typen

DimensionDescription
Answer Display ValueThe Answer value as displayed in the Automation Hub user interface
Answer Raw ValueThe Answer's backing raw value as stored in Automation Hub
Answer (DateTime) DateThe Answer converted to a DateTime value
Creation DateDate when the Answer was submitted
Last Update DateDate when the Answer was updated
Question Assessment SourceThis will indicate the type of Assessment the question belongs to (Overview, high-level assessment etc.)
Question KeyThe unique identifier of a Question, corresponding to the Variable name in the user interface. Title is not guaranteed to be unique.
Question TitleThe Question Title as configured in the Assessment
MeasureDescription
CountCount of unique answers
Max DateMaximum date from the answers of date-type questions
Min DateMinimum date from the answers of date-type questions

IDEA – Q&As – Standardvorteile

MeasuresDescription
CountCount of unique answers
Currency saved / year per Company (Final)Estimated benefit per company, measured in currency/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
Currency saved / year per Company (Initial)Estimated benefit per company, measured in currency/year, from the Detailed assessment
Currency saved / year per Company (Revised)Estimated benefit per company, measured in currency/year, from the Cost-Benefit Analysis page (in case of updates in it)
Currency saved / year per Employee (Final)Estimated benefit per employee, measured in currency/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
Currency saved / year per Employee (Initial)Estimated benefit per employee, measured in currency/year, from the Detailed assessment
Currency saved / year per Employee (Revised)Estimated benefit per employee, measured in hours saved/year, from the Cost-Benefit Analysis page (in case of updates in it)
FTEs saved / year per Company (Final)Estimated benefit per company, measured in FTEs/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
FTEs saved / year per Company (Initial)Estimated benefit per company, measured in FTEs/year, from the Detailed assessment
FTEs saved / year per Company (Revised)Estimated benefit per company, measured in FTEs/year, from the Cost-Benefit Analysis page (in case of updates in it)
FTEs saved / year per Employee (Final)Estimated benefit per employee, measured in FTEs/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
FTEs saved / year per Employee (Initial)Estimated benefit per employee, measured in FTEs/year, from the Detailed assessment
FTEs saved / year per Employee (Revised)Estimated benefit per company, measured in hours saved/year, from the Cost-Benefit Analysis page (in case of updates in it)
Hours saved / year per Company (Final)Estimated benefit per company, measured in hours saved/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
Hours saved / year per Company (Initial)Estimated benefit per company, measured in hours saved/year, from the Detailed assessment
Hours saved / year per Company (Revised)Estimated benefit per company, measured in hours saved/year, from the Cost-Benefit Analysis page (in case of updates in it)
Hours saved / year per Employee (Final)Estimated benefit per employee, measured in hours saved/year. Revised value from Cost Benefit Analysis takes precedence (if set) over the value from Detailed Assessment
Hours saved / year per Employee (Initial)Estimated benefit per employee, measured in hours saved/year, from the Detailed assessment
Hours saved / year per Employee (Revised)Estimated benefit per employee, measured in hours saved/year, from the Cost-Benefit Analysis page (in case of updates in it)

IDEA – Q&As – Numerische Typen

DimensionDescription
Answer Display ValueThe Answer value as displayed in the Automation Hub user interface
Answer Raw ValueThe Answer's backing raw value as stored in Automation Hub
Creation DateDate when the Answer was submitted
Last Update DateDate when the Answer was updated
Question Assessment SourceThis will indicate the type of Assessment the question belongs to (Overview, high-level assessment etc.)
Question KeyThe unique identifier of a Question of type numerical or percentage, corresponding to the Variable name in the user interface. Title is not guaranteed to be unique.
Question TitleThe Question Title as configured in the Assessment
MeasureDescription
AverageUnder the Average measure, we average all the answers from the various questions of type numerical and/or percentage - this requires additional filtering
CountUnder the Count measure, we count all the answers from the various questions of type numerical and/or percentage - this requires additional filtering
SumUnder the Sum measure, we sum up all the answers from the various questions of type numerical and/or percentage - this requires additional filtering

IDEA-Status

DimensionDescription
Phase Status is Active Showing if the Statuses are in use or not:
1 active
2 inactive
Status Name Phase Status name as displayed in the user interface
Status Order Phase Status order
MeasureDescription
Count Total number of times the status appears for the selected pool of ideas

Ideen-Tags

DimensionDescription
Tag Name List with all the Tags created. When associated with an Idea Name, reflects the tags applied for the idea.
MeasureDescription
Count Total number of tags used; Can be filtered by ideas

IDEA-Benutzer – Prozessinhaber

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last LoginUser's Last Login
Last Name User’s Last Name
Last UpdateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

IDEA-Benutzer – Einreicher

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted User User is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last Login DateUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

Metadata


METADATA – Neueste Datenaktualisierung

DimensionDescription
Last Data Refresh Date DateDate when the Automation Hub data was refreshed last in the Insights application

BENUTZER


BENUTZER – Alle Benutzer

DimensionDescription
Active User User is active:
1 (Active)
0 (Inactive)
3 (Deleted)
Business Unit User’s Business Unit
Creation DateUser’s Creation Date
Deleted UserUser is deleted:
1 (Deleted)
0 (Not Deleted)
Department User’s Department
Email User's email address
First Name User’s First Name
Invite Status User’s invite status:
3 (Active)
1 (Pending)
0 (Inactive)
Job Title User's Job Title
Last Login DateUser's Last Login
Last Name User’s Last Name
Last Update DateLast update/change on user's profile
Location User's Location
MeasureDescription
Automations Total number of Automation Ideas submitted by the user; A submitter can have more than one idea submitted
Collaborations Total number of Automation Ideas where the user is assigned as a collaborator
Components Total number of Components uploaded by the user
Count Total number of users
Documents Total number of Documents uploaded by the user
Following Total number of Ideas followed by the user

Automation Hub-Explores


Es gibt 2 Automation Hub-Explores – Automation Ideas und Idea Ageing, die jeweils Zugriff auf eine Reihe von Ansichten bieten:

Automation IdeasIdea Ageing
AGEING HISTORY
AGEING HISTORY Phase
AGEING HISTORY Status
AGEING HISTORY Users - Change Author
IDEA
IDEA Applications
IDEA Category - Level 1
IDEA Category - Level 2
IDEA Category - Level 3
IDEA Category - Level 4
IDEA Category - Level 5
IDEA Phase
IDEA Q&As - All Types
IDEA Q&As - DateTime Types
IDEA Q&As - Default Benefits
IDEA Q&As - Numerical Types
IDEA Status
IDEA Tags
IDEA Users - Process Owner
IDEA Users - Submitter
METADATA - Latest Data Refresh
USERS - All Users
AGEING HISTORY
AGEING HISTORY Phase
AGEING HISTORY Status
AGEING HISTORY Users - Change Author
IDEA
IDEA Category - Level 1
IDEA Category - Level 2
IDEA Category - Level 3
IDEA Category - Level 4
IDEA Category - Level 5
IDEA Tags
METADATA - Latest Data Refresh

Ähnliche Artikel


Measure types

Aktualisiert vor 3 Monaten


Automation Hub-Datenmodell


Auf API-Referenzseiten sind Änderungsvorschläge beschränkt

Sie können nur Änderungen an dem Textkörperinhalt von Markdown, aber nicht an der API-Spezifikation vorschlagen.