• What's new
    • What's new in Version 7.0
    • What's new in Version 7.1
  • Getting started
    • TIS Portal
    • Components of TIS
    • Using TIS Board
      • Refreshing Portlets on Tab Change
      • Managing and formatting a page
      • Navigation Button
      • Event Handling with Portlets
      • TIS Board login
      • Creating and editing pages
      • Using TIS Boards
      • Anleitung zur Benutzung des TIS Boards
      • Arbeiten mit dem TIS Board: Quick Guide
      • Elemente im TIS Board: Quick Guide
      • Creating and customizing pages
      • Design Boards & Pages
      • Formatting and Working with Portlets
        • General Elements for all or most Portlets
        • Formatting Elements for all or most Portlets
        • Further Elements for specific Portlets
        • Conditional Formatting for Grids
        • Managing Portlets
        • Using pictures and videos in HTML Portlets
    • Using TIS Editor
  • TIS Editor
    • Editor Homepage
    • List of Projects
    • Project
      • Project Homepage
      • List of Data Nodes
      • Project Properties
      • Copy Project
      • Delete Project
      • Import Project
      • Export Project
      • Replace Project
    • Data Node
      • Data Node Homepage
      • List of Operations
      • Result Table
        • Result Table Filter
      • Operation
        • Enable/Disable Operation
        • Add Operation
        • Copy Operation
        • Delete Operation
        • Move Operation
        • Operation Flags
        • Operator settings
          • Column references
      • Add Data Node
      • Copy Data Node
      • Move Data Node
      • Delete Data Node
      • Recalculate Data Node
        • Dependencies between data nodes
        • Data node recalculation modalities
        • Recalculation process between data nodes
      • Connect Data Node to TIS Board
      • Navigate between Data Nodes
      • Data Node Flags
      • Parent Node
      • Child Node
      • Referenced Node
      • Update process between data nodes
    • Operator
      • Operators (alphabetical overview)
        • Absence rate
        • ACD import
        • Analyze text pattern
        • As a percentage 4.0
        • Calculate Min/Max
        • Chart: 2D Map (Pivot start table)
        • Chart: 2D Map (Start table list)
        • Chart: Gantt 2D
        • Chart: Histogram
        • Chart: Histogram Time Pattern
          • Format a chart in TIS Editor
        • Chart: Standard types 2.0
        • Chart: XY Scatter
        • Combine columns
        • Conversion "String -> Date 2.0"
        • Conversion "String -> Double"
        • Conversion of time pattern
        • Convert "Date/Time"
        • Convert "From-Date/From-Time/To-Time" 2.0
        • Copy or delete TIS tables
        • Create table
        • CreateTable 2.0
        • Create pivot table 5.0
        • Cut values
        • Day or week profiles 2.0
        • Delete columns 2.0
        • Delete duplicated data records 2.0
        • Delete rows 2.0
        • Distribution
        • Edit table (Interflex)
        • Edit TIS Table 4.0
        • Encrypt text
        • Export to an ODBC Data Source
        • Export to CSV file (server file system) 3.0
        • Export to CSV file (TIS file system) 3.0
        • Export to SQL database
        • Filter on columns 2.0
        • Format columns 3.0
        • Formula operator (row-by-row) (5.0)
          • Formula operator: XIH Functions
          • Formula Operator: Date and Time
          • Formula operator: Extras
          • Formula operator: General Mathematics
          • Formula operator: Text
          • Formula Operator: Regular expressions
          • XIH Functions
            • Formula Operator: Conversion and Formatting
            • XIH.AccountId
            • XIH.CleanString
            • XIH.ClientName
            • XIH.ColumnCaption
            • XIH.ColumnIndex
            • XIH.Columns
            • XIH.ConvertToTimeZone
            • XIH.Count
            • XIH.CurrentLanguage
            • XIH.DatabaseInfo
            • XIH.Decrypt
            • XIH.Encrypt
            • XIH.EqualsFirst
            • XIH.EqualsLast
            • XIH.EqualsNext
            • XIH.EqualsPrev
            • XIH.FolderName
            • XIH.GetAppSetting
            • XIH.GetBool
            • XIH.GetDateTime
            • XIH.GetDouble
            • XIH.GetDownloadUrl
            • XIH.GetHash
            • XIH.GetInt
            • XIH.GetLogOnParam
            • XIH.GetLong
            • XIH.GetParam
            • XIH.GetParamCaption
            • XIH.GetParamDescription
            • XIH.GetPart
            • XIH.GetResourceText
            • XIH.GetString
            • XIH.HasRole
            • XIH.IsFirst
            • XIH.IsLast
            • XIH.IsNull
            • XIH.NodeName
            • XIH.ProjectID
            • XIH.ProjectName
            • XIH.RowNumber
            • XIH.Rows
            • XIH.Set
            • XIH.SetBool
            • XIH.SetDateTime
            • XIH.SetDouble
            • XIH.SetInt
            • XIH.SetLong
            • XIH.SetParam
            • XIH.SetResourceText
            • XIH.SetString
            • XIH.SetText
            • XIH.TemplateUserId
            • XIH.TISTable
            • XIH.UserName
            • XIH.GetText
            • XIH.IsValidEmail
            • XIH.Password
            • XIH.ServerName
            • XIH.Random
            • XIH.Get
            • XIH.IsNumber
            • TimeZoneID
        • Freeze columns 3.0
        • General calendar
        • Generate shifts 2.0
        • Identifier filter
        • Identifier instances 2.0
        • Import from Excel file
        • Importing data from SQL sources 5.0
        • Import data from SQL sources with query file
        • Import text or CSV file with automatic column assignment up to 5.*
        • Import text or CSV file with automatic column assignment since 5.*
        • Import text or CSV file with manual column assignment 5.0
        • Length operator
        • Link to calendar
        • Link with value table
        • Load table from persistence
        • Merge data 5.0
        • Merge data with time relations
        • Missing/overlapping time intervals 2.0
        • Mix columns
        • Normalizing (date)
        • Normalizing (time of day)
        • Pivot table
        • Pivot table time x weekdays 2.0
        • Python scripting
        • Python scripting (with input table) 2.0
          • Python scripting functions
            • Function main
            • Function simple_main
            • Function run
            • Function create_table
          • Parameters in Python Scripting
          • Useful sample Python Scripts
            • TIS File I/O in python scripting
            • Python Excel Import
            • Python translating texts for multilanguage use
            • Python Profiling
        • Read information of TIS table 3.0
        • Read Redis keys
        • Read TIS resources
        • Read TIS Table 8.0
        • Recalculate data nodes 1.0
        • Regression analysis 4.0
        • Regression analysis seasonal 8.0
        • Rename, reorder and delete columns 2.0
        • Replacing null values
        • Rescheduling (time shift)
        • Resolve pivot table 4.0
        • Retail (sales volume and employees)
        • Save table in persistence
        • Scaling 8.2
          • Calculation methods
          • Scales
          • Use cases for allocation-oriented methods
          • Use cases for value-oriented methods
        • Search for outliers
        • Seasonal ARIMA analysis 5.0
        • Select columns 2.0
        • Select data source
        • Send e-mail 2.0
        • Smoothing
        • Sort Rows
        • Split columns
        • SPX - Conversion of (real) time presentation
        • Start process 3.0
        • Statistical evaluations
        • Sum and count
        • Sum up queues
        • Test operator
        • Thread column values
        • Time grouping 2.0
        • Time interval between rows
        • Time period filter
        • Timer
        • TIS Board - Adjust Portlet
        • TIS Board - Adjust portlet if column changes 1.0
        • TIS Board - Editable EJSChart 1.0
        • TIS Board - Editable EJSChart Histogram 1.0
        • TIS Board - EJSChart 6.0
        • TIS Board - EJSChart Histogram 2.0
        • TIS Board - Gauge 1.0
        • TIS Board - Generate editable data table 5.0
        • TIS Board - HTML
        • TIS Board - Multiple selection 4.0
        • TIS Board - Quickview
        • TIS Board - Editable Grid 7.0
        • TIS Board - Recalculate 4.0
        • TIS Board - Dynamic selection for Editable Grid
        • TIS Board - Stimulsoft report viewer 4.0
        • TIS Board - TIS Editor Chart
        • TIS Board - Upload file 1.0
        • Write Redis keys
        • Write TIS Table 8.0
      • Operator upgrade
      • TIS Board operators
    • TIS File
      • File Properties
      • Upload File
      • Download File
      • Delete File
      • Replace File
    • TIS Table
      • Delete TIS Table
      • Replace TIS Table
      • TIS Table Properties
    • Parameters
      • Parameters in the "Import data from SQL sources 5.0" Operator
      • How to work with Parameters in TIS Board?
      • Creating Formatted Controller Portlets
      • Find empty strings in parameters
    • Profiler
    • Cron jobs
      • Setting up a cron job (cronjob)
    • Input Data
    • Export result table
    • Design reusable and adaptive Projects
    • Keep the overview in large projects
    • Minimize errors in TIS Projects
    • Naming conventions
    • User Settings
    • TIS Filter syntax
    • User Management
      • Roles
        • Predefined TIS Roles
        • Add Role
        • Update Role
        • Delete Role
        • OpenID Role Mapping
      • Users
        • Users' Properties
        • Add User
        • Update User
        • Delete User
      • Permissions
      • TIS Solution developer
  • TIS Board
    • Page
      • Add a Page
      • Distribute a Page
      • Page properties
      • Page tree
      • Page visibility
    • Events
    • Portlet
      • Create a portlet
      • Admin Portlet
      • Portlet property
      • List of Portlet Properties
      • Edit a portlet
      • Operator Portlet Compatibility
      • List of Portlets
        • Chart (Portlet)
        • Controller (Portlet)
        • Editable EJS Chart (Portlet)
        • EJS Chart (Portlet)
        • File Upload (Portlet)
        • Gauge (Portlet)
        • HTML (Portlet)
        • Quick View (Portlet)
        • Simple Grid (Portlet)
          • Create Sparklines in Simple Grid Portlets
        • SPX Picker (Portlet)
        • Tile (Portlet)
        • Editable Grid (Portlet)
          • Editing data in an Editable Grid
            • Daten aus Excel einfügen
            • Daten manuell editieren
            • Edit data manually
            • Paste contents from Excel
        • Stimulsoft (Portlet)
          • Designing a Stimulsoft Report
          • Stimulsoft with stacked/nested crosstabs
        • Heatmap Chart (Plotly)
        • Plotly chart
        • HTML Form
          • Data types in HTML Form
      • Trouble shooting portlets:
    • Keyboard Shortcuts
      • Shortcuts TIS Board Edit Mode
      • Shortcuts TIS Board Resources
      • Shortcuts TIS Board View Mode
    • Portlet Designer
    • Portlet Explorer
    • Table of contents and links in TIS Board
    • View mode and design mode
    • Copying Data between Excel and TIS Board
    • TIS Board Viewer
  • Preface
  • Introduction
  • How to use this manual
  • TIS Solution
    • Export TIS Solution
    • Import TIS Solution
  • TIS Training
    • Basic training
    • Advanced training
    • Exercise extra
    • Exercises
      • Exercise 1
      • Exercise 1.1
      • Exercise 1.2
      • Exercise 1.3
      • Exercise 2.1
      • Exercise 2.2
      • Exercise 4.1
      • Exercise 4.2
      • Exercise 5 "Chat"
      • Exercise 6
      • Exercise 6.1
      • Exercise 6.2
      • Exercise 6.3
      • Exercise 6.4
      • Exercise 7.1
      • Exercise 7.2
      • Exercise 7.3 Editable working time record
      • Exercise 8
      • Exercise 9
      • Übungsbeispiel 1
      • Übungsbeispiel 10
      • Übungsbeispiel 11
      • Übungsbeispiel 1.1
      • Übungsbeispiel 12
      • Übungsbeispiel 1.2
      • Übungsbeispiel 13
      • Übungsbeispiel 1.3
      • Übungsbeispiel 14
      • Übungsbeispiel 2
      • Übungsbeispiel 3
      • Übungsbeispiel 4.1
      • Übungsbeispiel 4.2
      • Übungsbeispiel 5.1
      • Übungsbeispiel 5.2
      • Übungsbeispiel 6
      • Übungsbeispiel 6.1
      • Übungsbeispiel 6.2
      • Übungsbeispiel 6.3
      • Übungsbeispiel 6.4
      • Übungsbeispiel 7
      • Übungsbeispiel 7.1
      • Übungsbeispiel 7.2
      • Übungsbeispiel 8
      • Übungsbeispiel 9
  • Deployment
    • Create a new client
    • Delete an existing client
    • System requirements
    • TIS releases with plano or SP-EXPERT compatibility
    • Patched-releases
    • FAQs and Troubleshooting
      • Fix expired server certificates
    • HTTPS Configuration
    • Installing Certificate
    • Load Balancing
    • Localization
    • Oracle Requirements
    • Prepare Windows features for TIS deployment on machines without Internet connection
    • Recommended Browser Settings
    • Change Log
      • TIS 7.0.0 (plano 2024.1) Change Log
      • TIS 7.0.1 (plano 2024.2) Change Log
      • TIS 7.0.2 (plano 2025.1) Change Log
      • Changes and points to be aware of when updating to TIS 7
    • TIS 7.0 Stand-alone Installation
    • TIS 7.0 Installation with Plano/SPX Integration
      • Plano settings
      • Extras
    • TIS Cluster Deployment with load balancing
      • SSL tunnel deployment
    • TISInstaller Settings
    • TIS Editor Settings
    • TIService Settings
    • Database maintenance jobs
    • Licensing and TIS Marketplace
      • TIS Marketplace / TIS Marktplatz
      • Temporary Developer License for Debugging at the Marketplace
      • Prepaid activation code usage
  • Advanced Issues
    • Management of data sets
      • How to work with large data sets
      • Switching between data sets
      • How to prepare Data for using Standard Packages
      • How to deal with many data and several variables?
      • Updating of Edited Data
        • Join before Init
        • Method csv
        • Method TIS-Table
        • Method Append
    • Managing Pages and Projects
      • Introduction & Mechanisms
      • Working with Template Projects
      • Templates = Using Boards with many users
        • Visibility & Publication of Pages
        • Deploy Pages & Delete deployed pages
        • Master portlets
        • Inspect Error-Status of Clones / Data inside of Clones / Debug Clones
      • Ownership of Projects & Administration Portlets
      • Licensing & Report Type
      • Further Administration Portlets
      • Changing Resources
    • Advanced Usage TIS Board
      • Updating Pages on Opening
      • Change the Default Client for TIS Board Login
      • Setting a different Logo
      • Adjust Portlet properties dynamically
      • Deactivate Startup Tips
      • Remote control API to change TIS Board State
      • TIS Board Settings
      • Change Online Help
      • Resources
      • Hiding Zero Values
      • Using Links (e.g. for icons) in Texts and Resources
    • OPA in TIS Optimizing Shifts and Staffing
    • Solution Runner
    • Developing Solutions - when to log out?
    • Switching between Languages / Translation
    • Run in 32-bit mode
    • File Guard Configuration
    • Active Directory (AD) authentication configuration
    • eTermin in TIS
    • Advanced python issues
    • LogOnScripts for custom login
    • User pool
    • File Guard configuration in TIS Board
    • Create a file with a secure download link
  • Glossary
  • Appendix
    • Formatting strings
    • Tipps für Reports (in Stimulsoft)
    • TIS Solution Datenreiniger
    • TIS Error Codes
    • Typographic Conventions
    • Data Types
    • Abwesenheitsrate
    • ACD-Import
    • Allgemeiner Kalender
    • Ausreisser suchen
    • Dateiupload (Portlet)
    • Datenknoten neu berechnen 1.0
    • Datenquelle auswählen
    • Datentabelle (Portlet)
    • Daten zusammenfassen 4.0
    • Daten zusammenfassen mit Zeitrelationen
    • Diagramm: Gantt 2D
    • Diagramm: Histogramm
    • Diagramm: Histogramm Zeitraster
    • Diagramm: Landkarte 2D (Ausgangstabelle Liste)
    • Diagramm: Landkarte 2D (Ausgangstabelle Pivot)
    • Diagramm: Punkt (XY)
    • Diagramm: Standarddiagramme 2.0
    • Doppelte Datensätze löschen
    • Editierbare Datentabelle (Portlet)
    • Editierbares EJS Chart (Portlet)
    • E-Mail senden 2.0
    • Export in CSV Datei (Serverdateisystem) 2.0
    • Export in CSV Datei (TIS-Dateisystem) 2.0
    • Export in eine ODBC-Datenquelle
    • Fehlende/Überlappende Zeitintervalle
    • Filter auf Spalten 1.1
    • Formelinterpreter 3.1
    • Formeloperator (zeilenweise) (4.0)
    • Formeloperator (zeilenweise) (5.0)
    • Glättung
    • Handel (Umsatz und Besetzung)
    • Identifizierer Ausprägungen
    • Identifizierer Filter
    • Import aus Excel Datei
    • Importieren von Daten aus SQL-Quellen 5.0
    • Import Text- bzw. CSV-Datei mit automatischer Spaltenzuordnung
    • Import Text- bzw. CSV-Datei mit manueller Spaltenzuordnung 3.0
    • Import Text- bzw. CSV-Datei mit manueller Spaltenzuordnung 4.0
    • In Prozent 4.0
    • Kreuztabelle
    • Min/Max ermitteln
    • Normierung (Datum)
    • Normierung (Tageszeit)
    • Null-Werte ersetzen
    • Optimierer: Sequence Simple
    • Pivottabelle auflösen 2.0
    • Pivottabelle erstellen V5
    • Pivottabelle Uhrzeit x Wochentage 2.0
    • Prozess starten 2.0
    • Python Scripting (mit Eingabetabelle)
    • Queues addieren
    • Rastern 8.0
    • Redis Keys lesen
    • Regressionsanalyse
    • Regressionsanalyse saisonal 7.0
    • Reportdaten sammeln 2.0
    • Saisonale ARIMA-Analyse 5.0
    • Schichten generieren
    • Spalten einer 'Editierbaren Datentabelle' formatieren 1.0
    • Spalten einfrieren 3.0
    • Spalten formatieren 2.0
    • Spalteninhalt verketten
    • Spalten löschen
    • Spalten mischen
    • Spalten splitten
    • Spalten umbenennen, umsortieren und löschen 2.0
    • Spalten zusammenfassen
    • SPX - Zeitdarstellungskonvertierung
    • Statistische Auswertungen
    • Steuerung (Portlet)
    • Stimulsoft Report - Beispieldaten Export 1.0
    • Summieren und Zählen
    • Tabelle aus Persistenz laden
    • Tabelle bearbeiten
    • Tabelle erzeugen
    • Tabelle in Daten-Cache speichern
    • Tabelle in Persistenz speichern
    • Tachometer (Portlet)
    • Tages- oder Wochenprofile 2.0
    • Textmuster analysieren
    • Text verschlüsseln
    • TIS Board - Auswahlliste für Editierbare Datentabelle
    • TIS Board - Datei hochladen 1.0
    • TIS Board - Editierbare Datentabelle erzeugen 4.0
    • TIS Board - Editierbare Datentabelle holen 5.0
    • TIS Board - Editierbares EJSChart 1.0
    • TIS Board - Editierbares EJSChart Histogramm 1.0
    • TIS Board - EJSChart Histogramm 2.0
    • TIS Board - Mehrfachauswahl 3.0
    • TIS Board - Neu berechnen 3.0
    • TIS Board - Portlet anpassen
    • TIS Board - Portlet bei Spaltenänderung anpassen 1.0
    • TIS Board - Tachometer 1.0
    • TIS Board - TIS Editor Grafik
    • TIS Editor Grafik (Portlet)
    • TIS Resourcen auslesen
    • TIS Tabelle lesen 5.0
    • TIS Tabelleninformation lesen 3.0
    • TIS Tabellen kopieren oder löschen
    • TIS Tabelle schreiben 5.0
    • Trigger Dienstgenerierung 2.0
    • Umwandlung "Datum/Uhrzeit"
    • Umwandlung "Datum/Von-Uhrzeit/Bis-Uhrzeit"
    • Umwandlung "String -> Datum 2.0"
    • Umwandlung "String -> Double"
    • Verknüpfen mit Kalender
    • Verknüpfung mit Wertetabelle
    • Verteilung
    • Werte schneiden
    • Zeilen löschen 2.0
    • Zeilen sortieren
    • Zeitbereichsfilter
    • Zeit gruppieren 2.0
    • Zeitintervall innerhalb einer Zeile
    • Zeitintervall zwischen Zeilen
    • Zeitrasterkonvertierung
    • Zeitverschiebung
  • Impressum