We are also bloggers
We are also bloggers
OneStream XF Excel Addins
by Nicolas Argenté
All accountants in the world know Excel. When you are using OneStream, you do not have to choose between another spreadsheet or Excel: you can have both! With OneStream Excel add-in, but also with the embedded spreadsheet you will create tailor made analysis and reporting solutions. Get your answers in seconds by using the Excel add-in. Here is a guide to get you started.
First, you will need to download the Excel Addin from the Marketplace of OneStream and install it. The Excel Addin version has to match the version of OneStream you are using. The installation is quick and easy, just follow the guidance. You will probably have to restart Excel and then you will see this new menu on the top:
This is to log on to OneStream from Excel. Click on the left button, log on and enter your credentials.
After logging in, you will see the OneStream XF menu offering you already a lot more options. You will also note the quick view on the right.
Here we will be using examples from the Golfstream application offered in the Marketplace.
OneStream Quick Views
Quick views are probably the most usefull part you will use. Building a quick view, is fast and not complicated. It will help you quickly query your data and report on it. Literally in few seconds!
First, go to any cell and type in those 2 members and select them:
Now, click on the quick view icon on the right (1) and Create the quick view (2)
You will notice that in the Quick View that you have added, you gave the dimension type with A# for account and T# for time. This allows OneStream to query the right member in the dimension type. After that you do not need to declare it again and can simply add another time period without the T# as OneStream already knows it is a time column.
Once again, select the table but this time click on rebuild
This will most probably remind you of the pivot table in Excel.
And like in a pivot table you can drag and drop other dimensions to insert them in your Quick View. It is as simple as that!
OneStream Member Dialog box
Like in the App you can use the member dialog box to easily select or filter the members you would like to show in your report.
And by double clicking on the member directly in Excel, thanks to Excel Addin, you will see its children.
You have probably noticed at this stage that, like in the OneStream Cube View, there is the same color coding for cell status. Green, Red and white for inputs, but you can personalize those colors.
The only limitation I see for now is that the Excel Addin does not have the functionality (yet!) to undo/redo if you make an error.
As you can see with those examples, the Excel Addin can provide you quick access to your data and your reports. The beauty of this is that all accountants know Excel and it is a really quick to learn new tool.
Want to learn more about OneStream XF?
If you want to learn more about handy features of OneStream XF, contact the author of this blog: Nicolas Argenté
Read more articles
Sonum International has scheduled a 4-day OneStream Application Build for Administrators (ABA) Training from 14 to 17 December 2021.
Sonum International has scheduled a two day OneStream Dashboard Training on 9 and 10 December 2021.
OneStream Software provides a unified, Intelligent Finance Platform that simplifies financial close and consolidation, planning, reporting, analytics and financial data quality for sophisticated organizations
Are Your Hyperion Applications Hindering Your Potential?
Sonum International has scheduled a four day OneStream Application Build for Administrators Training on 24-27 November 2020.
OneStream Achieves Record Q3 Results Despite Pandemic’s Economic Impact
Sonum International has scheduled a two day OneStream Level 3 Dashboards training on 9 and 10 November 2020.
OneStream named a Leader in the 2020 Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions
OneStream named a Leader in the 2020 Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions.
Wanna see our projects portfolio?
Let’s Start Something new
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit laborum. Sed ut perspiciatis unde omnis.