OneStream XF – Book Components

OneStream Books are made up of components, which establish what the book contains and how the items are run. The components include Files, Excel Export Items, Reports, Loops, If, Else If, and Else Statements, and Change Parameters.

Loops, If Statements, Else If Statements, Else Statements, and Change Parameters determine how the Files, Excel Items, or Reports run. They allow users to alter the output of the book. A book called ‘IfStatements’ demonstrates how each of these components works.

components

The first component is the Loop. A loop processes the book multiple times, based on how many items you have in the Loop Definition. For the ‘IfStatement’ Book, the Loop runs twice – once for V#Periodic and once for V#YTD. Each report in the book will populate for Periodic and YTD.

loop

Next, the If Statement processes the report underneath it. This If Statement executes if the Workflow Period is January – June. Also, ‘WFSubPeriod’ is a OneStream object that calls the numerical value of the period dimension.if-stmt

The Report attached to the If Statement is a Balance Sheet report. So, the book reads the first step as: ‘If the Workflow Period is Jan – Jun, run the Balance Sheet report’.

if-report

The next item is the Else If Statement. This component is defined for Workflow Periods July – November.

else-if-stmt

The Report following the Else If Statement is the Income Statement report. So, this second step reads as: ‘Else if the Workflow Period is Jul – Nov, run the Income Statement report’.

else-if-report

Finally, the Else Statement is the last step of the book. This step will run for all other conditions left out of the If and Else If Statements. The If Statement runs for Jan – Jun, and the Else If Statement runs for Jul – Nov. Therefore, the Else Statement will run for only December. Lastly, because the Period is December, I want to see both the Balance Sheet and Income Statement reports.

else-stmt

Change Parameters can either modify the Workflow, POV, Variables, or Parameters. Since the reports included in the Else Statement will only run if the Workflow Period is Dec, I included a Change Parameter to change the POV of the reports. I want to see the reports at the C#Top, where they were previously running for C#Local.

change-param

The Balance Sheet Cube View has ‘Local’ under the Consolidation dimension. So the Change Parameter overrides the Cube View POV to run at C#Top.

bal-sheet-pov

Here is the Balance Sheet report.

else-bs

In Addition, here is the Income Statement report.

else-is

In conclusion, Book Components are incorporated into books to modify how the Files, Excel Items, or Reports execute. These components include Loops, If Statements, and Change Parameters. A loop executes a book for however many variables exist in the Loop Definition. So if there are two items, users see each report for two different members. The ‘IfStatement’ book has V#Periodic and V#YTD defined, so the Balance Sheet and Income Statement will be run for both Views.

WEBINAR

Building to the ‘Top’ with OneStream: HFM Replacement Story

If, Else If, and Else Statements apply a conditional aspect to the book. The book passes through the first statement. If the conditions are not met, it moves to the next statement. As a result, this process continues until all statements in the book are evaluated. The ‘IfStatement’ book will run the Balance Sheet report if the Workflow Period is Jan – Jun. It will run the Income Statement report if the period is Jul – Nov. Finally, the book will run both reports if the Workflow period is Dec.

Change Parameters overwrite existing Workflow, POV, Variables, and Parameters. In the ‘IfStatement’ book, a Change Parameter was applied to the Else Statement. This overrides the Consolidation Member in order to display Year-End data.

Most of all, by incorporating these components into books, users can make more complex books and reduce the total number of books necessary.

Share this

About the author

Philip Parker

The Pre-Transformation Checklist for Finance

An 11-Step Risk Reduction Tool for CFOs and CAOs Who Aren’t Sure Where to Start

By following this checklist, organizations can systematically approach their finance technology transformation, ensuring that all critical aspects are addressed and that the transition is smooth and successful.

Related posts you might like

Building to the ‘Top’ with OneStream: An HFM Replacement Story

View Post
CPM

An introduction to Corporate Performance Management Software (CPM)

View Post

HollandParker Named 2022 Power of the Platform Winner by OneStream

View Post

Privacy Policy

Introduction

Welcome to Holland Parker. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about our policy or our practices with regard to your personal information, please contact us at [email protected].

Information We Collect

We collect personal information that you provide to us when expressing an interest in obtaining information about us or our products and services, when participating in activities on the website, or otherwise contacting us.

The personal information that we collect depends on the context of your interactions with us and the website, the choices you make, and the products and features you use. The personal information we collect can include the following:

  • Name and Contact Data: We collect your first and last name, email address, postal address, phone number, and other similar contact data.
  • Payment Data: We collect data necessary to process your payment if you make purchases, such as your payment instrument number (e.g., a credit card number), and the security code associated with your payment instrument.
  • Login Credentials: We collect passwords, password hints, and similar security information used for authentication and account access.
  • Other Information: We collect any other information you directly provide to us through our website.

How We Use Your Information

We use personal information collected via our website for a variety of business purposes described below. We process your personal information for these purposes in reliance on our legitimate business interests, in order to enter into or perform a contract with you, with your consent, and/or for compliance with our legal obligations.

We use the information we collect or receive:

  • To send administrative information to you.
  • To fulfill and manage your orders.
  • To post testimonials.
  • To request feedback.
  • To send you marketing and promotional communications.
  • To deliver targeted advertising to you.
  • For other business purposes.

Sharing Your Information

We may process or share your data that we hold based on the following legal basis:

  • Consent: We may process your data if you have given us specific consent to use your personal information for a specific purpose.
  • Legitimate Interests: We may process your data when it is reasonably necessary to achieve our legitimate business interests.
  • Performance of a Contract: Where we have entered into a contract with you, we may process your personal information to fulfill the terms of our contract.
  • Legal Obligations: We may disclose your information where we are legally required to do so in order to comply with applicable law, governmental requests, a judicial proceeding, court order, or legal process.
  • Vital Interests: We may disclose your information where we believe it is necessary to investigate, prevent, or take action regarding potential violations of our policies, suspected fraud, situations involving potential threats to the safety of any person, and illegal activities.

Cookies and Other Tracking Technologies

We may use cookies and similar tracking technologies to access or store information. Specific information about how we use such technologies and how you can refuse certain cookies is set out in our Cookie Policy.

Data Security

We aim to protect your personal information through a system of organizational and technical security measures. We have implemented appropriate technical and organizational security measures designed to protect the security of any personal information we process.

Retention of Data

We will only keep your personal information for as long as it is necessary for the purposes set out in this privacy policy unless a longer retention period is required or permitted by law.

Your Privacy Rights

In some regions, such as the European Economic Area (EEA), you have certain rights under applicable data protection laws. These may include the right to (i) request access and obtain a copy of your personal information, (ii) request rectification or erasure; (iii) restrict the processing of your personal information; and (iv) if applicable, to data portability.

Updates to This Policy

We may update this privacy policy from time to time in order to reflect changes to our practices or for other operational, legal, or regulatory reasons.

Contact Us

If you have questions or comments about this policy, you may contact us by email at [email protected].

The Pre-Transformation Checklist for Finance

Tap into wisdom gained through 300+ finance transformations to uncover answers to questions you have and those you should.

This field is for validation purposes and should be left unchanged.