https://communities.sas.com/t5/SAS-Enterprise-Guide/Cumulative-Totals-Using-Calculated-Members-withOUT-Time/m-p/67374#M6763 This response from our OLAP Analyzer experts in the development group:<BR /> <BR /> You can do this by creating a custom calculated measure. <BR /> <BR /> First, you’ll want to create an MDX template for the total by creating a similar running total for your time dimension. On the calculated measure wizard, select “Special Analysis” and “Time Series Analysis.” Set any options for the kind of analysis you’re doing, and click Next until you reach the Page 4 Summary. Don’t click Finish. Instead, click Back until you reach page 1. Select “Other custom analysis” and click Next: the MDX for the running total; just replace the time members with ones appropriate for your dimension. <BR /> <BR /> Complete the wizard and click Finish.<BR /> <BR /> Chris Fri, 12 Mar 2010 20:08:30 GMT ChrisHemedinger 2010-03-12T20:08:30Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Cumulative-Totals-Using-Calculated-Members-withOUT-Time/m-p/67373#M6762 I'm trying to create cumulative totals across a specific dimension which we will call Age. Its easy to create what SAS calls "Running Totals" in OLAP but you have to have a time dimension. My Age dimension is a time dimension from a presentation standpoint (shows integers from 1 to 60) but it is not time from a SAS perspective. How would I create a cumulative total across my Age dimension? I think I would use MDX querying and create a custom calculated member.... Thu, 11 Mar 2010 20:43:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Cumulative-Totals-Using-Calculated-Members-withOUT-Time/m-p/67373#M6762 StephenOverton 2010-03-11T20:43:20Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Cumulative-Totals-Using-Calculated-Members-withOUT-Time/m-p/67374#M6763 This response from our OLAP Analyzer experts in the development group:<BR /> <BR /> You can do this by creating a custom calculated measure. <BR /> <BR /> First, you’ll want to create an MDX template for the total by creating a similar running total for your time dimension. On the calculated measure wizard, select “Special Analysis” and “Time Series Analysis.” Set any options for the kind of analysis you’re doing, and click Next until you reach the Page 4 Summary. Don’t click Finish. Instead, click Back until you reach page 1. Select “Other custom analysis” and click Next: the MDX for the running total; just replace the time members with ones appropriate for your dimension. <BR /> <BR /> Complete the wizard and click Finish.<BR /> <BR /> Chris Fri, 12 Mar 2010 20:08:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Cumulative-Totals-Using-Calculated-Members-withOUT-Time/m-p/67374#M6763 ChrisHemedinger 2010-03-12T20:08:30Z