- OneStream Community
- Forums
- Reporting
- Re: Optimize CubeView performance in Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Optimize CubeView performance in Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2021 02:12 PM - last edited on 05-24-2023 11:57 AM by JackLacava
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.
- Is it normal for CV to take to take longer to refresh in excel?
- Any suggestion to optimize the Cube view refresh in Excel?
Many Thanks.
- Labels:
-
Cube View
-
Excel Add In
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2021 02:48 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2021 04:33 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2022 05:49 AM
You can turn the below properties to false from preferences -> Enable macro -> False and Invalidate old data -> False.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-20-2023 03:37 PM
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.
