OneStream How to increase performance for ad-hoc analysis on large data sets within Excel Quick Views

Under the theme of Performance and Scalability, enable faster performance on large data sets by allowing users to manage paging controls on Cube Views and by enabling Sparse Data Suppression on Excel Quick Views.

Look at Max unsuppressed row setting and Allow Sparse Row Suppression =True

 







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