Forum Discussion

bisenhart's avatar
bisenhart
New Contributor III
12 hours 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
    12 hours 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
    11 hours ago

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

    • Kjarrus0820's avatar
      Kjarrus0820
      New Contributor
      10 hours 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