Your SAS programs, embedded in web apps and elsewhere

OLAP calculation question

Reply
Occasional Contributor
Posts: 6

OLAP calculation question

Hi all
I hope is the right forum.
I need to do this calculation within a cube:

consider this dimension:
[groups].[brands].


I have a measure Val

I need to calculate for every code the average value of Val and summarize the averages to current point of navigation.

How can I define this with MDX?

thanks indeed in advance
Costanzo
SAS Super FREQ
Posts: 8,868

Re: OLAP calculation question

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

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 171 views
  • 0 likes
  • 2 in conversation