|
Home > Archive > MS SQL Server OLAP > April 2005 > VBA RoundUp doesn't work but Round does
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
VBA RoundUp doesn't work but Round does
|
|
| steffi 2005-04-24, 8:23 pm |
| 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.
| |
| steffi 2005-04-26, 3:23 am |
| 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\exce
l.exe" first
and it works , but only works on session.
When I reconnect to AS , it don't work again.
Why?
..
> 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.
>
>
|
|
|
|
|