Hyperion HFM to OneStream Rules

Following is a snippet that will help plan rules from HFM to OneStream:


Message me for the full file.








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

OneStream V8+ upgrade and things to know about .NET

  .NET is the development platform used by OneStream to build the Platform.  Prior to Platform v8.0, OneStream used versions of .NET referred to as   .NET Framework   versions.  The v7.x Platform release used .NET 4.8.   The development of Platform v8.0 used .NET6, referred to as a . NET Core  version.  The .NET Core versions leverage modern development paradigms and are  much faster!   OneStream customers upgrading to Platform v8+ are observing performance improvements in memory intensive operations such as Consolidation processing, and several data loading / copying processes.   The modern paradigms of .NET Core had an impact on OneStream Business Rule compilation - older syntax and library references that were not .NET Core compatible failed compilation.  This required some minor updates to MP Solutions and customer created Business Rules.  No sweat - a one time adjustment with your pre-v8 to v8+ Platform upgr...
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