hi,

I need to apply back color and fore color to the cells in
my cube in analysis manager.

my query shd be if amt >50 then back color= blue, fore
color= red
if amt >75 then back color= red, fore color= green and so
on ...

how to do this for my calculated cell.

To define the colors for a measure in a cube, select the measure in the cube
editor, and then clicked the advanced properties tab. The ForeColor and
BackColor porperties are what you are after.

For the case you mentioned, the expressions would look something like:
iif( [Measures].[amt] >75, RGB(255,0,0), iif([Measures].[amt]>50,
RGB(0,0,255), RGB(255,255,255))) /* background */

iif( [Measures].[amt] >75, RGB(0,255,0), iif([Measures].[amt]>50,
RGB(255,0,0), RGB(0,0,0))) /* foreground */

The next trick will be getting a client that picks up the color information,
as not all do. And by the way, you may want to contact a color consultant -
your combinations (red on blue, green on red) will require anti-nausea drugs
;-)

"alex" <anonymous (AT) discussions (DOT) microsoft.com> wrote

While this may work in AM, I should warn you that it might not in all tools.
Unfortunately there is no vendor certification with Analysis Services, so it
is up to each vendor to decide exactly what features of Analysis Services
they will support -- some support server-side color coding; some don't. If
this works in AM's cube browser, but not in your client tool, then I suggest
that you contact your vendor and ask them to support "server-side color
coding".
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark Job" <markDOTjobATimmedientDOTcom> wrote