# Valsight Documentation > Documentation for the Valsight platform, structured for humans and AI agents alike. ## Agent access - Full content dump: https://docs.valsight.ai/llms-full.txt - Any page as markdown: append `.md` to its URL (e.g. https://docs.valsight.ai/getting-started.md) - MCP endpoint (streamable HTTP): https://docs.valsight.ai/mcp — tools: search_docs, get_doc, get_tree, list_templates, get_template - Plain HTTP: GET https://docs.valsight.ai/api/search?q=…&audience=agent, GET https://docs.valsight.ai/api/doc/{slug}?audience=agent, GET https://docs.valsight.ai/api/tree ## Pages - [Valsight Documentation](https://docs.valsight.ai/index.md): Guides, references, and release notes for the Valsight platform, for humans and AI agents alike. - [Release Notes 7.0.0](https://docs.valsight.ai/7-0-0.md): This release introduces powerful new ways to work with Valsight, combining intelligent assistance, clearer scenario analysis, and a refined modelling experie… - [Release Notes 7.1.0](https://docs.valsight.ai/7-1-0.md): This release brings greater consistency to multi-model projects with project-level baseline management, a cleaner and more reliable ROLLUP formula syntax, an… - [Release Notes 7.2.0](https://docs.valsight.ai/7-2-0.md): 7.2 brings more precision to your planning models with dynamic project variables, chart axis breaks, bulk dimension-value deletion, and cross-submodel formula viewing. - [ABS](https://docs.valsight.ai/abs.md): Returns the absolute value for each value in the input node. Use this when you need to remove the sign from negative values. - [Abschreibungen](https://docs.valsight.ai/abschreibungen.md): Abschreibungen - [Access Rights](https://docs.valsight.ai/access-rights.md): To activate changes made in the access management, users have to sign out and sign in again. - [Accessibility - WCAG Compliance](https://docs.valsight.ai/accessibility-wcag-compliance.md): Web accessibility is the inclusive practice of ensuring that people with disabilities can interact with websites. For our product development at Valsight this means we follow the WCAG 2.1 guidelines. - [Add a copyright or confidentiality notice](https://docs.valsight.ai/add-a-copyright-or-confidentiality-notice.md): On this page we will show you how to add and customize a copyright or confidentiality notice - [ADDEACH](https://docs.valsight.ai/addeach.md): The ADDEACH function adds a numeric value (or the values of another node) to each individual entry of a node before any aggregation is applied. - [ADDITION (+)](https://docs.valsight.ai/addition.md): The ADDITION operator adds two inputs after aligning them to their common dimensions. In other words, addition uses the intersection of the shared dimensions. - [Additional Security Features](https://docs.valsight.ai/additional-security-features.md): - New users are redirected to change password on first login (admin can force that in the specified user's config page) - [Admin Guide](https://docs.valsight.ai/admin-guide.md): What you will find in this section - [Admin Password Reset](https://docs.valsight.ai/admin-password-reset.md): How to reset the admin user password directly in the application database of a Valsight On-Premise installation. - [Advanced Node Settings](https://docs.valsight.ai/advanced-node-settings.md): Advanced Node settings allow you to further fine-tune the behavior of a Node. You can hide technical Nodes by default or mark Nodes as base Assumptions. - [Aggregation Settings](https://docs.valsight.ai/aggregation-settings.md): 'Aggregation' is the process of reducing a data set's complexity by summarizing multiple values. - [AI Assistant](https://docs.valsight.ai/ai-assistant.md): The Valsight AI Assistant is a conversational interface that helps you understand, explore, and navigate your Valsight models using natural language. It prov… - [All functions (A-Z)](https://docs.valsight.ai/all-functions-a-z.md): This page is the complete alphabetical index of all functions available in node formulas. - [Allow Simulation of Nodes](https://docs.valsight.ai/allow-simulation-of-nodes.md): This guide shows you how to mark nodes as simulatable so that their values can be changed in a simulation workspace. - [AND (&&)](https://docs.valsight.ai/and.md): Connects two inputs with the logical AND and returns true (1) if both values are true and false (0) otherwise. - [Annotations](https://docs.valsight.ai/annotations.md): Annotations enable teams to add contextual information and visual structure directly to a model, making complex logic easier to understand and collaborate on… - [API Access](https://docs.valsight.ai/api-access.md): Almost any part of the Valsight Application can be accessed via APIs. You can thereby freely integrate Valsight into your landscape, for example by regularly… - [API_CALL](https://docs.valsight.ai/api-call.md): Enables Valsight to interact with external applications by making a POST call to a designated URL and returning the result to the Valsight model. - [API keys login](https://docs.valsight.ai/api-keys-login.md): To configure the Valsight application to use the API keys login method, edit conf/config.yml and restart the server after making changes. - [Applying Filters](https://docs.valsight.ai/applying-filters.md): The standard mode when it comes to applying filters in Valsight offers a quick and easy way to customize filter settings. It follows three basic rules: - [Arbeitsbereiche](https://docs.valsight.ai/arbeitsbereiche.md): Diese Seite bietet Tutorials und Anleitungen rund um das Thema Simulation. - [ARIMA](https://docs.valsight.ai/arima.md): Forecasting function based on the autoregressive integrated moving average (ARIMA) model. Use when you want to forecast a time series from historical patterns without defining explicit driver nodes. - [Arithmetic operators](https://docs.valsight.ai/arithmetic-operators.md): Arithmetic operators combine numeric values in formulas. Use them for simple calculations, KPI logic, and combining driver nodes. - [Assumption Categories](https://docs.valsight.ai/assumption-categories.md): Assumption Categories help structure assumptions in the Scenario Manager, making it easier to filter, organize, and analyze assumptions effectively. This fea… - [Assumption Effects](https://docs.valsight.ai/assumption-effects.md): How the effect of a single assumption is calculated, how to show it in a chart or table, and how to display an assumption's description on hover. - [Assumption Templates](https://docs.valsight.ai/assumption-templates.md): When Creating Assumptions you always have a specific case in mind that you want to capture with this Assumption. Such cases follow certain logics and typical… - [Assumption Versioning](https://docs.valsight.ai/assumption-versioning.md): When creating a new version of an Assumption, you save the Assumption with all its properties as well as all the Line-Items attached to it. Please keep in mi… - [Assumptions](https://docs.valsight.ai/assumptions.md): Assumptions represent explicit views on how the future might develop. They capture planned or discussed changes and apply them consistently across the model … - [Assumptions & Line-Items](https://docs.valsight.ai/assumptions-line-items.md): What you will find in this section - [Assumptions & result sets](https://docs.valsight.ai/assumptions-result-sets.md): Use this category when you need to control how assumptions affect a node’s values or when you want to combine result sets. - [Available Logs](https://docs.valsight.ai/available-logs.md): All log files are stored in the logs/ directory. - [Axis Scales and Decimals](https://docs.valsight.ai/axis-scales-and-decimals.md): Set the scale size, decimal places and value range of each axis in a chart, and add a second axis for nodes with a different unit. - [Backup & Recovery](https://docs.valsight.ai/backup-recovery.md): ON PREMISE This article applies only to Valsight On-Premise. Contact support for Cloud installations. - [BASELINE](https://docs.valsight.ai/baseline.md): Returns the value of a node with no assumptions applied, removed from the referenced node and all upstream nodes that affect it. - [Baseline Indicator on Nodes](https://docs.valsight.ai/baseline-indicator-on-nodes.md): When a node has "Operation per Baseline" enabled, an indicator icon appears next to the node's warnings area to show whether the baselines are actually produ… - [Baselines](https://docs.valsight.ai/baselines.md): This guide shows you how to create a new baseline in a project so that it becomes available across all models in that project. - [Best practices for dimensions](https://docs.valsight.ai/best-practices-for-dimensions.md): Designing a dimension means choosing the right levels and the right granularity for your analysis. - [Bridges](https://docs.valsight.ai/bridges.md): A bridge breaks the difference between two values down into the individual effects that produced it, either across time periods or across scenarios. - [Browse by category](https://docs.valsight.ai/browse-by-category.md): Browse by category helps you find the right function when you don't know the exact name yet. Functions are grouped by what they do, so you can start from your modeling goal and drill down to the right reference page. - [Build a service for API_CALL](https://docs.valsight.ai/build-an-api-call-service.md): Implement an HTTP service that the API_CALL formula function can call from inside a Valsight model calculation. - [Building Models](https://docs.valsight.ai/building-models.md): This section explains what a model is in Valsight and how models serve as the foundation for structured business logic. It introduces how calculations, data,… - [Business Key](https://docs.valsight.ai/business-key.md): The Business Key is a unique identifier for each project. It is used when referencing a project in external contexts such as: - [CAGR](https://docs.valsight.ai/cagr.md): The CAGR function computes the Compound Annual Growth Rate between a current value and the value N periods earlier, taking compounding into account. It works along a chosen level or any non-time dimension. - [Calendar Months Dimension](https://docs.valsight.ai/calendar-months-dimension.md): Calendar months are an optional dimension that you can enable in the project settings. This will generate a “CalendarMonth” dimension with the levels 01, 02,… - [Changing the Time Horizon](https://docs.valsight.ai/changing-the-time-horizon.md): The time horizon of a project defines the amount of time you want to plan ahead - and want to have data in the past. - [Formatting Charts](https://docs.valsight.ai/chart-configuration.md): Sort, scale and format charts and tables so they read the way you want, from axis scales to table styles and overlapping labels. - [Chart Filter](https://docs.valsight.ai/chart-filter.md): Chart filters are the third level of filters available in a workspace. - [Chart Templates](https://docs.valsight.ai/chart-templates.md): Save a chart's configuration as a reusable template, then apply it when you add a new chart. - [Chart Types](https://docs.valsight.ai/chart-types.md): An overview of the chart types and worksheet tiles available in Valsight, in the same five groups you see when you add a chart. - [Clickable Submodel Label on External Nodes](https://docs.valsight.ai/clickable-submodel-label-on-external-nodes.md): Nodes that originate from another model (external nodes) show the source model's name in their bottom-right corner. This label is clickable and lets you navi… - [Cloud SSO with Valsight ID](https://docs.valsight.ai/cloud-openid-connect.md): Connect your identity provider to a Valsight cloud instance through Valsight ID using OpenID Connect. - [Common SSO Options](https://docs.valsight.ai/common-sso-options.md): Edit the main configuration file conf/config.yml to fine tune behaviour of the application when using any SSO providers. - [Compare periods](https://docs.valsight.ai/compare-periods.md): Use this category when you need to compare values across time, such as month-over-month or year-over-year changes. - [Comparisons & boolean operators](https://docs.valsight.ai/comparisons-boolean-operators.md): Comparisons and boolean operators turn values into conditions. Use them to test values, combine conditions, and drive branching logic, most commonly inside IF. - [Compliance & Security](https://docs.valsight.ai/compliance-security.md): Compliance & Security - [Complying with GDPR Requirements](https://docs.valsight.ai/complying-with-gdpr-requirements.md): GDPR requirements typically require organisations to securely log and store data in an audit-proof manner. Valsight offers extensive features and tools to ea… - [Configuration of Websockets](https://docs.valsight.ai/configuration-of-websockets.md): The Valsight frontend uses Websockets to communicate with the Valsight backend in an interactive, bi-directional way. - [Compare a Total with a Breakdown](https://docs.valsight.ai/configure-flexible-scenario-comparisons-in-a-single-chart.md): This guide shows you how to compare multiple scenarios in a single chart while displaying totals for one scenario and detailed breakdowns for another. - [Configure the Sequence Dimension](https://docs.valsight.ai/configure-the-sequence-dimension.md): The Sequence dimension is a special system dimension used to describe abstract steps or "periods after time." It's commonly used in models where events unfol… - [Configure Units](https://docs.valsight.ai/configure-units.md): Project administrators with a modeling license can create, edit, and delete units within a project. Units are scoped to the project level: each project contains only the units defined for it. - [Copy / Migrate Workspaces to New Models](https://docs.valsight.ai/copy-migrate-workspaces-to-new-models.md): You need administrative rights for this task. - [Create and Update Data Sources - Step by Step](https://docs.valsight.ai/create-and-update-data-sources-step-by-step.md): On this page we will be listing the steps to upload base data and check it's validity. Please note that your Excel file needs to follow the structural guidel… - [Create one Excel Sheet for Multiple Data Nodes](https://docs.valsight.ai/create-one-excel-sheet-for-multiple-data-nodes.md): This method is only compatible when using data Nodes in your Model. Starting with Version 1.19 (January 2018) we recommend to use only calculation Nodes with… - [Create Upload Tables](https://docs.valsight.ai/create-upload-tables.md): There are important Naming Guidelines to follow when choosing worksheet and column names. - [Creating a Line-Item](https://docs.valsight.ai/creating-a-line-item.md): 1. To add a Line-Item to your assumption, click on the “+” button on an assumption. - [Creating a Model Copy](https://docs.valsight.ai/creating-a-model-copy.md): Learn how to create a copy of a Model and how to use that copy. - [Creating a Project](https://docs.valsight.ai/creating-a-project.md): This guide shows you how to create a new project in Valsight, including configuring the project name, business key, and time settings. - [Creating a Workspace](https://docs.valsight.ai/creating-a-workspace.md): To create a workspace, navigate to the list of workspaces by selecting "Workspaces" in the main menu on the left. You will see a list of all workspaces you h… - [Creating and Configuring Models](https://docs.valsight.ai/creating-and-configuring-models.md): This guide shows you how to create a new, empty model inside an existing project and open it on the model canvas, ready for further configuration. - [Creating and Downloading an Export](https://docs.valsight.ai/creating-and-downloading-an-export.md): In order to create and download, save or share a scenario export, you must create an export first. This export will be saved in the Export Manager and can th… - [Creating Assumptions](https://docs.valsight.ai/creating-assumptions.md): Assumptions describe an encapsulated change on top of the base data in your Model. They can be used to describe the change in the development of a value driv… - [Creating Charts](https://docs.valsight.ai/creating-charts.md): Add a chart to a worksheet, point it at the data you want, and reuse a configuration you already have. - [Creating & maintaining dimensions](https://docs.valsight.ai/creating-maintaining-dimensions.md): Navigate to the Dimension Manager and create a new Dimension. - [Creating & Managing Workflows (For Admins)](https://docs.valsight.ai/creating-managing-workflows-for-admins.md): Bildschirmfoto 2025-02-03 um 16.07.28.png - [Creating Nodes](https://docs.valsight.ai/creating-nodes.md): This guide shows you how to add nodes to an empty model canvas so you can start building the basic structure of your model. - [Creating Sticky Notes & Frames](https://docs.valsight.ai/creating-sticky-notes-frames.md): The Annotations feature enhances collaboration in the Valsight Model Editor by allowing users to visually comment on, organize, and highlight areas of a mode… - [Custom Views in the Model Editor](https://docs.valsight.ai/custom-views-in-the-model-editor.md): The Model Editor lets you display optional overlays that add contextual information directly on nodes or the canvas. These views are independent of model log… - [Customizing](https://docs.valsight.ai/customizing.md): Valsight ships a standard product with very little need to customize the software, besides some look and feel options. - [DATA](https://docs.valsight.ai/data.md): The DATA function references a data table (an uploaded dataset, such as an Excel sheet) directly from within a node formula. - [Data access](https://docs.valsight.ai/data-access.md): Use this category when you want to bring uploaded or source data into node formulas, or send data to an external service and return the result to the model. - [Data & Dimension Validation](https://docs.valsight.ai/data-dimension-validation.md): Validate that uploaded data is correctly formatted, contains expected values, and complies with your defined dimensions. - [Data Display in Charts and Tables](https://docs.valsight.ai/data-display-in-charts-and-tables.md): Choose what a chart or table shows and at which level of aggregation, including combining nodes of different dimensionality and adding totals. - [Data Effects Display in Bridge](https://docs.valsight.ai/data-effects-display-in-bridge.md): Split the model's own contribution to a time bridge out per node, or group several nodes into one named block. - [Data Import & Export](https://docs.valsight.ai/data-import-export.md): Data in Valsight provides the input values that feed models and serve as the baseline for calculations, simulations, and analysis. - [Data Permissions](https://docs.valsight.ai/data-permissions.md): Data permissions define which data a user can access. They can be configured for a project and will be enforced in workspaces. - [Data Preview of Nodes](https://docs.valsight.ai/data-preview-of-nodes.md): The data preview is part of the operations/formula editor in a model. - [Data Source Upload](https://docs.valsight.ai/data-source-upload.md): Learn how to structure your data in the excel file so that it can be used in Valsight. - [Data Upload Errors, Warnings and Infos Explained](https://docs.valsight.ai/data-upload-errors-warnings-and-infos-explained.md): On this page you'll find the meaning of the different Error, Warning and Info Messages when Uploading Data to Valsight. - [Data Upload & Import/Export Overview](https://docs.valsight.ai/data-upload-import-export-overview.md): Learn why and where to import and export files to and from Valsight, and find out which data formats are supported. - [DATE_EXTRACT](https://docs.valsight.ai/date-extract.md): Extracts the year, quarter, month, week, or day from a given time level value. - [DATE_OFFSET](https://docs.valsight.ai/date-offset.md): Offsets a time level value forward or backward by a number of years, quarters, months, weeks, or days. - [Datenquellen](https://docs.valsight.ai/datenquellen.md): Diese Seite bietet Tutorials und Anleitungen rund um das Thema Datenquellen. - [Default Scale Settings in Nodes](https://docs.valsight.ai/default-scale-settings-in-nodes.md): Set the scale a node's numbers are displayed at once, on the node itself, so every chart that shows it is formatted sensibly. - [Define Calculations for a Node](https://docs.valsight.ai/define-calculations-for-a-node.md): This guide shows you how to define a calculation for a node so it computes its value based on other nodes in the model. - [DELTA_ABS](https://docs.valsight.ai/delta-abs.md): The DELTA_ABS function calculates the absolute difference between consecutive values within a selected dimension. The result is signed (current - previous). - [DELTA_REL](https://docs.valsight.ai/delta-rel.md): In contrast to YOY_REL and related relative functions, the growth will be calculated by using the absolute former value as relative base: (currentValue - formerValue) / absolute(formerValue). - [DEPRECIATION](https://docs.valsight.ai/depreciation.md): The DEPRECIATION function calculates linear depreciation values per period from an investment node and a depreciation time node. The result is the depreciation amount for each time period, not the remaining book value. - [Digitally Signed Releases](https://docs.valsight.ai/digitally-signed-releases.md): All our releases are digitally signed using a GPG key to ensure authenticity and integrity. You can verify that the files you download have not been tampered… - [Dimensionality & hierarchies](https://docs.valsight.ai/dimensionality-hierarchies.md): Use this category when you need to control a formula’s output shape: which dimensions and levels the result has, and at what granularity values exist. - [Dimensions](https://docs.valsight.ai/dimensions.md): Dimensions in Valsight structure data into cluster such as product, region, or time, so values can be organized, aggregated, and analyzed across different vi… - [DISAGGREGATE](https://docs.valsight.ai/disaggregate.md): Disaggregates the values of the Original Node for the given Level based on the value distribution from the Distribution Node, in relation to the aggregated values of the Distribution Node when rolled up to the levels of the Original Node. - [Displaying Scenarios in the Data Preview](https://docs.valsight.ai/displaying-scenarios-in-the-data-preview.md): When building a model, it can be helpful to directly see data from a simulation scenario in the data preview of nodes. - [DISTRIBUTE](https://docs.valsight.ai/distribute.md): The DISTRIBUTE function distributes the values of the Original Node based on the value distribution from the Distribution Node, in relation to the aggregated values of the Distribution Node when rolled up to the levels of the Original Node. - [DIVIDE](https://docs.valsight.ai/divide.md): The DIVIDE function extends the / operator with optional validation for missing rows. It produces the same result as 'Node1' / 'Node2' when validation passes. When validation fails, it produces an error with a detailed explanation of which rows are missing. - [DIVISION (/)](https://docs.valsight.ai/division.md): The DIVISION operator divides one input by another across their combined dimension set. In other words, division uses the union of both inputs’ dimensions. - [DROPLEVEL](https://docs.valsight.ai/droplevel.md): DROPLEVEL removes one or more levels from a node and aggregates the remaining values. When a parent level is removed, all finer levels in the same hierarchy are automatically removed as well. - [Duplicating a Project](https://docs.valsight.ai/duplicating-a-project.md): To duplicate a project, navigate to the three-dot menu on the project card and click on “Duplicate”. - [Editing the color palette](https://docs.valsight.ai/editing-the-color-palette.md): You can customize the color palette used in the application to change existing colors or to add your corporate colors. Go to Configuration Your project Set… - [Einführung](https://docs.valsight.ai/einfuehrung.md): Einführung - [Entra / AAD Configuration](https://docs.valsight.ai/entra-aad-configuration.md): Create a new Application registration, and provide Valsight with the following information: - [ENUM](https://docs.valsight.ai/enum.md): Iterates through the rows of the input and assigns a number to each row in ascending or descending order based on the magnitude of measures. - [ENUM_LEVEL](https://docs.valsight.ai/enum-level.md): Iterates through the values of the specified levels and returns each value with a number assigned in ascending or descending order according to the sequence in the dimension management. - [EQ (=)](https://docs.valsight.ai/eq.md): Checking whether matching rows are equal - [Example Excel Sheets](https://docs.valsight.ai/example-excel-sheets.md): Dimension Example 3 Demo Dimensions, one with a two-level hierarchy WARNING We do not longer recommend to use the “AUTO DIM” feature - please use the Valsi… - [Excel upload feedback messages](https://docs.valsight.ai/excel-upload-feedback-messages.md): When uploading your Excel file to manage Dimensions, you may receive certain feedback messages on your file. - [Excel upload of Assumptions & Line-Items](https://docs.valsight.ai/excel-upload-of-assumptions-line-items.md): You can download all data of an Assumption as an Excel file with one sheet per Line-Item. You can edit the data and upload the file to the same Assumption ag… - [EXP](https://docs.valsight.ai/exp.md): Returns Euler's number, e (~2.718) raised to a power of the given value, while retaining all dimensions. Use this when you need to compute e raised to the power of node values, for example in continuous growth or compounding models. - [EXPAND](https://docs.valsight.ai/expand.md): The EXPAND function creates a full cross product of existing rows with all values of specified levels, used to initialize empty data rooms or add dimensions to nodes. - [EXPANDSINGLE](https://docs.valsight.ai/expandsingle.md): The EXPANDSINGLE function expands a node by adding specific level values for one or more levels. - [Expected Levels](https://docs.valsight.ai/expected-levels.md): Expected levels define the minimum dimensional shape for a node, allowing empty nodes to pass model validation and serve as blueprints for simulation. - [Export Control Classification Number](https://docs.valsight.ai/export-control-classification-number.md): ECCNs are five character alphanumeric designations used on the Commerce Control List (CCL) to identify dual-use items for export control purposes. An ECCN c… - [Export Formats](https://docs.valsight.ai/export-formats.md): With the introduction of the Export Manager it is now possible to version your exports as well as the OData Link. An OData Link can be used to either import … - [Export Manager](https://docs.valsight.ai/export-manager.md): See below a brief overview over the key functions of the Export Manager. To learn more about a specific functionality, simply navigate to the sub-page. - [External Data Source Connections (ODATA / JDBC)](https://docs.valsight.ai/external-data-source-connections-odata-jdbc.md): You can create data sources with connections to external systems. Supported are connections via ODATA and JDBC. - [FACT](https://docs.valsight.ai/fact.md): This example computes the factorial of each value in the input node. - [FALSE](https://docs.valsight.ai/false.md): The FALSE function returns 0 for every defined value in the input node. Undefined intersections remain undefined in the result. - [Feature Deprecation](https://docs.valsight.ai/feature-deprecation.md): This page lists all features and functions that are deprecated and removed from Valsight. - [FILL_NA](https://docs.valsight.ai/fill-na.md): FILL_NA fills missing values (N/A) that result from pivoting a dimension into columns, replacing gaps with a specified value (default 0) on existing level combinations. - [FILLMISSING](https://docs.valsight.ai/fillmissing.md): The FILLMISSING function fills structurally missing level values of a specified dimension in a node with a constant value, using configurable behavior options to control which missing entries are filled. - [FILLMISSING_LAST](https://docs.valsight.ai/fillmissing-last.md): The FILLMISSING_LAST function fills missing level values in a node by carrying forward the last observed value from a specified dimension, with a fallback constant value before the first data point. - [FILTER](https://docs.valsight.ai/filter.md): The FILTER function returns only the rows of a node that match a specified condition. Rows that do not satisfy the filter condition are removed from the result. - [Filtering & data shaping](https://docs.valsight.ai/filtering-data-shaping.md): Use this category when you need to restrict results to a subset, select representative values per group, fill missing combinations, or create helper tables such as ranks and enumerations. - [Filters in Valsight](https://docs.valsight.ai/filters-in-valsight.md): - Setting filters can be done at multiple places within Valsight - [Finance functions](https://docs.valsight.ai/finance-functions.md): Use this category when you need standard financial calculations such as present value, future value, annuity payments, discounting, and investment appraisal. - [FINDFIRST](https://docs.valsight.ai/findfirst.md): Returns the first defined value per group along a given level. If no level is given, the function automatically uses the lowest level in the time dimension used by the node. - [FINDMISSING](https://docs.valsight.ai/findmissing.md): FINDMISSING compares two nodes and identifies missing level combinations by marking them as 1 (missing) or 0 (existing), with configurable behavior to check the first node, second node, or both for missing values. - [Formula basics](https://docs.valsight.ai/formula-basics.md): Formulas define how a node is calculated in a model. They combine node references, operators, and functions to calculate values across time and other business dimensions. - [Frequently Asked Questions (FAQ)](https://docs.valsight.ai/frequently-asked-questions-faq.md): In unseren FAQs beantworten wir häufig gestellte Fragen zur Software. Auf der Seite befinden sich hilfreiche Informationen zu allgemeinen und spezifischen Th… - [FAQ: AI Assistant](https://docs.valsight.ai/frequently-asked-questions-valsight-ai-assistant.md): When will the Valsight AI Assistant be rolled out for me? - [Function catalog](https://docs.valsight.ai/function-catalog.md): The function catalog is the authoritative list of all functions you can use in node formulas. - [Functions & formulas](https://docs.valsight.ai/functions-formulas.md): This section explains how to write node formulas in the Function Editor, how to reference node values, combine them with operators, and use functions to calculate across multi-dimensional data. - [FV](https://docs.valsight.ai/fv.md): Calculates the future value of a recurring annuity investment at a set point in the future, based on an interest rate, number of recurring payments, payment amount, present value, and payment timing. - [Tutorial: Build a Valsight Project](https://docs.valsight.ai/getting-started.md): This tutorial shows how to build a complete Valsight project from scratch. - [Glossary](https://docs.valsight.ai/glossary.md): A chart option that creates comparisons across a selected dimension (for example, years or scenarios) for the selected visualization. - [Grouping Assumption Effects in Bridges](https://docs.valsight.ai/grouping-assumption-effects-in-bridges.md): Combine the line-items of one assumption into a single bar in a bridge, or show each of them separately. - [GT (>)](https://docs.valsight.ai/gt.md): Checking whether one input is greater than another - [GTE (>=)](https://docs.valsight.ai/gte.md): Checking whether one input is greater than or equal to another - [Hiding a Project](https://docs.valsight.ai/hiding-a-project.md): To help declutter the project overview and settings pages, project admins can now hide old or unused projects. Hidden projects are removed from main lists but remain accessible. - [Hochlaufkurven](https://docs.valsight.ai/hochlaufkurven.md): Hochlaufkurven - [How cubes work](https://docs.valsight.ai/how-cubes-work.md): Every node in a Valsight model holds its values as a cube, a multi-dimensional data structure where each value is identified by its exact position across al… - [How dimensions work](https://docs.valsight.ai/how-dimensions-work.md): Dimensions define how data is structured and explored in Valsight by organizing values across multiple axes. - [IF](https://docs.valsight.ai/if.md): The IF function evaluates a condition and returns one value when the condition is true and another when it is false. For every row of the input, the condition is evaluated independently. - [Images](https://docs.valsight.ai/images.md): Add an image tile to a worksheet, for a logo, a diagram or any other picture. - [Importing Scenarios](https://docs.valsight.ai/importing-scenarios.md): Scenarios are dynamically calculated based on data, and model logic and always reflect their active assumptions. Every scenario you create in a workspace is … - [Information Security & Availability Commitment / TISAX](https://docs.valsight.ai/information-security-availability-commitment-tisax.md): At Valsight, protecting sensitive data and ensuring uninterrupted service is not just a compliance requirement. It’s part of our DNA. - [Input Tables](https://docs.valsight.ai/input-tables.md): Enter values directly into a table on the worksheet and see the effect on your scenario without leaving the sheet. - [Install an Evaluation Version on Windows](https://docs.valsight.ai/install-an-evaluation-version-on-windows.md): The following document describes how to install an evaluation version of the product on Windows. Windows is not supported for production use. - [Install Valsight as a Windows Service](https://docs.valsight.ai/install-valsight-as-a-windows-service.md): This article summarizes our recommended steps to run the Valsight Server application as a Windows Service. It is relevant for IT Administrators only. - [Introduction to Valsight API](https://docs.valsight.ai/introduction-to-valsight-api.md): Every part of the Valsight server can be accessed via a REST-based API. - [IRR](https://docs.valsight.ai/irr.md): Internal rate of return (IRR) is a metric of profitability for potential investments. It is the discount rate that sets the net present value of all future cash flows of the investment equal to zero, found using numerical iteration. - [IS_NA](https://docs.valsight.ai/is-na.md): The IS_NA function returns 1 for any values that are undefined (not available) in the input and 0 for any values that exist. The result covers the full cross product of all dimension levels, not just the rows present in the input. - [KPI Charts](https://docs.valsight.ai/kpi-charts.md): Show a single key figure as one large number, optionally with a reference value and a comparison. - [Level Indicators on Nodes](https://docs.valsight.ai/level-indicators-on-nodes.md): The Visual Level Indicators feature enhances the Model Editor by visually representing where dimensionality changes occur within driver trees. Color-coded le… - [LEVELFILTER](https://docs.valsight.ai/levelfilter.md): Filters the input to rows where a certain condition is met between level values of two compared levels. - [Licenses, User Types & Access Management](https://docs.valsight.ai/licenses-user-types-access-management.md): Valsight is licensed based on the number of named users. A named user is any natural person authorized by the customer to use the software under the terms st… - [Limitations & Data Sizing Guidelines](https://docs.valsight.ai/limitations-data-sizing-guidelines.md): Valsight allows you to build complex models and the performance of the system is dependent on the actual model and especially the amount of data that is crea… - [Line-Item Data & Details](https://docs.valsight.ai/line-item-data-details.md): To see the data of a Line-Item, click on the name the Line-Item. - [Line-Item Filters](https://docs.valsight.ai/line-item-filters.md): Permanently filters a Line-Item to the selected criteria. Has an effect on following calculations. Is saved an effects all users. When sharing a scenario, on… - [Line-Item Variants](https://docs.valsight.ai/line-item-variants.md): Line-Item variants can be understood as different variations of a single Line-Item and are implemented in the Scenario Manager. - [Line-items](https://docs.valsight.ai/line-items.md): Line-items are the smallest unit of change in a simulation. Each line-item defines how the value of a single node is adjusted within an assumption. - [Linked levels](https://docs.valsight.ai/linked-levels.md): Levels in your dimension can be extended with information by adding labels. - [LN](https://docs.valsight.ai/ln.md): Returns the natural logarithm of a number (logarithm with base e ~2.718), while retaining all dimensions. Use when you need a natural logarithm transformation for positive numeric values. - [Locking and Unlocking of Projects](https://docs.valsight.ai/locking-and-unlocking-of-projects.md): - Project admins can lock a project to finalize modeling in the creation process - [LOG](https://docs.valsight.ai/log.md): This example calculates the logarithm of input values using a separate node to define the base for each year. - [Logging](https://docs.valsight.ai/logging.md): Logging is separated into application-level logging (security audit log) and webserver-level logging. - [Logging Configuration](https://docs.valsight.ai/logging-configuration.md): NOTE: In application versions that use older version of Grails (Prior to Valsight Version 6) the configuration of logback was done using a logback.groovy fil… - [Logging in the Backend](https://docs.valsight.ai/logging-in-the-backend.md): How admin users configure backend logging levels and download log files from the System Configuration page. - [Logical functions](https://docs.valsight.ai/logical-functions.md): Use this category when you need conditions, comparisons, and branching logic in formulas. - [Login Page Customization](https://docs.valsight.ai/login-page-customization.md): The login page can be customized in the global settings under "Login Page Settings". - [LOOKUP](https://docs.valsight.ai/lookup.md): Performs an approximate match lookup in one column and returns the corresponding value from another column. - [LT (<)](https://docs.valsight.ai/lt.md): Checking whether one input is less than another - [LTE (<=)](https://docs.valsight.ai/lte.md): Checking whether one input is less than or equal to another - [Mail Server](https://docs.valsight.ai/mail-server.md): ON PREMISE This article applies only to Valsight On-Premise. Contact support for Cloud installations. - [Mailing Log Files to the Valsight support](https://docs.valsight.ai/mailing-log-files-to-the-valsight-support.md): The Valsight Backend keeps track of errors that occurred during the usage of the product. These provide valuable details for our development team. These log … - [Manage Users and Groups](https://docs.valsight.ai/manage-users-and-groups.md): As an administrator, open the System Configuration and find the users section. - [Managing Exports](https://docs.valsight.ai/managing-exports.md): - Each export and its versions are stored in Valsight for seven days by default, so that you can download, share or revisit them at a later date, but still m… - [Math & numeric](https://docs.valsight.ai/math-numeric.md): Use this category when you need numeric transformations and helpers in formulas. - [MAX](https://docs.valsight.ai/max.md): The MAX function returns the maximum of matching values from two inputs. Both inputs must have either the same dimensionality or one input must be a number, in which case the result has the dimensionality of the other input. - [Migration Guide](https://docs.valsight.ai/migration-guide.md): The whole configuration moves from the grails section into the spring section. - [MIN](https://docs.valsight.ai/min.md): The MIN function returns the minimum of matching values from two inputs. Both inputs must have either the same dimensionality or one input must be a number, in which case the result has the dimensionality of the other input. - [Mixed Charts](https://docs.valsight.ai/mixed-charts.md): A mixed chart lets you show each data series differently, so bars and lines can sit in the same chart. - [MOD](https://docs.valsight.ai/mod.md): Use when you need the remainder after dividing one value by another, for example for bucket logic or periodic patterns. - [Model Editor UI](https://docs.valsight.ai/model-editor-ui.md): The Model Editor is the central screen for building and maintaining models in Valsight. - [Model Tree](https://docs.valsight.ai/model-tree.md): Show the model behind the numbers on a worksheet, as a graph of connected nodes carrying values per scenario. - [Model Validation](https://docs.valsight.ai/model-validation.md): Verify that your model's formulas follow correct syntax and are compatible with connected base data. - [Modeling](https://docs.valsight.ai/modeling.md): Models in Valsight define the underlying calculation logic that connects data, business logic, and drivers as the basis for scenario simulation. - [Modelle](https://docs.valsight.ai/modelle.md): Diese Seite bietet eine Sammlung von Tutorials und Anleitungen zur Modellierung. - [Models](https://docs.valsight.ai/models.md): Submodels help structure large models by splitting logic into smaller, focused parts. They make complex models easier to understand, maintain, and work on to… - [MOM_ABS](https://docs.valsight.ai/mom-abs.md): Returns the absolute month-over-month growth by calculating the difference between the current and previous month. Missing months can be skipped or treated as zero, depending on the selected behavior. - [MOM_REL](https://docs.valsight.ai/mom-rel.md): Returns the relative month-over-month growth (percentage change) between the current and previous month. Missing months can be skipped or treated as zero, depending on the selected behavior. - [MOVINGAVG](https://docs.valsight.ai/movingavg.md): The MOVINGAVG function returns the moving average over the last WindowSize elements including the current one, returning null for entries where the window cannot be fully filled. - [MOVINGSUM](https://docs.valsight.ai/movingsum.md): The MOVINGSUM function returns the moving sum over the last WindowSize elements including the current one, returning null for entries where the window cannot be fully filled. - [Multidimensional Data Upload (2D/3D/4D Tables)](https://docs.valsight.ai/multidimensional-data-upload-2d-3d-4d-tables.md): If your source systems present data in some sort of formatted table rather than a structured "database like" table you can use the 2D and 3D upload functiona… - [MULTIPLICATION (*)](https://docs.valsight.ai/multiplication.md): The MULTIPLICATION operator multiplies two inputs across their combined dimension set. In other words, multiplication uses the union of both inputs’ dimensions. - [MULTIPLY](https://docs.valsight.ai/multiply.md): The MULTIPLY function extends the * operator with optional validation for missing rows. It produces the same result as 'Node1' * 'Node2' when validation passes. When validation fails, it produces an error with a detailed explanation of which rows are missing. - [Naming Guidelines](https://docs.valsight.ai/naming-guidelines.md): Object Guideline Notes Good Example Bad Example - [NEQ (!=)](https://docs.valsight.ai/neq.md): Checking whether matching rows are different - [Node Actions](https://docs.valsight.ai/node-actions.md): Nodes can be changed individually or in batches - [Node Editor](https://docs.valsight.ai/node-editor.md): The Node Editor is the right-hand panel in the Model Editor where individual nodes are configured. It controls how a node behaves, how its values are display… - [Nodes](https://docs.valsight.ai/nodes.md): Nodes are the fundamental building blocks of a model. Each node represents a value or calculation, and together they form a dependency graph that defines how… - [NONSIM](https://docs.valsight.ai/nonsim.md): The NONSIM function returns the value of a node with no assumptions applied to that node. Upstream nodes that affect the input still have their assumptions applied. - [NOT](https://docs.valsight.ai/not.md): Inverts the input values with the logical NOT operation. If the input is true (non-zero), false (0) is returned, and true (1) otherwise. Use when you want to invert an existing logical condition so true becomes false and false becomes true. - [NPER](https://docs.valsight.ai/nper.md): Calculates the number of periods needed for a recurring investment, given an interest rate, periodic payment, and present value. - [NPV](https://docs.valsight.ai/npv.md): Calculates the net present value of an investment from a discount rate and a series of cash flows (payments and income). - [Number Style](https://docs.valsight.ai/number-style.md): You may customize the number rendering. - [oAuth 2.0 for URL External Data Source Authentication Configuration](https://docs.valsight.ai/oauth-2-0-for-url-external-data-source-authentication-configuration.md): To configure the Valsight application to allow for the use of oAuth 2.0 providers for authentication when importing an external data source for URL, edit the… - [oAuth 2.0 with Private Key JWT Client Authentication](https://docs.valsight.ai/oauth-2-0-with-private-key-jwt-client-authentication.md): It is possible for the Valsight application to authenticate with the authorization server by creating and signing a JWT using a private key which is sent to … - [On-Premise Configuration Guide](https://docs.valsight.ai/on-premise-configuration-guide.md): After successful Installation, the Valsight application server should be running and should be accessible through a URL such as http://localhost:8080/. Enter… - [On-Premise Installation](https://docs.valsight.ai/on-premise-installation.md): Find specific instructions for installation and configuration of your local Valsight server. - [On-Premise Installation Guide](https://docs.valsight.ai/on-premise-installation-guide.md): The Valsight platform is a standalone server application. It is recommended to install the Valsight application on a dedicated (virtual) machine. - [OpenID Connect](https://docs.valsight.ai/openid-connect.md): To configure the Valsight application to use the OpenID Connect SSO, edit conf/config.yml and restart the server after making changes. - [Operators](https://docs.valsight.ai/operators.md): Operators are the basic building blocks used in formulas to combine values, compare results, and create conditions. They are used directly in formulas, and often inside functions such as IF. - [OR (||)](https://docs.valsight.ai/or.md): Returns 1 (true) if at least one of two inputs is true; otherwise returns 0 (false). Non-zero values are treated as true, while 0 is treated as false. - [Overlapping Data Labels](https://docs.valsight.ai/overlapping-data-labels.md): Why some data labels are missing when they collide in a chart, and the two ways to get the values back. - [Overwriting Project Variables](https://docs.valsight.ai/overwriting-project-variables.md): Variable values defined at the project level can be overridden per scenario in the Scenario Manager. This makes it possible to simulate different planning as… - [Parallel Access](https://docs.valsight.ai/parallel-access.md): With the functionality of parallel access, Valsight enables users to: - [Parallel Access in the Model Editor](https://docs.valsight.ai/parallel-access-in-the-model-editor.md): Parallel editing allows multiple users to access and work on the same model simultaneously in the Model Editor. This feature significantly improves collabora… - [Part 1: Create a Project](https://docs.valsight.ai/part-1-create-a-project.md): In this part, you create a new Valsight project and define its time horizon. - [Part 2: Set Up Dimensions](https://docs.valsight.ai/part-2-set-up-dimensions.md): In this part, you create the dimensions, levels and level values. - [Part 3: Upload Data](https://docs.valsight.ai/part-3-upload-and-validate-data.md): In this part, you upload the sample Excel file and validate that it matches the project dimensions. - [Part 4: Build the Driver Model](https://docs.valsight.ai/part-4-build-the-driver-model.md): In this part, you create two models and build the cause-effect relations of the revenue model. - [Part 5: Simulate](https://docs.valsight.ai/part-5-simulate.md): In this part, you create a workspace, set up assumptions in the Scenario Manager, and activate a simulation scenario. - [Part 6: Analyze Results](https://docs.valsight.ai/part-6-analyze-results.md): In this part, you create different chart types to inspect the simulation results. - [Partner Policy](https://docs.valsight.ai/partner-policy.md): At Valsight GmbH (“Valsight”), we believe that strong, trusted partnerships are essential to shared success. - [Performance Flags](https://docs.valsight.ai/performance-flags.md): Config Option Setting Effect Recommendation for 8GB / 4 core VM - [Perspective Selector](https://docs.valsight.ai/perspective-selector.md): The Perspective Selector is a new interactive chart type introduced for enhancing presentations in Valsight. Its primary purpose is to enable decision-makers… - [PM](https://docs.valsight.ai/pm.md): Shifts the input node one month into the future while retaining all other dimensions. Use this when you need last month's values alongside current data for month-over-month comparisons. - [PMT](https://docs.valsight.ai/pmt.md): Calculates the periodic payment required for a recurring investment, given an interest rate, number of periods, and present value. - [POWER](https://docs.valsight.ai/power.md): Raises values from the first input to the power of the second, using the first as the base and the second as the exponent. Both inputs can be numbers or node references. - [PQ](https://docs.valsight.ai/pq.md): Shifts the input node one quarter into the future while retaining all other dimensions. Use this when you need last quarter's values alongside current data for quarter-over-quarter comparisons. - [Predefined Keywords](https://docs.valsight.ai/predefined-keywords.md): The following column names are automatically defined as measures: - [Presentation Favorites Headline](https://docs.valsight.ai/presentation-favorites-headline.md): The header of the "Show all favorites" page can be customized. - [PREVIOUS](https://docs.valsight.ai/previous.md): The PREVIOUS function returns the previous period value of a node with a defined base case, enabling loop-style calculations along the time dimension. - [Project Rights](https://docs.valsight.ai/project-rights.md): On this page, we will show you how to edit and manage project permissions in Valsight. As an example we want to grant a user "test.user" the right to work on… - [Project Settings](https://docs.valsight.ai/project-settings.md): The settings of projects can be accessed via the navigation bar settings (admin UI) and then selecting projects or directly from the project overview page. - [Project Variables](https://docs.valsight.ai/project-variables.md): Project variables let you define shared values once, for time, data sources, or any other shared input, and reuse them across models and scenarios. They ke… - [Projects](https://docs.valsight.ai/projects.md): Projects in Valsight are the top-level containers that bundle together dimensions, data sources, models, workspaces, and scenarios for a specific planning us… - [Projektverzögerung](https://docs.valsight.ai/projektverzoegerung.md): Projektverzögerung - [PV](https://docs.valsight.ai/pv.md): Calculates the present value of a recurring investment, given an interest rate, number of periods, and periodic payment. - [PW](https://docs.valsight.ai/pw.md): Shifts the input node one week into the future while retaining all other dimensions. Use this when you need last week's values alongside current data for week-over-week comparisons. - [PY](https://docs.valsight.ai/py.md): Shifts the input node one year into the future while retaining all other dimensions. Use this when you need last year's values alongside current data for year-over-year comparisons. - [Python Example](https://docs.valsight.ai/python-example.md): The following script connects to the api key endpoint, stores the cookie in the sessions and prints out all projects found in the instance. - [QOQ_ABS](https://docs.valsight.ai/qoq-abs.md): Returns the absolute quarter-over-quarter growth by calculating the difference between the current and previous quarter. Missing quarters can be skipped or treated as zero, depending on the selected behavior. - [QOQ_REL](https://docs.valsight.ai/qoq-rel.md): Returns the relative quarter-over-quarter growth (percentage change) between the current and previous quarter. Missing quarters can be skipped or treated as zero, depending on the selected behavior. - [Quickstart: 10 common functions](https://docs.valsight.ai/quickstart-10-common-functions.md): This page highlights the functions you’ll use most often when bringing in data, shaping dimensionality, filtering slices, and building time logic. - [RATE](https://docs.valsight.ai/rate.md): Solves for the interest rate per period of an annuity, given the number of periods, the periodic payment, and the present value. - [RATIO](https://docs.valsight.ai/ratio.md): Divides one node by another while retaining only their shared dimensions, recalculating the ratio dynamically at each aggregation level. Intended for display-only ratios in dashboards and reports. - [REBOOK](https://docs.valsight.ai/rebook.md): The REBOOK function moves value measures from one level value to another within the same level, setting source values to zero and adding amounts to the target value. - [REDISTRIBUTE](https://docs.valsight.ai/redistribute.md): Calculates a weighted redistribution of the RedistributionValue following the specified DistributionWeight, staying within the boundaries of clusters specified by the ClusterLevels. - [Release History](https://docs.valsight.ai/release-history.md): Overview of all Valsight major versions with their current minor version, support status, release date, end of support, and the SHA1 checksum of each release package. - [Release Notes](https://docs.valsight.ai/release-notes.md): Release Notes - [Resetting the Database CHANGELOGLOCK](https://docs.valsight.ai/resetting-the-database-changeloglock.md): If the Valsight Server process gets interrupted during a regular startup, the database may end up in a locked state. - [Responsive Chart Text Sizes](https://docs.valsight.ai/responsive-chart-text-sizes.md): Let chart, axis, table and KPI text scale with the size of the window, set per instance or per workspace. - [Restructuring Data in Excel using Power Query](https://docs.valsight.ai/restructuring-data-in-excel-using-power-query.md): Learn to transform your Excel document to fit the guidelines for data used in Valsight with Power Query! - [Reverse Proxy](https://docs.valsight.ai/reverse-proxy.md): To allow for the use of the application behind a reverse proxy the following headers must be sent in requests: - [ROLLFORWARD](https://docs.valsight.ai/rollforward.md): The ROLLFORWARD function rolls the values of the Original Node forward with the influence of optional driver nodes. - [ROLLFORWARD_ADVANCED](https://docs.valsight.ai/rollforward-advanced.md): ROLLFORWARD_ADVANCED is an advanced projection function that rolls data forward in time using drivers and optional parameters like aging levels, window settings, and projection modes to forecast future values based on historical data. - [ROLLFORWARD_MUL](https://docs.valsight.ai/rollforward-mul.md): ROLLFORWARD_MUL rolls the values of the Original Node forward, optionally influenced by one or more driver nodes whose effects are compounded multiplicatively. - [Rollforward & time series](https://docs.valsight.ai/rollforward-time-series.md): Use this category when you need time-based logic such as projections, running totals, moving windows, and timing effects. - [ROLLUP](https://docs.valsight.ai/rollup.md): The ROLLUP function aggregates values by reducing a node to only specified levels, removing all other levels and combining their values. - [ROLLUP_TO](https://docs.valsight.ai/rollup-to.md): ROLLUP_TO automatically rolls up a node to match the dimensionality of another target node by removing extra levels and aggregating their values. - [ROUND](https://docs.valsight.ai/round.md): The ROUND function rounds each value of the input node to the specified number of decimal digits. The rounding behavior and precision can be controlled with optional parameters. - [Running Inside Docker](https://docs.valsight.ai/running-inside-docker.md): This article does not apply to Cloud installations. - [RUNNINGPROD](https://docs.valsight.ai/runningprod.md): RUNNINGPROD calculates the cumulative product of a node along the time axis, multiplying each value by all preceding values in the time series. - [RUNNINGSUM](https://docs.valsight.ai/runningsum.md): RUNNINGSUM calculates a cumulative total along the time axis, where each period's value equals the sum of all values from the first non-empty period up to and including the current period. - [SAML](https://docs.valsight.ai/saml.md): To configure the Valsight application as a Service Provider (SP) in a SAML infrastructure, edit conf/config.yml and restart the server after making changes. - [Scale-out with load balancer](https://docs.valsight.ai/scale-out-with-load-balancer.md): How to scale out Valsight servers behind a load balancer for on-premise installations. - [Scenario Bridges](https://docs.valsight.ai/scenario-bridges.md): A scenario bridge explains the difference between two or more scenarios, broken down by assumption, line-item or dimension. - [Scenario Colors](https://docs.valsight.ai/scenario-colors.md): - Scenarios can be colored to better trace their influence on your simulations - [Scenario Manager](https://docs.valsight.ai/scenario-manager.md): Learn what the Scenario Manager is, what it does, and which parts of Valsight it ties into. - [Delta Comparisons](https://docs.valsight.ai/scenario-time-or-dimension-level-comparison-delta.md): Add a delta comparison to a table so it shows the change between two scenarios, periods or dimension levels, and pick the method that suits your data. - [Scenario Versioning](https://docs.valsight.ai/scenario-versioning.md): On this page you will find a general description of scenario versions as well as a tutorial on how to create them. - [Scenarios](https://docs.valsight.ai/scenarios.md): Scenarios describe possible future developments of your business. They combine assumptions and measures to explore how outcomes change under different condit… - [SCHEDULEPROJECTS](https://docs.valsight.ai/scheduleprojects.md): Combines project KPI blueprints over time with timing information that defines when projects start. - [Secure Statistics Collection](https://docs.valsight.ai/secure-statistics-collection.md): Statistics about the usage of Valsight help us to create better features, improve existing functionality and identify and fix potential technical problems. - [Security audit log](https://docs.valsight.ai/security-audit-log.md): The following page explains the different events that are logged when using the 'Security audit log'. - [Security Configuration](https://docs.valsight.ai/security-configuration.md): Valsight offers you to set your security configuration individually, to ensure a user and company optimized setting. - [Server Configuration](https://docs.valsight.ai/server-configuration.md): Typical Setups use a separate reverse proxy as SSL Endpoint instead of the integrated SSL functionality. See Deployment overview. - [Sharing Exports](https://docs.valsight.ai/sharing-exports.md): With the introduction of the Export Manager, it is now possible to provide access to exports for other projects in the same Valsight instance. In this way, t… - [Sharing Scenarios](https://docs.valsight.ai/sharing-scenarios.md): When you share a Scenario, a snapshot of it is created that includes all of its current Assumptions and their data. This will become available to all users. - [SHIFT](https://docs.valsight.ai/shift.md): The SHIFT function shifts the input node by a given offset amount on a specified level. The shift amount can be a constant number or a node that provides different offsets per entry. - [Shifting Assumptions](https://docs.valsight.ai/shifting-assumptions.md): Simulate the effect of revenue & cost streams as well as cash inflows & outflows delay or advancement through shifting an Assumption or its part. The shift d… - [SIGNUM](https://docs.valsight.ai/signum.md): Extracts the sign of a number. Positive numbers become 1, negative numbers become -1, and zero remains 0. Use when you need to reduce a value to its sign for directional logic, classification, or further numeric transformations. - [Simulations & Analysis](https://docs.valsight.ai/simulations-analysis.md): Simulations in Valsight build scenarios on top of a data baseline by applying line items to simulatable nodes, and analysis compares and interprets those sce… - [Single-Sign-On (SSO) Configuration](https://docs.valsight.ai/single-sign-on-sso-configuration.md): Valsight Supports SAML2.0 and Open ID Connect for Authentication with your IdP. - [Sliders](https://docs.valsight.ai/sliders.md): Put the sliders for chosen line-items on the worksheet, so simulations can be run without opening the Scenario Manager. - [Sliders in the Scenario Manager](https://docs.valsight.ai/sliders-in-the-scenario-manager.md): Sliders in the Scenario Manager allow you to modify existing line-items with the ease of a slider without having to enter the line-item data itself. - [Sort Key Settings in Nodes](https://docs.valsight.ai/sort-key-settings-in-nodes.md): Set a sort key on a node to control the order nodes appear in within a model tree. - [Sorting Level Values](https://docs.valsight.ai/sorting-level-values.md): Put the level values of a chart or table in a custom order, per level and per chart. - [Split Sliders](https://docs.valsight.ai/split-sliders.md): A split slider redistributes a total across its parts on the worksheet, keeping the total fixed as you move the handles. - [SQRT](https://docs.valsight.ai/sqrt.md): Returns the square root of each value in the input. Use when you need the square root of positive values for scaling, normalization, or mathematical transformations. - [Stacking and Stack Totals](https://docs.valsight.ai/stacking-and-stack-totals.md): Stack the bars or areas of a chart so the data series add up to one total, and choose whether to label that total. - [STRETCH_CURVE](https://docs.valsight.ai/stretch-curve.md): Stretches the curve or curves defined in the curves input over the X axis by a factor defined in the stretch input. - [Structure Driver Models](https://docs.valsight.ai/structure-driver-models.md): This guide shows you how to structure a Valsight model so that it stays understandable, scalable, and easy to maintain as it grows. By the end, your model wi… - [Styling Data Series, Columns and Rows](https://docs.valsight.ai/styling-data-series-columns-and-rows.md): Style a chart's data series or a table's columns and rows, from color and value labels to subtotal and total formats. - [Subprocessors](https://docs.valsight.ai/subprocessors.md): We host our platform primarily within the EU/EEA, apply encryption at rest, and work only with carefully vetted sub-processors that meet rigorous security st… - [SUBTRACTION (-)](https://docs.valsight.ai/subtraction.md): The SUBTRACTION operator subtracts one input from another after aligning both inputs to their common dimensions. In other words, subtraction uses the intersection of the shared dimensions. - [Supported Archiving Methods](https://docs.valsight.ai/supported-archiving-methods.md): Item Cloud Customers On-Premise Customers / Valsight Corporate Server - [Supported Browsers](https://docs.valsight.ai/supported-browsers.md): Name Version Valsight Support Guideline - [Table Formatting](https://docs.valsight.ai/table-formatting.md): Set the table style, resize columns, and control which header cells are merged in a table. - [Target Value Setting](https://docs.valsight.ai/target-value-setting.md): In this article, you will learn what the target setting function does and how to use it. - [Technical & Minor Version Release Notes](https://docs.valsight.ai/technical-minor-version-release-notes.md): A comprehensive list of all technical information regarding new releases. Includes warnings, which usually have implications on existing models and settings,… - [Template Manager](https://docs.valsight.ai/template-manager.md): The Template Manager can be found through the tab in the top right corner of the Export Manager and allows users to manually create customized export templates. - [Time Bridges](https://docs.valsight.ai/time-bridges.md): A time bridge explains the change between two or more points in time within one scenario, using the effects of assumptions and line-items. - [TIMELAG](https://docs.valsight.ai/timelag.md): The TIMELAG function calculates time-lagged effects on a chosen time granularity, distributing each input value over future periods according to a lag profile. - [Training](https://docs.valsight.ai/training.md): Der Trainingsbereich bietet umfassende Tutorials, die Schritt für Schritt durch verschiedene Funktionen der Software führen. Diese Anleitungen ermöglichen es… - [Export-Manager](https://docs.valsight.ai/training-export-manager.md): Diese Seite bietet Tutorials und Anleitungen rund um das Thema Export Manager. - [Trainingsmodelle - Modelle](https://docs.valsight.ai/trainingsmodelle-modelle.md): Hier befinden sich Trainingsmodelle zum Nachbauen - [Troubleshooting guide](https://docs.valsight.ai/troubleshooting-guide.md): Use this guide when a node formula returns unexpected results, for example empty output, wrong granularity, or wrong numbers. - [TRUE](https://docs.valsight.ai/true.md): The TRUE function returns 1 for every defined value in the input node. Undefined intersections remain undefined in the result. - [Tutorials - Modelle](https://docs.valsight.ai/tutorials-modelle.md): In diesem Video erfährst du, wie du in Valsight ein neues Projekt erstellst. Du lernst, einen Projektnamen, einen Business Key und den passenden Zeithorizont… - [UNION](https://docs.valsight.ai/union.md): The UNION function combines the result sets of two or more input nodes into one output. All inputs must have the same levels and must not have overlapping rows. - [Units](https://docs.valsight.ai/units.md): Units in Valsight are display labels assigned to model nodes, such as EUR, km, or compound units like EUR / km. They help users interpret values in context an… - [Update / Upgrade the installation](https://docs.valsight.ai/update-upgrade-the-installation.md): Follow these simple steps to keep the software up-to-date. - [Updating level values via data source upload](https://docs.valsight.ai/updating-level-values-via-data-source-upload.md): To use this feature the dimensions and level values to be updated need to already exist. Create them first in the dimension management. - [User Authentication](https://docs.valsight.ai/user-authentication.md): Valsight can delegate the user authentication to your enterprise authentication service. Our recommended integration method is Single-Sign-On with OpenIDConn… - [User Settings](https://docs.valsight.ai/user-settings.md): Personal account settings in Valsight: password, language, and keyboard shortcuts. - [Using Project Variables in Node Formulas](https://docs.valsight.ai/using-project-variables-in-node-formulas.md): In the node formula editor, type $ to open the variable picker and select from the list of available variables. - [Using the AI Assistant](https://docs.valsight.ai/using-the-ai-assistant.md): Use the Valsight AI Assistant to understand models faster, get oriented in complex projects, and create documentation more easily. - [Using the Presentation Mode](https://docs.valsight.ai/using-the-presentation-mode.md): Create a static snapshot of a workspace and present it view-only, or keep it as a record of where the plan stood. - [Using Workflows (For Contributors)](https://docs.valsight.ai/using-workflows-for-contributors.md): The guide for individual contributors importing and submitting workflow steps - [Validate Dimensions](https://docs.valsight.ai/validate-dimensions.md): You can use the "Validate Dimensions" functionality to check that all level values are present in the Dimension table. - [Validation Nodes](https://docs.valsight.ai/validation-nodes.md): Validation nodes let you define custom conditions inside your model that flag deviations during validation checks. - [Validations](https://docs.valsight.ai/validations.md): Validations check that your data, models, and workspaces are correctly configured, compatible, and working as intended. - [Valsight API Client](https://docs.valsight.ai/valsight-api-client.md): To download the client, contact the Valsight Support at support@valsight.com . - [Valsight CERT & ISO](https://docs.valsight.ai/valsight-cert-iso.md): Get in Touch with the Valsight Computer Emergency Response Team (CERT) - [Valsight Enterprise Cloud Hosting Options - Comparison](https://docs.valsight.ai/valsight-enterprise-cloud-hosting-options-comparison.md): Valsight Enterprise Cloud Hosting Options - Comparison - [Valsight Pluggable Modules - Security Architecture](https://docs.valsight.ai/valsight-pluggable-modules-security-architecture.md): As part of consulting projects, Valsight or a consulting partner may develop specialized Modules that allow the user to process Excel in specific formats, or… - [Versioning](https://docs.valsight.ai/versioning.md): Versioning - [Versioning of Exports](https://docs.valsight.ai/versioning-of-exports.md): The Export Manager allows you to version your export. This means, that when creating the first export for a scenario, we are creating an export for you along… - [Visualizing Data](https://docs.valsight.ai/visualizing-data.md): Choose a chart type, create a chart, format it so it reads well, and present the result to others. - [Währungseffekte](https://docs.valsight.ai/waehrungseffekte.md): Währungseffekte - [Warnings on Nodes](https://docs.valsight.ai/warnings-on-nodes.md): Nodes with active validation errors display a warning icon in their top-right corner. This lets you spot and address issues directly in the Model Editor with… - [Workflows](https://docs.valsight.ai/workflows.md): Workflows are Valsight's internal project management tools that enable smooth collaboration between multiple business units and levels by sharing scenarios i… - [Working with different Model Baselines](https://docs.valsight.ai/working-with-different-model-baselines.md): Baselines allow you to maintain multiple versions of logic and results within a single model. They make it possible to compare different scenarios, such as Ac… - [Working with the Model Definition Editor](https://docs.valsight.ai/working-with-the-model-definition-editor.md): Valsight allows to edit models in a textual representation. In the admin UI, select Projects, then Models, find the model you want to edit and open the "Defi… - [Worksheet Filter](https://docs.valsight.ai/worksheet-filter.md): Worksheet filters are the second level of filter available in Valsight. - [Workspace Filter](https://docs.valsight.ai/workspace-filter.md): A workspace filter are the highest level of filter to be set. - [Workspace Validation](https://docs.valsight.ai/workspace-validation.md): Check that your workspace scenarios and model logic function correctly together. - [Workspaces](https://docs.valsight.ai/workspaces.md): - Workspaces are a fundamental part of Valsight and allow you to perform simulations. They are a sandbox in which you can create simulation scenarios and vis… - [WOW_ABS](https://docs.valsight.ai/wow-abs.md): Default: ignoring missing values - [WOW_REL](https://docs.valsight.ai/wow-rel.md): Returns the relative growth for each week compared to the previous week (week-over-week). - [XML Access](https://docs.valsight.ai/xml-access.md): All Valsight objects that are exposed via the REST API can be accessed in the XML format. - [XOR](https://docs.valsight.ai/xor.md): Connects two inputs with the logical 'exclusive or' XOR and returns true (1) if exactly one of the input values is true and false (0) otherwise. - [Y-Axis Breaks in Charts](https://docs.valsight.ai/y-axis-breaks-in-charts.md): A Y-axis break inserts a gap into the value axis so charts with large deviations or wide gaps in scale stay readable. - [YOY_ABS](https://docs.valsight.ai/yoy-abs.md): The YOY_ABS function returns the absolute growth for each year compared to the previous year (year-over-year). The result is the difference current_year - previous_year in the same unit as the input. - [YOY_REL](https://docs.valsight.ai/yoy-rel.md): The YOY_REL function returns the relative growth for each year compared to the previous year (year-over-year). - [YTD](https://docs.valsight.ai/ytd.md): The YTD function returns year-to-date values by calculating a running sum per year over the lowest available time level, resetting at the start of each new year.