Dear All

How to use MDX to represent Measures without any Dimensions, just like the measures are shown on the pivot table? Could some experts help to solve the problem

Charle

SELECT {Measures.Members} On Columns
From Sales
Be aware though, that different clients will give you different results. It
works in the MDX sample application but in ProClarity 5.3 professional you
will se nothing.

HTH
Thomas Ivarsson BI Consultant, Malmö, Sweden

"Charles" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the problem ?

Thanks a lot.

In addition, how can I do in MDX builder if I want to show one of measures in different calculations when the associated dimension are different ?

Like this:

When the dimension is A:
([Measures1], Ancestor([A].CurrentMember, [A].[(All)])

When the dimension is B:
([Measures1], Ancestor([b].CurrentMember, [b].[(All)])


How can I present both in a single calculated member in MDX builder? Any selection logics? Any suggestions?

Actually, thanks to those experts.

Charles

----- Thomas Ivarsson wrote: -----

SELECT {Measures.Members} On Columns
From Sales
Be aware though, that different clients will give you different results. It
works in the MDX sample application but in ProClarity 5.3 professional you
will se nothing.

HTH
Thomas Ivarsson BI Consultant, Malmö, Sweden

"Charles" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the problem ?

Is this the limitation of MDX

----- Charles wrote: ----

Thanks a lot

In addition, how can I do in MDX builder if I want to show one of measures in different calculations when the associated dimension are different

Like this:

When the dimension is A:
([Measures1], Ancestor([A].CurrentMember, [A].[(All)]

When the dimension is B:
([Measures1], Ancestor([b].CurrentMember, [b].[(All)]


How can I present both in a single calculated member in MDX builder? Any selection logics? Any suggestions?

Actually, thanks to those experts

Charle

----- Thomas Ivarsson wrote: ----

SELECT {Measures.Members} On Column
From Sale
Be aware though, that different clients will give you different results. I
works in the MDX sample application but in ProClarity 5.3 professional yo
will se nothing

HT
Thomas Ivarsson BI Consultant, Malmö, Swede

"Charles" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:3F9B33C5-EDE6-4819-BFEF-0428A79DF63D (AT) microsoft (DOT) com..
the problem