OneStream - How to perform Cube View sorting ?

If you have built a Cube View showing the clients in rows and Revenues in columns but struggling to sort data based on the revenues (descendant), so that you can view Descendant / Ascendant sorting.  Below are some tips to do this:

Take a look at OneStream Finance/XFR_MemberListRanked business rule that is included in the  GolfStream sample application.  This will return ranked/sorted lists of members. 

You may need to modify it a little to do precisely what you need, it has working code elements for sorting.

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