Flow Dimension

The Flow Dimension is like the eight User Defined Dimensions in that it can use Extensible Dimensionality® and extend Dimensions across business units and Scenario Types with flexibility. Its Members aggregate up just like the other User Defined Dimensions. The Flow Dimension, however, has some additional settings that help with historical currency overrides and eliminate many common custom scripts in order to perform calculations.

Security

Display Member Group

The group that can see that this Dimension exists within a list of Dimensions.

Settings

For Formula Type, Allow Input and Is Consolidated, see Account Dimension.

Switch Sign

The Flow Member is linked to an Account through Flow constraints. Depending on the Account Type, this property would be set to True to switch the sign of data for the Flow Member or set to False to keep the sign as is. 

Switch Type

Switch the type of data based on the Account attribute, for example setting an Asset to a Revenue. This is useful when treating roll forward Accounts as Income Statement Accounts in the Balance Sheet. Settings are True or False. 

Flow Processing

These settings are used for dollar override values.  In order to be used, an Account must be flagged as true by using the setting UseAltInputCurrencyInFlow. (Except for IsAlternateInputCurrencyforAllAcounts)  The Flow Dimension can hold both values of a dollar override and the settings differ based on how this setting is used.

Flow Processing Type

Is Alternate Input Currency

This option is used to indicate if data should be input into this Flow Member in a currency other than the entity’s local currency. This setting works similarly to Is Alternate Input Currency for All Accounts, except it only applies to a specified list of accounts that are configured in the Account dimension.

If selected, this setting activates Alternate Input Currency Flow Member Property, where you can select a specific currency from the list configured through the Application Properties. Choose the accounts that should be overridden by setting the Use Alternate Input Currency property to true for a specified list of accounts.

This is used when currency overrides are implemented. Many times OneStream applications spanning multiple currencies have this requirement to override the translated amount with a specific value. The most common use case for this setting is for overriding the USD amount for Balance Sheet Accounts.

Is Alternate Input Currency for All Accounts

This option is used to indicate if data should be input into this Flow Member in a currency other than the entity’s local currency. This setting works similarly to Is Alternate Input Currency, except it applies to all accounts and no further set up is required on the Account dimension.

If selected, this setting activates Alternate Input Currency Flow Member Property, where you can select a specific currency from the list configured through the Application Properties.

This is used when currency overrides are implemented. Since this opens currency overrides for all accounts, the use cases will vary. One common use case is if data for an entire entity is loaded in two or more separate currencies instead of translating.

Translate using Alternate Input Currency, Input Local  

This will override the translated value with the amount input at the local currency level.

Translate using Alternate Input Currency, Derive Local

This will override the translated value and change the local currency value to be derived based on what the local currency rate would be. This setting probably should not be used in a trial balance unless accounting for the out of balance condition that might result. 

Alternate Input Currency

This setting contains a list of all available currencies to put in for the source value override. If this Flow Member has a USD override, then it should be set to USD. If the override is a EUR override, then it should be set to EUR. Typically, this is the default currency of the application, but can also be used in instances of functional currency. 

Source Member for Alternate Input Currency   

Define the actual Flow Member to override the value for the current Flow Member.

Vary by Scenario Type and Time

See Account Dimension.