R

Back to Glossary

range rule

Gives the upper and lower limits to be mapped. Any member within this range will be mapped to the corresponding target member. For example, 1000~2000 = 1800.

read and write data

Security properties used to provide view and edit access. These properties are on the Member Properties tab for entity and scenario members.

read data

Security properties used to provide view-only access. These properties are on the Member Properties tab for entity and scenario members.

reciprocal assignment

An assignment in the financial flow that also has the source as one of its destinations.

record

A group of fields making up one complete entry in a database.

recurring template

A journal template used to make similar adjustments in every period.

refresh application

A button on the toolbar used to refresh the application when changes have been made that will affect OnePlace.

refresh page

A button on the toolbar used to refresh the current page.

regular journal

An attribute for entering one-time adjustments for a period.

related accounts

Accounts that are connected to the primary account and grouped under the same main account number.

relational blending

A term for any time cube data blends with data stored in a relational database. This concept also aligns different data sets into a consumable, unified reporting view on a dashboard. BI Blend is not in this category.

relational database

A type of database storing data in the form of related tables.

relationship properties

Settings applied to dimension members. These settings are specific to a member's relationship to another member and can vary by relationship.

replace

A data load option that clears the existing values from all accounts for the periods specified in the data load file and loads the values from the data load file.

report footer

Text or images at the bottom of report pages that include functions or text, such as page numbers, dates, logos, titles, file names, and author names.

report header

A pane in a cube view that displays a header showing the report title. This is only visible in the PDF and Excel exported versions of the cube view.

report object

A basic element with properties highlighting behavior or appearance, such as text boxes, grids, images, and charts.

reporting currency

The currency used to prepare financial statements and convert from local currencies to reporting currencies.

repository

A central location to store and manage metadata and information.

resources

Items or services controlled by the system, such as roles, users, groups, tasks, and records.

restore

While shutting down and restarting the database, this reloads data and structural information after a database has been damaged or destroyed.

restructure

Rebuilding the database index or files.

result frequency

Creating a set of dates to collect and display results through an algorithm.

retrieve

Function in the Excel Add-in used to retrieve data, FX rates, or member and dimension properties.

review level

A process management review status indicator that represents the process unit level.

review profile

Read-only workflows used to review data and sign off by certification.

risk free rate

The rate of return expected from safer investments such as long-term U.S. government securities.

role

The way access permissions are granted to users and groups for resources.

Roll Forward

A process providing the flow and details of data where the end of one period becomes the start of the next period.

row/column templates

A common reporting tactic that creates a cube view group to hold column and row sets shared across many cube views. This incorporates cube view sharing.

rules

User-defined formulas.