OneStream Books

Next, select Open Book and determine in which folder your new book best belongs; you should choose Public if you want others to be able to run the book; if it is for your own use, you can store it under your private or “Users” folder:

In our example, there is no appropriate folder in which we wish to store our new book so we will create a new folder. To create a new folder, click on the new folder icon:

In the pop-up window, create the folder name, add a description and click OK:

Your new folder will immediately display in the list of Public folders (you can do the same if you create a folder under your personal folder):

Next, click the New Book icon to start creating your book:

It may look like you need to add a Required Input Parameter(s); however, this is often left blank, and the Determine Parameters From Content is set to True. This means that the parameters will come from the cube views used in the book rather than defining them in this section. For very large books you may experience improved performance by using this option. We will not use it in our example, but remember to list all your required parameter names here if you choose to use it.

There are several Items you can add to your book. To begin this process, click the Add Items icon. In this example, I am adding a cube view to export to Excel – to do this, select Add Excel Export Item:

After adding an Item, there are three sections we need to define:

• 1. Name – this is not the exact name of the cube view; it is the name of the extracted report; this can be any name you wish
• 2. Cube View Report – this is the full name of the Cube View report; a dropdown is available to assist you in locating the exact name of the cube view
• 3. Output Name – this is the tab name. A parameter used in the cube view can be passed to the tab name as seen below:

After adding an Item, there are three sections we need to define:

• 1. Name – this is not the exact name of the cube view; it is the name of the extracted report; this can be any name you wish
• 2. Cube View Report – this is the full name of the Cube View report; a dropdown is available to assist you in locating the exact name of the cube view
• 3. Output Name – this is the tab name. A parameter used in the cube view can be passed to the tab name as seen below:

When considering what to name your book, you should make it as descriptive as possible. The book name will automatically include the extension .xfDoc.xxxBook where xxx contains the type of output you wish to export. In this case, we are saving our book so the output will be in Excel (the first choice below):

• 1. Excel Book - use the extension: xlBook Example: Monthly Close - Entity.xfDoc.xlBook
• 2. PDFBook - use the extension: pdfBook Example: Monthly Close - Entity.xfDoc.pdfBook
• 3. Zip File Book - use the extension: zipBook (this output will be reviewed in the next blog) Example: Monthly Close - Entity.xfDoc.zipBook

After the book is saved, you may want to provide a description for your users and set the security group(s): To add a description to your book, select the book you wish to update, followed by the Edit icon:

You may wish to make the book accessible to all users; however, you may wish to restrict who can edit (update) the book. The Access Group and Maintenance Group are two different options:

When you finish editing the book information, click OK. This will save updates made:

You will see the updated Description and Maintenance Group:

Before adding additional reports to our book, let's test it to ensure it works as expected. To execute the book, locate it in your Public folder, click on it once to highlight it, and click on Select File:

You will be asked to confirm your selection:

After you click OK, all parameters used in the cube views will appear in the pop-up window. In our example, we have one parameter (Entity). In this example, we will select the entity Houston:

The output will export and open up in Excel:

Now that we know our book is working, we will add three additional cube views to our book. By doing this, our book will produce four different reports for the same Entity:

When we save and run the book again, you will see the four reports as four separate tabs in the same file:

This concludes our first Book blog; be on the lookout for the next blog, which will demonstrate how to create a book that produces the same report for multiple entities!