hi,
According to BOL, AS supports functions "Round" and "RoundUp".
\WITH MEMBER [Measures].[TEST] AS ' RoundUp ( ([Measures].[Store Sales] /
[Measures].[Sales Count] ), 0 ) '
Select {[Measures].[TEST]} on 0,
Descendants ( [Gender].[All Gender] ) on 1
From Sales

SQL Server 2000 sp3a, AS sp3a, office 2003

Any help is very appreciated.

hi,
Still not figure it out.
I refer to someone's post on April 1 Can't Use Excel 2003 Functions In MDX"
use library "c:\program files\microsoft office\office11\excel.exe" first
and it works , but only works on session.
When I reconnect to AS , it don't work again.

Why?


..