OneStream Excel Addin and Formulas

How to keep Excel formulas intact, when refreshing Quick view with new PoV ?

In the Quick View settings, at the top are two settings: 

"Insert or Delete Rows (Columns) When Resizing Cube View content"

Try turning both to "False"

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