Forum Discussion

bisenhart's avatar
bisenhart
New Contributor III
2 months ago

Tips and Tricks for Report Building

Hi there, Im looking for tips and tricks, whether thats any tips on turning an excel file into a OS report build etc. Any insights or documents are appreciated!

Books
Excel Add In
Reports

3 Replies

  • Kjarrus0820's avatar
    Kjarrus0820
    New Contributor II
    2 months ago

    As I was new to OS, I validated all intersections with the XFGetCell, then designed my cube views in the OS

  • bisenhart's avatar
    bisenhart
    New Contributor III
    2 months ago

    Any other tips and tricks? I know how to copy quickviews into another sheet.

    • Kjarrus0820's avatar
      Kjarrus0820
      New Contributor II
      2 months ago
      1. Determine the OneStream Report option for the Excel file. some may not be suitable for Cube views.
      2. Identify rows and columns to be used as a template. 
      3. Identify if the alternate hierarchies are needed to minimize the cube view math