S

Back to Glossary

sampling

Selecting a representative portion of an entity to determine the entity's characteristics.

save offline copy (break links)

This is used to save a copy of a workbook offline to use elsewhere, but the links to OneStream will be broken and the data will not dynamically update.

saved assumptions

User-defined, planning assumptions that drive key business calculations.

scaling

Determines the display of values in whole numbers, tens, hundreds, thousands, and millions.

scenario

A dimension representing a data set that differs by business use, such as actual, budget, and forecast.

scenario type

A property set on scenario dimension members to group scenario members by similar functionality and behavior. There are 24 pre-set scenario types. This property allows for varying dimensional assignments, rules, workflow hierarchies, workflow properties, and certain member properties.

schema

A logical model representing the data and the relationships between the data.

scorecard

A business object showcasing the progress of an employee, strategy element, or accountability element toward goals.

scraping

An inspection of a data source to derive the most basic metadata elements from it.

security

The foundation of authorizing OneStream system products to use security roles, external authentication, and single sign-on.

security group

An object to which users are assigned that enables access to other objects and data.

security roles

A page on the Application tab, under tools, that is used to set application-specific security.

serial calculation

The default calculation setting.

services

Business items to be retrieved, changed, added, or deleted through resources.

shared storage

A set of disks containing data that must be available to all nodes of a failover cluster.

shared workspace pages

Workspace pages shared across an organization that are stored in a special System folder and can be accessed by authorized users from the shared workspace page navigation menu.

sharing rows/columns

A feature within cube views that uses the column or rows from another cube view instead of creating its own. If this row updates in one location, it will update for any shared cube view.

short description

A field providing the flexibility to add abbreviated descriptions to periods of time.

sibling

A child member at the same generation as another child member that also has the same immediate parent.

single point of failure

Prevents users from accessing the normal functionality when a system component fails.

single sign-on (SSO)

The ability to log on once and then access multiple applications without being prompted again for authentication.

smart tags

Keywords in Microsoft Office applications that are associated with predefined actions available from the Smart Tag menu.

SmartCut

A link to a repository item, in URL form.

snapshot

Read-only information available from a certain period.

snippets

Used within the business rule editor, it provides code examples and detailed explanations.

software as a service (SaaS)

Provides access to software from the cloud along with maintenance and support for a period of time.

solution blending

This is a form of relational blending that combines cube data with the Application Solution tables. Solutions could be the Specialty Planning Solution Suite, Account Reconciliations, or Transaction Matching.

solution table

Tables containing data used in MarketPlace Solutions.

source currency

The currency where values originate is converted through exchange rates to the destination currency.

source ID

A unique identifier for source data defined in the data source as a static value or a source file name using a business rule.

source value

This is the value for the related cube dimension in a defined data field.

sparse dimension

In block storage databases, a dimension that does not contain data for all member combinations when compared to other dimensions.

sparse row suppression

A feature within cube views that provides performance improvements when many non-data records are being queried. This changes how the cube view runs by initially evaluating the data unit first to determine the full population of data generated.

specialty cube

A cube design used for a specific purpose showing basic dimensionality and containing small data sets.

SPF files

Printer-independent files created by an SQR Production Reporting server, containing a representation of the actual formatted report output, including fonts, spacing, headers, and footers.

spot rate

The exchange rate at a designated time.

spotlighter

A tool enabling color coding based on selected conditions.

spreadsheet

A feature providing Excel Add-in functionality without Excel being installed. This tool exists within the OneStream application and has limited Excel functionality.

stage

An application table that holds all the source fields before they are mapped into OneStream dimensionality and loaded into the cube. This contains the fields designated in the data sources.

stage blending

A form of relational blending that combines cube data with data in the stage tables such as attributes or imported data.

stage table

A staging area containing imported data or attributes; typically transactional data that is retrieved for analysis when required.

StageBiBlendTable

Used to store information from the BI Blend tables. This table adds information and the mapping errors.

standard reports

A tab within the Application properties where the PDF version of a cube view configures at a higher level. This controls things like report colors, logos, and fonts for headers and footers.

star schema

A relational representation of multidimensional structures.

static value

An override setting, which allows a hard-coded value to be assigned to a dimension rather than being read from a file or data source.

status bar

The bar at the bottom of the screen that displays helpful information about commands, accounts, and the status of the data file.

stored calculation

A persisted calculation executed as part of the data unit calculation sequence.

stored hierarchy

A hierarchy in which the members are aggregated according to the outline structure.

strategic objective (SO)

A long-term goal defined by measurable results that are associated with one perspective in the application, has one parent, the entity, and is a parent to critical success factors or other strategic objectives.

strategy map

Represents how the organization implements high-level mission and vision statements into lower-level, constituent strategic goals and objectives.

structure view

Shows a subject in the simplest form of elements of data or information items.

structured query language (SQL)

A language used to process instructions to relational databases.

structured query language spreadsheet

A data object displaying the result set of a structured query language.

structured query reporter (SQR)

A language used to generate and create reports in the database.

subaccount numbering

A system for numbering subaccounts using nonsequential whole numbers.

super cube

See linked cube.

supervisor

A user with total admission to all areas within a system such as applications, databases, and security permissions.

supplemental accounts

Extra accounts outside the scope of a typical accounting record that help management do their jobs. For example, details about clients, customers, or their accounts.

suppression

A feature in a cube view that allows rows or columns not to be visible if certain criteria are met. Typically, if there is no data, data is zero or at a given threshold, or the cells queried represent an intersection not valid.

symmetric multiprocessing (SMP)

A server architecture that enables multiprocessing and multithreading that shares a common operating system.

synchronized

Processes in an operating system that keep the same memory of files and data stored in several locations up-to-date.

system administrator

A person responsible for maintaining and controlling a client's OneStream environment.

system defined dimensions

Non-configurable dimensions that are either created by application design/configuration or are system generated and standard across applications. For example, consolidation and origin dimensions.

system security roles

Security roles that control access to complete specific actions within a client's environment.

system user interface roles

Security roles that control access to system pages and tools.