This will give the user the ability to benefit from tools such as dynamically updating data, ad hoc reporting capabilities, and features discussed.Watch Video – 3 Ways to Create a Histogram Chart in ExcelĪ histogram is a common data analysis tool in the business world. Ensuring the add-in is installed correctly will save users from the future headaches and enable them to use a familiar tool to analyze data. This two-part blog provides the high-level information on to install, connect, and use the OneStream Excel Add-In. Here is an example of launching an Excel document from the context pane. Users can launch Microsoft Office files or XF documents saved on the File Explorer directly from the “Documents” tab on the context pane of the OneStream Excel Add-in. The File Explorer is like an internal OneStream SharePoint site that allows users to save and share documents.
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.Īnother convenient feature the add-in provides is the ability to launch files saved on OneStream’s File Explorer.
Modern Accounting: How to Overcome Financial Close Challenges
Highlighting additional members that are typed outside of the QuickView and clicking “Rebuild” will add these members. Select the “Quick Views” tab on the context pane and clicking “Create Quick View”. By highlighting exactly the information entered, in the below screenshot, the user can go to the context pane to create the QuickView. In cell B1, the desired entity desired is typed into the columns. In cell A2, type the desired account to be displayed in the rows. 
In the first “POV” tab, the POV for the user defined in the system is presented in the QuickView.
Here is a screenshot of the context pane’s tabs. This section will demonstration using the type-in functionality and the context pane to build a simple QuickView: The context pane is where users can set their POV, create and edit QuickViews, or launch documents. QuickViews can be created in various ways such as using the add-in’s typing functionality or using the context pane’s drag and drop features to build the rows and columns of a QuickView. QuickViews are the query mechanism within the OneStream Excel Add-In to easily perform any desired ad hoc analysis. Launching documents from the OneStream Excel Add-In. 
Below is a short list of features to be covered: Lastly, after a successful connection is made, the next section will show some of the beneficial Excel add-in features.
Click “Open Application” to complete the connection. After connecting, log in using the username and password. The “…” button can be used to add multiple server addresses to make connecting easier in the future. A login window will pop up, type in the server address (Same address used when connecting to OneStream on the main login page). Within the OneStream XF tab click “Logon”. Within Excel, a new ribbon tab will appear called “OneStream XF”. Next, now that the correct version of the add-in installed and enabled, the next step will be to log in and connect to our OneStream application. In the first installment of this guide, we discussed how OneStream users can uninstall their old add-in, install the correct version of the add-in, and ensure that the add-in was enabled within Excel.
0 kommentar(er)
