Hello everyone,

i would like to have my cell background color black if one of the LEAVES
are less than 11 000.

here a sample :

WITH CELL CALCULATION [AlertTest] FOR '([Store].[Store Name].MEMBERS)'
AS 'CalculationPassValue (Store.CurrentMember, 0)', CONDITION =
'CalculationPassValue (([Store].CurrentMember,[Measures].[Unit Sales]), 0) <
11000', BACK_COLOR = '0',FORE_COLOR = '2451541', FONT_FLAGS = '3'
SELECT {[Measures].[Unit Sales]} ON COLUMNS,
[Store].[Store Name].MEMBERS ON ROWS
FROM Sales

CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR,
FONT_FLAGS

This is working now my question is : Is it possible to have the same result
at higher level ... are an example

WITH CELL CALCULATION [AlertTest] FOR '([Store].[Store Name].MEMBERS)'
AS 'CalculationPassValue (Store.CurrentMember, 0)', CONDITION =
'CalculationPassValue (([Store].CurrentMember,[Measures].[Unit Sales]), 0) <
11000', BACK_COLOR = '0',FORE_COLOR = '2451541', FONT_FLAGS = '3'
SELECT {[Measures].[Unit Sales]} ON COLUMNS,
[Store].Children ON ROWS
FROM Sales

CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR,
FONT_FLAGS

I would like to see the cell where and store name UnitSales is less than 11
000 i try to change the CONDITION For CONDITION = 'CalculationPassValue
(([Store].CurrentMember.Leaves,[Measures].[Unit Sales]), 0) < 11000'

but it did'nt work


Thanks alots

Best Regards,
Patrice Lamarche

Hello, i write [Store].CurrentMember.Leaves but i use the descendants
fonction.

Patrice Lamarche
"Patrice Lamarche" <patrice_lamarche (AT) gcomnitech (DOT) com.nospam> a écrit dans le
message de news:O3Im30GuEHA.3860 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

I got my answer

here it is!

WITH CELL CALCULATION [AlertTest] FOR '({[Store].MEMBERS},{Measures.[Unit
Sales]})'
AS 'CalculationPassValue ([Store].CurrentMember, 0)', CONDITION =
'CalculationPassValue (MIN(DESCENDANTS([Store].CurrentMember,[Store].[Store
Name]),[Measures].[Unit Sales]), 0) < 11000', BACK_COLOR = '0',FORE_COLOR =
'2451541', FONT_FLAGS = '3'
SELECT {[Measures].members} ON COLUMNS,
[Store].children ON ROWS
FROM Sales

CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR,
FONT_FLAGS

Patrice Lamarche

"Patrice Lamarche" <patrice_lamarche (AT) gcomnitech (DOT) com.nospam> a écrit dans le
message de news:O3Im30GuEHA.3860 (AT) TK2MSFTNGP09 (DOT) phx.gbl...