using Max on analysis manager

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 06 Mar 2006 14:20 GMT

Hello there

I would like to use the max function on cacluated Member.

IS there way to do this?

Reply to this Message

Jéjé - 08 Mar 2006 01:47 GMT

try a formula like this:

max(customers.members, measures.sales)

return the max of sales value of your customers.

> Hello there
>
> I would like to use the max function on cacluated Member.
>
> IS there way to do this?

Reply to this Message

Roy Goldhammer - 08 Mar 2006 07:47 GMT

Thank you.

But is there a way to not include the All on the part of the max?

> try a formula like this:
>
[quoted text clipped - 7 lines]
>>
>> IS there way to do this?

Reply to this Message

Jéjé - 09 Mar 2006 00:08 GMT

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(Dimension.currentmember, Dimension.Level)
or
descendants(Dimension.[All member name], Dimension.Level)

I don't remember if AS2000 support the dimension.level.members formula ;-)
sorry, my mind switch to 2005 :-P

> Thank you.
>
[quoted text clipped - 11 lines]
>>>
>>> IS there way to do this?

Reply to this Message