Hi ,

I'm new to OLAP cube design and I have a very basic question.
I need to create a cube with a calculated member for finding avg()
The logic for getting avg is same as shown in the below sql

SELECT
colA,
colB,colC,AVG(colD),
FROM table1
GROUP BY
colA,
colB,
colC

I have different dimensions for colA, colB and colC and colD is the measure.
Can someone help me out writing the MDX query for calculating the AVG()

Thanks a lot for the help.

Rgds
Maneesh mathew.