OneStream XF Excel Addin

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, see below:




Comments

Post a Comment

Popular posts from this blog

OneStream and Excel addin reading an XFGetCell parameter values

Image
If you have a large Excel report built on XFGetCells, and trying to understand the dimensions that each XFGetCell is grabbing, it can take a long time to parse through an XFGetCell manually and make notes of each relevant dimension.  Open your Excel Addin. Go to  your XFGetCell, see below pic. By clicking on the fx, we can identify which dimension each member is related to. It will bring up this interface.  
Read more

How to extract metadata into excel xls or csv format in OneStream ?

Image
  Get your metadata to Excel either through a Cube View or a Quick View, you should be able to build a function in Excel and use that in a formula to break your information into columns.  Something starting from a function like this:  https://www.mrexcel.com/board/threads/formula-to-find-format-alignment-indent-level.620757/ Another possibility to look at would be Application Control Manager. It’s a free download in the Marketplace. Another method can be by exporting the relationship of your dimension as XML.  Open the XML in Excel and select parent/child Here is a snipit.
Read more