Skip to main content


OneStream: A Simple Guide to Building Reports and Dashboards Part 2 of 3

Istock 1223455328 (1)

For those unfamiliar with OneStream’s reporting capabilities, the two most often used ways to view data in a user-friendly manner are Cube Views and Dashboards. This will be a three-part series that shows how you can create a simple Cube View, Dashboard and how to make them dynamic.


Part 1 – How to Build a Simple Cube View Report

Part 2 – How to Build a Simple Dashboard

Part 3 – How to Make Your Cube View and Dashboard Dynamic with Parameters


In Part 2 we’ll go over how to utilize the previously built Cube View to build a simple dashboard. We’ll assume that you understand the basics of building a Dashboard and how to create and add the individual components.


Start by creating the required Maintenance Unit to house the Dashboard and name it Products. From there create the required components, in this example we’re only going to create the Label and Cube View components.

Label Dashboard Component

Cube View Dashboard Component

Note: the naming convention used for the components created.


The formatting used for the label is: HorizontalAlignment = Center, IsVisible = True, LabelBold = True, LabelFontSize = 20, LabelTextColor = #FF000000, MarginBottom = 25, MarginTop = 25

Onestream - Modern Accounting: How to Overcome Financial Close Challenges
Modern Accounting: How to Overcome Financial Close Challenges

Improvements in each of the following period-close core tasks can provide transformative change and are reviewed in this guide include closing the books and external reporting, periodic reconciliations, and managing the period-close process.

Get the Guide


Create the Dashboard Groups. It’s best practice to create 2 groups, one to house and build the individual Dashboards and a master group that combines those Dashboards, and which is shown to end-users.

Product Dashboard Initial Groups


Within the _DBS group, create the individual Dashboards and add their respective components. Within the master (non _DBS Dashboard) create the master (0_Frame) Dashboard which will be shown to end-users. Remember to follow OneStream best practices when it comes to naming Dashboards as shown.


Products Header Dashboard Properties

Note: for each type of component/section of your master Dashboard, you will need to create an individual Dashboard in the _DBS group. Currently we have 2, one for the Label and one for the Cube View. They are named 1_Header_Products and 3_Content_Products respectively.


Note the difference of the added components in the individual Dashboards versus the master Dashboard. One calls the components, the other calls the Dashboards themselves.

Products Header Dashboard Components


Products 0 Frame Dashboard Components

The settings for the 0_Frame_Products Properties should look like the screenshot below.

Products 0 Frame Dashboard Properties


The completed Dashboard should look like the screenshot below.

Completed Simple Dashboard

We’ve now built out a very simple Dashboard that used the Cube View we built in the last blog post. We added individual components like Labels and Cube Views, modified the properties and formatting to show in a much friendlier way, allowing our end-users to view a polished report when needed.


In our next blog post, we will modify our existing Cube View and Dashboard and make them more dynamic by introducing parameters

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Muhammad Awan

Muhammad Awan is an associate business consultant in the OneStream CPM practice. He received his bachelor's degree in Finance from Wayne State University in Detroit. Muhammad has worked on OneStream application implementation and training sessions for end-users.

More from this Author

Follow Us