SSAS 2000 \ FORMAT_STRING \ CONDITIONAL

[news.free.fr]

Hello,

I have a dimension with custom member options activated. I would like to
change the FORMAT_STRING of the cell dynamically. I managed to do it
for the BACK_COLOR and the FORE_COLOR like this :

BACK_COLOR='iif(Indicateurs.currentmember.name="ValCol",13947080,255)' ,
FORE_COLOR='iif(Indicateurs.currentmember.name="ValCol",255,15)'

but I have problems with the FORMAT_STRING : this syntax does not work :

BACK_COLOR='iif(Indicateurs.currentmember.name="ValCol",13947080,255)' ,
FORE_COLOR='iif(Indicateurs.currentmember.name="ValCol",255,15)' ,
FORMAT_STRING='iif(Indicateurs.currentmember.name="ValCol",'Percent','Standard')'
SOLVE_ORDER='10'

Thank you

t

[Ohjoo Kwon]

I hope my example could help you.

ex1)

WITH
MEMBER Measures.CalcA AS '[Measures].[Amount]', FORMAT_STRING = 'Percent'
MEMBER Measures.CalcB AS '[Measures].[Amount]', FORMAT_STRING = 'Standard'
MEMBER Measures.Amount2 AS 'IIF(Account.CurrentMember.Name="Gross Sales",
CalcA, CalcB)'
SELECT {Amount, CalcA, CalcB, Amount2} on 0,
Account.Members ON 1
from Budget

ex2) using calculated member

Calculation Subcube : {[Gross Sales]}
Calculation Value : CalculationPassValue([Amount],-1,Relative)
Format String : Percent
Calculation Pass Number : 2
Calculation Pass Depth : 1

Ohjoo

"news.free.fr" <e_di...@hotmail.com> 님이 다음 메시지를 작성했습니다.
news:48edc4d6$0$3451$426a...@news.free.fr...