Journal in OneStream

Traditionally, you use journal for consolidation. In OneStream,  you can use journal to load data to “AdjInput” in “Origin” dimension, not only for consolidation cube, also for planning or reporting type cube.

Journal or journal template in OneStream have many settings to meet different requirements. For example, you can choose “Balanced” or “UnBalanced” for “Journal Balance Type” to post balanced or unbalance journal. For details, please refer to OneStream “Design and Reference Guide”.

Now let’s talk more about “Is Single Entity” setting to customize line item.

If you set “Is Single Entity” to True, by default, the line items will be this:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Cube, Entity will stay in the Point of View, other dimensions can move down to line items. If you select “Default”, which will show up as “Select In Each Line Item”, for UD1, you’ll see this:

If you set “Is Single Entity” to False,  by default, Cube, Entity and Parent will be in the line items:

You can also move other dimensions like UD down to the line items.

You can load large number of adjustment via an Excel or CSV template. In workflow, you can rollback posted journal, make change and post again, it’s very flexible.

OneStream’s journal functionality provides a trackable, visual tool to load adjustment data to all kind of cubes.