Forum Discussion

aneupane's avatar
aneupane
Icon for OneStream Employee rankOneStream Employee
4 years ago

Optimize CubeView performance in Excel

I have Cubeview which takes ~50 secs to refresh in OS.

When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins.

It is simple insert and refresh i.e. I do not have anything additional like VBA code etc in Excel.

  1. Is it normal for CV to take to take longer to refresh in excel?
  2. Any suggestion to optimize the Cube view refresh in Excel?

Many Thanks.

Cube View
Excel Add In

4 Replies

  • BobMarchese's avatar
    BobMarchese
    New Contributor III
    4 years ago

    I am curious if you have tried opening this using Spreadsheet, and seeing what the refresh time is in there.  I believe that's a direct connection to the database and may tell you if it's an issue with the add-in or with the cube view design itself somehow.

    • aneupane's avatar
      aneupane
      Icon for OneStream Employee rankOneStream Employee
      4 years ago

      Thank you Bob. Great suggestion for troubleshooting. I tired and indeed the refresh time reduces to 1 mins 20 secs (down from 2 mins 20 secs). One step closer...I believe next step is to diagnose what is slowing in excel addin. 

  • OS_Pizza's avatar
    OS_Pizza
    Contributor III
    4 years ago

    You can turn the below properties to false from preferences -> Enable macro -> False and Invalidate old data -> False.

  • MatthiasTesch's avatar
    MatthiasTesch
    New Contributor II
    2 years ago

    I have a smilar issue. Changing these settings does not reduce the time to refresh the workbook. Also if I populate lots of cells (ca. > 100) in the CV in Excel it takes very long that the cells get yellow (indicating that data is not in DB).  When I hit submitt Excel crashes. So I think the Addin is not made for massdata submission or lager CubeViews.