Dear all,

in MDX sample application I constructed this query bellow and it runs
perfectly:

with member Measures.YTDSales as 'sum(YTD(),[Measures].[Unit Sales])'
select
{DESCENDANTS([Time].[1997],Month)} on columns,
{[Product].[Product Category].Members} on rows
from Sales
where (Measures.YTDSales)


My doubt is: how to do this inside the Analysis Manager? If I put the
statement in the calculated members it doens´t work. Is it possible?
how?

thanks a lot

Cristiane

You can save the calc member in the cube, but not the SELECT statement.

tom @ the domain below
www.tomchester.net


"Cris" <crissarruda (AT) hotmail (DOT) com> wrote

thanks Tom,
now, please, if I do it in the MDX builder because I wanna see the
months in the column and product in the rows.... how do I visualize
this at the front end?

thanks

Cristiane


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Hi Tom

sorry, I think I wasn´t clear.... I´d like to know how do I visualize
anything that I build in MDX builder? how to put it in the cube?

thanks a lot


Cristiane

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

In Analysis Manager (specifically, in the Cube Editor):
a) right-click on Calculated Members
b) select New Calculated Member
c) Parent Dimension must remain Measures
d) Type the name of the new calculated measure in Member Name box
(say, YTDSales)
e) For some reason, sum(YTD...) didn''t quite work so I had to resort to
the following equivalent MDX:

Sum(PeriodsToDate([Time].[Year], [Time].CurrentMember),
[Measures].[Unit Sales])

Thanks.
YB

--
Posted via http://dbforums.com