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.
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.
.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...
Comments
Post a Comment