Forum Discussion

bisenhart's avatar
bisenhart
New Contributor III
26 days 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
    26 days 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
    26 days ago

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

    • Kjarrus0820's avatar
      Kjarrus0820
      New Contributor II
      26 days 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