OneStream Architecture and Technical Support blog

1 - Direct Load, used for planning applications specifically.  Makes data load faster 2 - Table views, pull data from relational tables into OneStream. 3 - Access documentation directly from OneStream, read from a PDF, access it from OneStream desktop.  Click on Help icon and it will take you to platform documentation such as API Overview, Design reference, BI Blend, Table Views, Cloud Architecture

Download the Excel Addin from the Marketplace of OneStream and install it. The Excel Addin version has to match the version of OneStream you are using.  The installation is quick and easy, just follow the guidance.  You will probably have to restart Excel and then you will see this new menu on the top, see below:

  A great blog to read: https://blog.onestreamsoftware.com/5-key-considerations-for-oracle-hyperion-epm-users

Predictive Analytics 123 provides a forecast baseline based on historical data patterns. The solution cycles through multiple forecast methods based on Seasonality and Trend to determine the most accurate forecast. Predictive Analytics 123 creates and presents models to support forecasting, prediction, and what-if analysis to determine the most appropriate forecast scenario. With this solution, an end-user of OneStream can administer, use and maintain predictive models without technical or data science expertise. Predictive forecasting can assist with: The target setting process to support strategic planning and annual operating plans. Create baseline predictive forecast scenarios for comparison against bottom-up, internal forecasting from divisional finance or operational business partners. Automatically seed new forecasts with predictive models for annual operating plans and rolling forecasts. Adjust baseline predictive forecasts with known business changes such as new customers, pla

The new release enhances design capabilities, increases performance, and improves ease of use of applications. New features include: Dynamically Highlight Evaluated Cells within a cube view to automatically display updated values in an existing workbook, a sheet or sheets, external workbooks, and external renamed worksheets Use an existing cube view in MS Excel or the Spreadsheet feature within the OneStream App for Windows to create highly formatted reporting by using existing cube view formatting, adding new styles to apply changes to rows, columns, or cells, or a combination of existing styles with new styles Insert Suppressed Member which allows you to select a row that is currently suppressed without asking the administrator to change row properties Relationship Security allows you to change the security model to allow who controls the relationship member in the consolidation dimension FX Lock Rate allows you to lock and unlock currency rates, by rate type and time Cube View Colum

As a technical support individual, you can monitor application analysis, diagnostic tools, maintaining the security groups and so many other tasks. As a functional support individual, you have to create all the master dimensions setup and transformation rules, reporting etc.

 Hello All, After a couple of years of blogging at https://hyperionarchitect.blogspot.com/  I have decided now to blog about OneStream Architecture and Technical support know how. Hope you will find this blog informative. Thanks, Azmat Bhatti Toronto, Ontario, Canada