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.



Comments

Post a Comment

Popular posts from this blog

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.
Read more

OneStream and Oracle - Comparision

 Just my two cents !! Attached. Feature comparisons between OneStream XF and Oracle EPM cloud products. The below comparison includes some of the most significant items between OneStream and the Oracle cloud products: Item OneStream Oracle EPM cloud So What? Integration is required between Oracle EPM applications. OneStream XF is a single application, so everything works together seamlessly out of the box. The Oracle EPM cloud offering is made up of separate applications so your company must build the integration between the applications themselves . Nothing comes out of the box. Some of the applications may be on different cloud PODS in which case the integration becomes complex. Changes in any applications may require maintenance to the integration. Click here to read a blog post from an Oracle partner (Alithya) on March 20, 2020. This post describes in detail what is required to integrate multiple Oracle EPM cloud applications on different cloud PODS with each other. Data stor
Read more