| Author |
using Max on analysis manager
|
|
| Roy Goldhammer 2006-03-06, 7:16 pm |
| Hello there
I would like to use the max function on cacluated Member.
IS there way to do this?
| |
|
| try a formula like this:
max(customers.members, measures.sales)
return the max of sales value of your customers.
"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:OPCzhjSQGHA.648@TK2MSFTNGP14.phx.gbl...
> Hello there
>
> I would like to use the max function on cacluated Member.
>
> IS there way to do this?
>
| |
| Roy Goldhammer 2006-03-08, 3:23 am |
| Thank you.
But is there a way to not include the All on the part of the max?
"Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
news:eimQ7IlQGHA.3916@TK2MSFTNGP11.phx.gbl...
> try a formula like this:
>
> max(customers.members, measures.sales)
>
> return the max of sales value of your customers.
>
> "Roy Goldhammer" <roy@hotmail.com> wrote in message
> news:OPCzhjSQGHA.648@TK2MSFTNGP14.phx.gbl...
>
>
| |
|
| you talk about the "all member"?
yes, using AS2005: Dimension.Attribute.Attribute.members returns only the
members (not the all members)
or Dimension.Hierarchy.level.members
using AS2000: Dimension.[All member name].children
or
descendants(Dimensio
n.currentmember, Dimension.Level)
or
descendants(Dimensio
n.[All member name], Dimension.Level)
I don't remember if AS2000 support the dimension.level.members formula ;-)
sorry, my mind switch to 2005 :-P
"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:Om6DbRoQGHA.3460@TK2MSFTNGP15.phx.gbl...
> Thank you.
>
> But is there a way to not include the All on the part of the max?
>
> "Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
> news:eimQ7IlQGHA.3916@TK2MSFTNGP11.phx.gbl...
>
>
|
|
|
|