OneStream Community

aneupane · 12-01-2021

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...

aneupane · 12-01-2021

CubeView - Calculate the Variance for multiple columns ( Column-by-Column) Hi there, I am trying to calculate variance Column-by-Column for all time members of Current Year Vs. Prior year and looking for good option for performance optimization. Plea...

aneupane · 12-06-2021

We have decided to go with UD8 member as that seems easiest from build and maintenance perspective.

aneupane · 12-03-2021

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.

aneupane · 12-02-2021

Thank you Sai for good suggestion. 

aneupane · 12-02-2021

Thank you.Is this documented anywhere? Thanks.

aneupane · 12-01-2021

ExcelExpandedOutlineLevelOnRows = 6 controls what level to show when cubeview is open.If ExcelExpandedOutlineLevelOnRows = 1; cubeview opens with Level 1 shown and others compressed like shown below.

OneStream Community

User Statistics

User Activity

Optimize CubeView performance in Excel

CubeView - Calculate the Variance for multiple columns ( Column-by-Column)

Re: CubeView - Calculate the Variance for multiple columns ( Column-by-Column)

Re: Optimize CubeView performance in Excel

Re: CubeView - Calculate the Variance for multiple columns ( Column-by-Column)

Re: Anyone here write a macro in Excel to kick off "Submit data"

Re: Group Columns/Excel Outline in Columns on Cube Views