Hi,

Is it possible to use conditional colouring to highlight cells whose value
is greater than the average for a dimension level?
For example, in a cellset such as the following (where construction,
decorating, electrical and hardware are children of Retail)

Retail: 100
Construction: 25
Decorating: 25
Electrical: 2
Hardware: 48

I would like to highlight the cells next to Hardware, since its total is
greater than the average for Retail. Is this possible using MDX? If so, how
might I do it?

Peter

It's possible, if your client supports this server-driven feature. It is
defined by placing an MDX expression such as below in the backcolor property
of a calculated member.

IIF ( [Measures].CurrentMember < 0,
VBA!RGB(255, 0, 0),
VBA!RGB(0, 0, 0) )

Search this group for "backcolor" for more examples.

public @ the domain below
www.tomchester.net

"Peter Kenyon" <p.kenyon.no.spam (AT) paradise (DOT) net.nz> wrote

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

Thanks. Is it possible to use an MDX expression to compare the value of the
current cell to adjacent cells? For example, if I am displaying profit for
various customers I would like to highlight them if they are greater than
the average for that category of customer. In other words, instead of:

IIF([Measures].CurrentMember > 5000 ........

I would like to have something like the following:

IIF([Measures].CurrentMember > Avg({Axis(1).CurrentMember.Siblings},
[Measures].CurrentMember),
VBA!RGB(255,0,0),
VBA!RGB(255,255,255))

Except that Axis(1) is not an alias for a dimension, so it doesn't work. Is
there any way to achieve this using MDX? If so, how can I do it?

Thanks,

Peter

I've never tried to use the axis function in the backcolor property. I do
know that when you create a calc member in the cube editor that it is
neccesary to wrap it with StrToSet(), like so:

WITH MEMBER Measures.[Visual Rank] AS
'RANK(
StrToSet("Axis(1)").Item(0).Item(0).Dimension.Curr entMember,
Order(StrToSet("Axis(1)"),
StrToSet("Axis(0)").item(0).item(0), bdesc) ) '

public @ the domain below
www.tomchester.net

"Peter Kenyon" <p.kenyon.no.spam (AT) paradise (DOT) net.nz> wrote

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

Great, that was all the information I needed. I've got it working now with
this expression:
iif([Measures].CurrentMember >
Avg(StrToSet("Axis(1)").Item(0).Item(0).Dimension. CurrentMember.Siblings,
[Measures].CurrentMember), VBA!RGB(0, 255, 0), VBA!RGB(255,255,255))