Cubeview and How to perform Row collapse ?
How to remove + sign and show all the rows ? In the header format you will find this For quick views it is under User Preferences (specific to user)
Posts
OneStream - How to perform Cube View sorting ?
If you have b uilt 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.
How to extract metadata into excel xls or csv format in OneStream ?
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.