ContributionsMost RecentMost LikesSolutionsCubeView - Calculate the Variance for multiple columns ( Column-by-Column) 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 loo...SolvedOptimize 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 ...Re: CubeView - Calculate the Variance for multiple columns ( Column-by-Column) We have decided to go with UD8 member as that seems easiest from build and maintenance perspective. Re: Optimize CubeView performance in Excel 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 wha...Re: CubeView - Calculate the Variance for multiple columns ( Column-by-Column) Thank you Sai for good suggestion. Re: Anyone here write a macro in Excel to kick off "Submit data" Thank you. Is this documented anywhere? Thanks. Re: Group Columns/Excel Outline in Columns on Cube Views ExcelExpandedOutlineLevelOnRows = 6 controls what level to show when cubeview is open. IfExcelExpandedOutlineLevelOnRows = 1; cubeview opens with Level 1 shown and others compressed like shown belo...Re: Group Columns/Excel Outline in Columns on Cube Views That's correct.....the indent level is picked from hierarchy indentation (provided by OS when .Tree is used). And we are using the indent value to generate the excel ExcelOutlineLevel. Re: Group Columns/Excel Outline in Columns on Cube Views Hi James, I did something similar lately. Like you mentioned, I am not able to group Column as well. But I am able to group Rows Dynamically by leveraging 3 components 1. Row member: member.Tree...
