https://communities.sas.com/t5/Developers/OLAP-calculation-question/m-p/64417#M3266 Hi:<BR /> I don't understand what makes this a stored process question. You might want to work with Tech Support on this question. Or, post your question in the Web Report Studio forum, where most of the OLAP users will be participating.<BR /> <BR /> cynthia Tue, 10 May 2011 20:49:38 GMT Cynthia_sas 2011-05-10T20:49:38Z https://communities.sas.com/t5/Developers/OLAP-calculation-question/m-p/64416#M3265 Hi all<BR /> I hope is the right forum.<BR /> I need to do this calculation within a cube:<BR /> <BR /> consider this dimension:<BR /> [groups].[brands].<PRE><BR /> <BR /> I have a measure Val<BR /> <BR /> I need to calculate for every code the average value of Val and summarize the averages to current point of navigation.<BR /> <BR /> How can I define this with MDX?<BR /> <BR /> thanks indeed in advance<BR /> Costanzo</PRE> Tue, 10 May 2011 16:16:11 GMT https://communities.sas.com/t5/Developers/OLAP-calculation-question/m-p/64416#M3265 kos_mk 2011-05-10T16:16:11Z https://communities.sas.com/t5/Developers/OLAP-calculation-question/m-p/64417#M3266 Hi:<BR /> I don't understand what makes this a stored process question. You might want to work with Tech Support on this question. Or, post your question in the Web Report Studio forum, where most of the OLAP users will be participating.<BR /> <BR /> cynthia Tue, 10 May 2011 20:49:38 GMT https://communities.sas.com/t5/Developers/OLAP-calculation-question/m-p/64417#M3266 Cynthia_sas 2011-05-10T20:49:38Z