Hi, Can anyone help me, I'm new in Analysis Services 2005,
how can I get the average, I did not understand the AVG function sintax
any suggestions?
Thanks.
Erika :)
Erika, have you looked at the AVG() function's description and usage examples at: http://msdn2.microsoft.com/en-us/library/ms146067.aspx?
--Artur
|||Thank you Artur, yes I have looked these examples, I
have this code, and y run it in SQL Management Studio in the mdx query, and I get the right result but, how you
can put this code as a Calculated Member in Analysis Services 2005
WITH MEMBER AvgAge AS
'[Measures].[Age]/[Measures].[AgeCount]'
SELECT {AvgAge} ON 0,
{[Sex].[Sex].Members} ON 1
FROM PCPCube
The error says, incorrect syntax near WITH MEMBer, so what It's wrong.
Thanks
Erika :)
|||Hello Erika,you have to put your calculation '[Measures].[Age]/[Measures].[AgeCount]' only into the expression field and the 'AvgAge' into the name field of the new Calculated Member.
Kind Regards,
Christian
