Hello,
I am currently struggling with a conversion from Analysis Services 2000 to
2005.
In AS 2000 I'm having a Calculated member "AmountYTD" which is using the
following expression: SUM(YTD(), [Measures].[Amount])
In the cube a time-dimension has been specified in order for the user to be
able to filter on year, quarter, month and date.

Now I'm trying to put this simple expression into a new Calculated Member in
SSAS 2005, however the value is always blank, when viewing it in the
data-window. No matter what date part is filtered on the time-dimension.

Any thoughts on this?
Did I miss something obvious here?

Thanks in advance..

Mogens Nielsen

In the past, there were cases where simply specifying the current member
of the correct time hierarchy worked, like:

SUM(YTD([Time].[Calendar].CurrentMember),
[Measures].[Amount])


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

have you setup the options of your time dimension to "date" type?
a dimension doesn't have any specific content associated to it by default.
the YTD will search for the dimension identified as the time dimension (you
have time, account, customer etc... types)
if you don't setup this option correctly, then you have to manually specify
the member to use in the YTD like Deepak describe.

after this, each attribute in the dimension can be more specific, like
"Year" attribute type, "Month" attribute type etc...
(again its in the property pane, AS don't use the name of the
attribute/dimension because you can put any label you want)

"Mogens Nielsen - Elbek & Vejrup A/S"
<MogensNielsenElbekVejrupAS (AT) discussions (DOT) microsoft.com> wrote

Hi JeJe and Deepak,
thank you for helping me out...
It looks like I just messed up in showing the data, however both your
suggestions worked perfectly...

Looks like I'm just a newbie.. :-)

Regards,
Mogens

"Jeje" wrote: