Hi,

I want to see the YTD sales regardless of what time period I have
selected in my Time Dimension. i.e. If the to-date total Sales are
$100, then even if I have selected March-2004 in my Time Dimension, I
still want to see this $ 100 as YTD (of course in addition to other
columns...)

Using the built-in "Business Center" functionality of MSDA, there is
something labelled as "Year To Date-BC-(e)" and this gives me the
desired results. BUT I do not like the label and want to change it...
for this I need to know what should be the underlying MDX? I tried all
of the following but these do not give me the YTD sales and instead give
me the YTD sales at/till the selected time period:

1) LengthMeasure
2) iif(Current dimension.name=Open Time dimension.name,null,(Length
measure,Open Time dimension.currentmember))


I'll appreciate your urgent reply.


--
Thanks.

put this in a calculated member:

iif([Tid].currentmember.level is [År],[Measures].[Budget
Beløb],ancestor([Tid].currentmember, [Tid].[År]))

sorry bout the danish....replace År with the name of the year-level in your
time dimension....replace the measure with your desired measure...

Hope it helps

\Michael Vardinghus

"Learner" <wantnospam (AT) email (DOT) com> skrev i en meddelelse
news:MPG.1b030933407b5dbc989717 (AT) msnews (DOT) microsoft.com...

Michael thanks for the reply but it's not working When I entered your
suggestions (after adjusting the Danish parts) in the 'Template Measure
Editor" of Microsoft Data Analyzer, I get an error dialog saying that
"Template Failed Validation"

There are things that i LOVE about Microsoft Data Analyzer and then
there are things that I hate

The names of my Dimensions are 'Time' and 'Product" and the name of the
measure is 'Total Sale'.

Can you please help given the above additional information?

Thanks.

Don't know analyzer....is it based on top of an olap base ?

Then you can create a calculated member in the as base in the cube - then
the syntax will work ... i'm using it myself.

\Michael V.


"Learner" <wantnospam (AT) email (DOT) com> skrev i en meddelelse
news:MPG.1b044898d6566b1d98971a (AT) msnews (DOT) microsoft.com...
Michael thanks for the reply but it's not working When I entered your
suggestions (after adjusting the Danish parts) in the 'Template Measure
Editor" of Microsoft Data Analyzer, I get an error dialog saying that
"Template Failed Validation"

There are things that i LOVE about Microsoft Data Analyzer and then
there are things that I hate

The names of my Dimensions are 'Time' and 'Product" and the name of the
measure is 'Total Sale'.

Can you please help given the above additional information?

Thanks.