Operators (alphabetical overview)
The following is a table listing all operators available in the TIS Editor with the following columns.
Title: English name of the operator
Translation: German name of the operator
Class: Classification of the operator
Internal: Internal name of the operator
Version: Current version of the operator
TotalUsage: Total number of applications of the operator
Status: Status of the documentation of the operator
| Title | Translation | Class | Internal | Version | TotalUsage | Status | Assembly |
|---|---|---|---|---|---|---|---|
| Absence rate | Abwesenheitsquote | Absence2 | 2 | 0 | done | cc.Forecast | |
| ACD cache import | Daten-Cache Import | ImportFromDataCache | 0 | 0 | deprecated | cc.Tools | |
| ACD import | ACD import | GenericACDImport | 0 | 0 | interflex spx | cc.Tools | |
| Analyze text pattern | Textmuster analysieren | AnalyzeTextPattern | 0 | 0 | done | XimesData | |
| As a percentage 4.0 | In Prozent 4.0 | calc | OpPercentageOf4 | 4 | 255 | done | xi.OpMisc |
| Calculate Min/Max | Min/Max ermitteln | MinMaxCalculation | 1 | 49 | done | ccr.Tools | |
| Chart: 2D Map (Pivot start table) | Diagramm: Landkarte 2D (Ausgangstabelle Pivot) | plot | GraphGanttMapCat | 0 | 12 | done | XimesData |
| Chart: 2D Map (Start table list) | Diagramm: Landkarte 2D (Ausgangstabelle Liste) | plot | GraphGanttMap | 2 | 203 | done | XimesData |
| Chart: Gantt 2D | Diagramm: Gantt 2D | plot | GraphGanttNormal | 0 | 87 | done | XimesData |
| Chart: Histogram | Diagramm: Histogramm | plot | GraphHistogram1 | 2 | 0 | done | XimesData |
| Chart: Histogram Time Pattern | Diagramm: Histogramm Zeitraster | plot | GraphHistogramPattern1 | 1 | 0 | done | XimesData |
| Chart: Standard types 2.0 | Diagramm: Standarddiagramme 2.0 | plot | OpGraph | 2 | 0 | done | XimesData |
| Chart: XY Scatter | Diagramm: Punkt (XY) | plot | GraphXYScatter | 0 | 119 | done | XimesData |
| Collect report data 2.0 | Reportdaten sammeln 2.0 | OpHtmlReport2 | 2 | 142 | deprecated | xi.OpMisc | |
| Combine columns | Spalten zusammenfassen | ColumnMerge | 0 | 154 | done | ccr.Tools | |
| Conversion "String -> Date 2.0" | Umwandlung "String -> Datum 2.0" | ConvStr2Date2 | 2 | 0 | done | xir.OpMisc | |
| Conversion "String -> Double" | Umwandlung "String -> Double" | ConvStr2Dbl | 1 | 20 | done | xir.OpMisc | |
| Conversion of time pattern | Zeitrasterkonvertierung | Time Raster Conversion 2 | 2 | 0 | interflex | cc.Tools | |
| Convert "Date/Time" | Umwandlung "Datum/Uhrzeit" | ConversionDateTimeToEvents | 1 | 0 | done | XimesData | |
| Convert "From-Date/From-Time/To-Time" 2.0 | Umwandlung "Datum/Von-Uhrzeit/Bis-Uhrzeit" | ConversionDateTimeTimeToDuration2 | 2 | 46 | done | XimesData | |
| Copy or delete TIS tables | TIS Tabellen kopieren oder löschen | PersistenceCopy | 1 | 0 | done | xir.OpMisc | |
| Create pivot table 5.0 | Pivottabelle erstellen 5.0 | data | OpPivot5 | 5 | 579 | done | xir.OpMisc |
| Create Pivot Table V5 | Pivottabelle erstellen V5 | data | Merge Queue Data 5 | 5 | 579 | delete deprecated | cc.Forecast |
| Create table | Tabelle erzeugen | create | Table Creator | 1 | 2069 | done | ccr.Tools |
| Cut values | Werte schneiden | CutValues | 0 | 105 | done | XimesData | |
| Day or week profiles 2.0 | Tages- oder Wochenprofile 2.0 | OpProfile2 | 2 | 4 | done | xir.Forecast | |
| Delete columns | Spalten löschen | table | DeleteColumns1 | 1 | 5865 | deprecated | XimesData |
| Delete columns 2.0 | Spalten löschen 2.0 | table | DeleteColumns2 | 2 | 5865 | done | XimesData |
| Delete duplicated data records | Doppelte Datensätze löschen | Double Entries Eliminate | 1 | 0 | done | xi.OpExternal | |
| Delete duplicated data records 2.0 | Doppelte Datensätze löschen 2.0 | EliminateDoubleEntries2 | 2 | 0 | done | xir.OpExternal | |
| Delete rows 2.0 | Zeilen löschen 2.0 | DeleteRows2 | 2 | 547 | done | XimesData | |
| Distribution | Verteilung | AggregationXimes | - | - | interflex | ccr.Forecast | |
| Edit table (Interflex) | Tabelle bearbeiten | Table Editor 3 | 3 | 22 | done | ccr.Tools | |
| Edit TIS Table 3.0 | Tabelle bearbeiten | OpEditTable | 3 | 22 | done | ||
| Edit TIS Table 4.0 | Edit TIS Table 4.0 | OpEditTable4 | 4 | done | xir.OpMisc | ||
| Encrypt text | Text verschlüsseln | SimpleEncoding | 2 | 0 | done | xi.OpExternal | |
| Export to an ODBC Data Source | Export in eine ODBC-Datenquelle | Odbc Export Operator | 0 | 0 | done | cc.Tools | |
| Export to CSV file (server file system) 2.0 | Export in CSV Datei (Serverdateisystem) 2.0 | action | CSVExpGT2 | 2 | 22 | deprecated | xi.OpMisc |
| Export to CSV file (server file system) 3.0 | Export in CSV Datei (Serverdateisystem) 3.0 | action | CSVExpGT3 | 3 | 22 | done | xir.OpMisc |
| Export to CSV file (TIS file system) 2.0 | Export in CSV Datei (TIS-Dateisystem) 2.0 | action | CSVExpTIS | 2 | 33 | deprecated | xi.OpMisc |
| Export to CSV file (TIS file system) 3.0 | Export in CSV Datei (TIS-Dateisystem) 3.0 | action | CSVExpTIS2 | 3 | 33 | done | xir.OpMisc |
| Export to SQL database | Export in SQL Datenbank (oracle,postgresql,mssql) | export | OpExportToSql | 1.0 | ? | in progress | xi.OpMisc |
| Filter on columns 1.1 | Filter auf Spalten 1.1 | data | XFilterGT3 | 3 | 3514 | deprecated | xi.OpMisc |
| Filter on columns 1.2 | Filter auf Spalten 1.2 | data | XFilterGT4 | 4 | 3514 | done | xir.OpMisc |
| Format columns 2.0 | Spalten formatieren 2.0 | OpColsFormatInfo2 | 2 | 362 | done | xi.OpMisc | |
| Format columns 3.0 | Spalten formatieren 3.0 | OpColsFormatInfo3 | 3 | 0 | editing | xir.OpMisc | |
| Format columns of 'Editable Grid' 1.0 | Spalten einer 'Editierbaren Datentabelle' formatieren 1.0 | OpColsFormatEditableGrid | 0 | 0 | deprecated | xi.OpMisc | |
| Formula interpreter 3.1 | Formelinterpreter 3.1 | FormulaInterpreter | 3.1 | 0 | deprecated | xi.OpMisc | |
| Formula operator (row-by-row) (4.0) = Formeloperator | Formeloperator (zeilenweise) (4.0) | Rowwise CSharp Operator 4 | 4 | 20271 | deprecated | cc.CSharp | |
| Formula operator (row-by-row) (5.0) | Formeloperator (zeilenweise) (5.0) | Rowwise CSharp Operator 5 | 5 | - | done | cc.CSharp | |
| Freeze columns 3.0 | Spalten einfrieren 3.0 | FreezeColumns3 | 3 | 180 | done | xi.OpMisc | |
| General calendar | Allgemeiner Kalender | Generic Calendar 2 | 2 | 807 | done | cc.Tools | |
| Generate shifts | Schichten generieren | ShiftGeneration1 | 1 | 0 | deprecated | xi.OpMisc | |
| Generate shifts 2.0 | Schichten generieren 2 | ShiftGeneration2 | 1 | 0 | requires opa licence | xi.OpMisc | |
| Identifier filter | Identifizierer Filter | OpFilterIdentifier1 | 1 | 0 | done | xir.OpMisc | |
| Identifier instances | Identifizierer Ausprägungen | FilterIdentifier | 1 | 0 | deprecated | XimesData | |
| Identifier instances 2.0 | Identifizierer Ausprägungen | FilterIdentifier | 2 | 0 | done | XimesData | |
| Import data from SQL sources with query file | Importieren von Daten aus SQL-Quellen mit Abfrage-Datei | import | SQLDataImportFile1 | 0 | done | xir.OpMisc | |
| Import from Excel file | Import aus Excel Datei | import | OpImportFromExcel1 | 3 | - | done | xi.OpMisc |
| Import text or CSV file with automatic column assignment since 5.* | Import Text- bzw. CSV-Datei mit automatischer Spaltenzuordnung seit Version 5.* | import | OpImportFromCsvFileAutoMapping | 4 | 219 | done | xir.OpMisc |
| Import text or CSV file with automatic column assignment up to 5.* | Import Text- bzw. CSV-Datei mit automatischer Spaltenzuordnung bis zu Version 5.* | import | OpImportFromCsvFileAutoMapping | 3 | 219 | done | xi.OpMisc |
| Import text or CSV file with manual column assignment 3.0 | Import Text- bzw. CSV-Datei mit manueller Spaltenzuordnung 3.0 | import | ImportFromCsvFile3 | 3 | 219 | deprecated | xi.OpMisc |
| Import text or CSV file with manual column assignment 4.0 | Import Text- bzw. CSV-Datei mit manueller Spaltenzuordnung 4.0 | import | ImportFromCsvFile4 | 4 | 219 | done | xir.OpMisc |
| Import text or CSV file with manual column assignment 5.0 | Import Text- bzw. CSV-Datei mit manueller Spaltenzuordnung 5.0 | import | ImportFromCsvFile5 | 5 | 0 | editing | xir.OpMisc |
| Importing data from SQL sources 5.0 | Importieren von Daten aus SQL-Quellen 5.0 | import | SQLImport | 5 | 0 | prio 1 editing | xi.OpMisc |
| Length operator | Zeitintervall innerhalb einer Zeile | calc | OpCalcLength | 0 | 95 | done | xi.OpMisc |
| Link to calendar | Verknüpfen mit Kalender | Calendar1 | 1 | 343 | done | XimesData | |
| Link with value table | Verknüpfung mit Wertetabelle | Add Values | 0 | 0 | done | cc.Tools | |
| Load table from persistence | Tabelle aus Persistenz laden | Load Table | 0 | 0 | interflex spx | cc.Persistence | |
| Merge data 5.0 | Daten zusammenfassen 5.0 | table | MergeData5 | 5 | 1722 | done | XimesData |
| Merge data with time relations | Daten zusammenfassen mit Zeitrelationen | table | MergeTime | done | XimesData | ||
| Missing/overlapping time intervals 2.0 | Fehlende/Überlappende Zeitintervalle | OpTimeIntervals2 | 2 | 6 | done | xir.OpMisc | |
| Mix columns | Spalten mischen | MergeDataSources | 0 | 0 | interflex | cc.Tools | |
| Normalizing (date) | Normierung (Datum) | ExStandardization | 2 | 0 | interflex | cc.Tools | |
| Normalizing (time of day) | Normierung (Tageszeit) | ExStandardizationDayTime | 2 | 0 | interflex | cc.Tools | |
| Optimizer: Sequence Simple | Optimierer: Sequence Simple | OptSequenceSimple | 0 | 7 | deprecated | xi.OpMisc | |
| Pivot table | Kreuztabelle | table | PivotNumbers | 0 | 12 | done | XimesData |
| Pivot table time x weekdays 2.0 | Pivottabelle Uhrzeit x Wochentage 2.0 | data | PivotWeekday2 | 2 | 174 | done | xi.OpMisc |
| Python scripting | Python Scripting | program | OpPyCreateTable | 1 | editing | xi.OpScripting | |
| Python scripting (with input table) 2.0 | Python Scripting (mit Eingabetabelle) 2.0 | program | OpPyScripting2 | 2 | editing | xir.OpScripting | |
| Python scripting - with input table | Python Scripting (mit Eingabetabelle) | program | OpPyScripting | 1 | xir.OpScripting | ||
| Read information of TIS table 3.0 | TIS Tabelleninformation lesen 3.0 | PersistenceInfo | 3 | 1 | done | xi.OpMisc | |
| Read Redis keys | Redis Keys lesen | RedisRead1 | 1 | 5 | done | xi.OpMisc | |
| Read TIS resources | TIS Resourcen auslesen | OpGetResources1 | 0 | 0 | done | xir.OpMisc | |
| Read TIS Table 8.0 | TIS Tabelle lesen 8.0 | import | PersistenceRead8 | 8 | 0 | done | xir.OpMisc |
| Recalculate data nodes 1.0 | Datenknoten neu berechnen 1.0 | OpReCalcWithInputTable | 1 | done | xir.OpMisc | ||
| Regression analysis | Regressionsanalyse | statistics | RegressionAnalysis3 | 3 | 195 | deprecated | XimesData |
| Regression analysis 4.0 | Regressionsanalyse | statistics | RegressionAnalysis4 | 4 | - | done | XimesData |
| Regression analysis seasonal 7.0 | Regressionsanalyse saisonal 7.0 | statistics | OpRegressionAnalysis7 | 7 | 6 | deprecated | xi.Forecast |
| Regression analysis seasonal 8.0 | Regressionsanalyse saisonal 8.0 | statistics | OpSeasonalRegressionAnalysis8 | 8 | 6 | done | xi.Forecast |
| Rename, reorder and delete columns 2.0 | Spalten umbenennen, umsortieren und löschen 2.0 | table | OpColumnOperator2 | 2 | 5074 | done | xir.OpMisc |
| Replacing null values | Null-Werte ersetzen | data | HandlingNullValues | 0 | 593 | done | XimesData |
| Rescheduling (time shift) | Zeitverschiebung | Offset | 0 | 0 | interflex | cc.Tools | |
| Resolve pivot table 2.0 | Pivottabelle auflösen 2.0 | data | PivotResolve2 | 2 | 185 | deprecated | xi.OpMisc |
| Resolve pivot table 4.0 | Pivottabelle auflösen 4.0 | data | PivotResolve4 | 4 | 185 | done | xi.OpMisc |
| Retail (sales volume and employees) | Handel (Umsatz und Besetzung) | Retail | 1 | 0 | done | XimesData | |
| Save table in data cache | Tabelle in Daten-Cache speichern | SaveTableToDataCache | 0 | 0 | deprecated | cc.Tools | |
| Save table in persistence | Tabelle in Persistenz speichern | Save Table | 0 | 0 | interflex spx | cc.Persistence | |
| Scaling 8.0 | Rastern 8.0 | data | TimeRaster8 | 8 | ? | deprecated | xi.OpMisc |
| Scaling 8.2 | Rastern 8.2 | data | TimeRaster8_2 | 8.2 | ? | done | xi.OpMisc |
| Search for outliers | Ausreisser suchen | statistics | GetMysteryRecordsOne | 2 | 0 | done | xi.OpMystery |
| Seasonal ARIMA analysis 5.0 | Saisonale ARIMA-Analyse 5.0 | statistics | OpSARIMAAnalysis5 | 5 | 2 | done | xi.Forecast |
| Select columns | Spalten auswählen | table | SelectColumns | 1 | deprecated | XimesData | |
| Select columns 2.0 | Spalten auswählen 2.0 | table | SelectColumns2 | 2 | done | XimesData | |
| Select data source | Datenquelle auswählen | Multiplexer1 | 1 | 0 | status | xi.OpMisc | |
| Send e-mail 2.0 | E-Mail senden 2.0 | action | SendMail2 | 2 | 31 | status | xi.OpMisc |
| Smoothing | Glättung | Smoothing2 | 2 | 0 | interflex | cc.Tools | |
| Sort Rows | Zeilen sortieren | data | SortColumns | 0 | 4339 | done | XimesData |
| Split columns | Spalten splitten | data | ColumnSplit | 0 | 276 | done | cc.Tools |
| SPX - Conversion of (real) time presentation | SPX - Zeitdarstellungskonvertierung | SPX Time Converter | 0 | 0 | interflex | cc.Tools | |
| Start process 2.0 | Prozess starten 2.0 | StartProcess | 2 | 0 | deprecated | xi.OpMisc | |
| Start process 3.0 | Prozess starten 3.0 | StartProcess3 | 3 | 0 | done | xir.OpMisc | |
| Statistical evaluations | Statistische Auswertungen | Statistische Auswertungen | 1 | 0 | done | xi.OpMisc | |
| Stimulsoft report - export sample data 1.0 | Stimulsoft Report - Beispieldaten Export 1.0 | ? | 1 | 0 | deprecated | xi.OpMisc | |
| Sum and count | Summieren und Zählen | PeriodTotals2 | 2 | 0 | done | XimesData | |
| Sum up queues | Queues addieren | Merge Queue Data 2 | 2 | 0 | interflex | cc.Forecast | |
| Thread column values | Spalteninhalt verketten | ConcatColumns1 | 1 | 0 | done | XimesData | |
| Time grouping 2.0 | Zeit gruppieren 2.0 | OpGroupTime2 | 2 | 0 | editing | xi.OpMisc | |
| Time interval between rows | Zeitintervall zwischen Zeilen | CheckIntervalBetweenRows | 1 | 0 | done | xi.OpExternal | |
| Time period filter | Zeitbereichsfilter | DateTimeFilter2 | 2 | 41 | done | cc.Tools | |
| Timer | Timer | Timer | 0 | 0 | interflex | cc.Persistence | |
| TIS Board - Adjust Portlet | TIS Board - Portlet anpassen | OpUpdatePortletProperties2 | 2 | 0 | done | xi.OpMisc | |
| TIS Board - Adjust portlet if column changes 1.0 | TIS Board - Portlet bei Spaltenänderung anpassen 1.0 | TIS Board - Metadata Observer 1.0 | 1 | 0 | done | xi.OpMisc | |
| TIS Board - Dynamic selection for Editable Grid | TIS Board - Auswahlliste für Editierbare Datentabelle | ReadEditableGridCombo | 1 | 0 | done | xir.OpMisc | |
| TIS Board - Editable EJSChart 1.0 | TIS Board - Editierbares EJSChart 1.0 | OpTISBoardEditableEJSChart | 0 | 0 | done | xi.OpMisc | |
| TIS Board - Editable EJSChart Histogram 1.0 | TIS Board - Editierbares EJSChart Histogramm 1.0 | OpTISBoardEditableEJSHistogramm | 0 | 0 | done | xi.OpMisc | |
| TIS Board - Editable Grid 7.0 | TIS Board - Editierbare Datentabelle 7.0 | interact | OpReadEditableGrid7 | 7 | 77 | done | xir.OpMisc |
| TIS Board - EJSChart 3.0 | TIS Board - EJSChart 3.0 | plot | OpTISBoardEJSChart3 | 3 | 0 | deprecated | xi.OpMisc |
| TIS Board - EJSChart 6.0 | TIS Board - EJSChart 6.0 | plot | OpTISBoardEJSChart5 | 6 | 0 | done | xi.OpMisc |
| TIS Board - EJSChart Histogram 2.0 | TIS Board - EJSChart Histogramm 2.0 | OpTISBoardEJSChart2Histo | 2 | 0 | done | xi.OpMisc | |
| TIS Board - Gauge 1.0 | TIS Board - Tachometer 1.0 | TISBoardTachometer | 0 | 101 | done | xi.OpMisc | |
| TIS Board - Generate editable data table 4.0 | TIS Board - Editierbare Datentabelle erzeugen 4.0 | ? | 2 | 0 | deprecated | xi.OpMisc | |
| TIS Board - Generate editable data table 5.0 | TIS Board - Editierbare Datentabelle erzeugen 5.0 | PWRVER5 | 5 | 0 | done | xi.OpMisc | |
| TIS Board - HTML | TIS Board - HTML | OpTISBoardHTML | 0 | 0 | done | xi.OpMisc | |
| TIS Board - Multiple selection 3.0 | TIS Board - Mehrfachauswahl 3.0 | TISBoardMultiselect3 | 3 | 0 | deprecated | xi.OpMisc | |
| TIS Board - Multiple selection 4.0 | TIS Board - Mehrfachauswahl 4.0 | TISBoardMultiselect4 | 4 | 0 | done | xi.OpMisc | |
| TIS Board - Quickview | TIS Board - Quickview | OpTISBoardQuickView | 0 | 0 | done | xi.OpMisc | |
| TIS Board - Read editable data table 5.0 | TIS Board - Editierbare Datentabelle holen 5.0 | interact | OpReadEditableGrid5 | 5 | 77 | deprecated | xi.OpMisc |
| TIS Board - Read editable data table 6.0 | TIS Board - Editierbare Datentabelle holen 6.0 | interact | OpReadEditableGrid6 | 6 | 77 | deprecated | xi.OpMisc |
| TIS Board - Recalculate 3.0 | TIS Board - Neu berechnen 3.0 | interact | TISBoardCalc3 | 3 | 468 | deprecated | xi.OpMisc |
| TIS Board - Recalculate 4.0 | TIS Board - Neu berechnen 4.0 | interact | TISBoardCalc4 | 4 | 468 | done | xir.OpMisc |
| TIS Board - Stimulsoft report viewer 2.0 | TIS Board - Stimulsoft Report Viewer 2.0 | TISBoardStimulsoftReportViewer2 | 1 | 0 | deprecated | xi.OpMisc | |
| TIS Board - Stimulsoft report viewer 4.0 | TIS Board - Stimulsoft Report Viewer 4.0 | TISBoardStimulsoftReportViewer4 | 4 | 0 | done | xi.OpMisc | |
| TIS Board - TIS Editor Chart | TIS Board - TIS Editor Grafik | OpTISBoardTISChart | 0 | 0 | done | xi.OpMisc | |
| TIS Board - Upload file 1.0 | TIS Board - Datei hochladen 1.0 | TISBoardImportTISFile | 1 | 0 | done | xi.OpMisc | |
| Trigger shift generation 2.0 | Trigger Dienstgenerierung 2.0 | TriggerShiftGeneration2 | 2 | 0 | deprecated | xi.OpMisc | |
| Write Redis keys | Redis Keys schreiben | Redis | 1 | 5 | editing | xi.OpMisc | |
| Write TIS Table 5.0 | TIS Tabelle schreiben 5.0 | action | PersistenceWrite5 | 5 | - | deprecated | xi.OpMisc |
| Write TIS Table 7.0 | TIS Tabelle schreiben 5.0 | action | PersistenceWrite5 | 5 | - | deprecated | xi.OpMisc |
| Write TIS Table 8.0 | TIS Tabelle schreiben 8.0 | action | PersistenceWrite8 | 8 | - | editing | xi.OpMisc |