InterpolateRGBColors (MDX+)

Returns the interpolated colors using the RGB color space.

Parameters

Name	Type	Cardinality	Default value
position	value-expression	one
color-palette	value-expression	zero-n

Return

color

Description

The function returns a color interpolated from the color palette. Interpolation is done linearly in the RGB color space.

The position is a numeric between 0.0 and 1.0 used to define the position in the palette (0.0 first, 1.0 last).

InterpolateRGBColors( 0.25, RGB("#FFA78F") /* 0 position */, RGB("#FFD9CF") /* 1/3 */, RGB("#FFFFFF") /* 2/3 */,RGB("#BDC9E4") /* 1 */ ) will return a color interpolated between the first and second colors.

Remember a color is an integer in the MDX world.

Examples

InterpolateRGBColors(0.5, colors...)

Color
3276800

Special Examples (errors, null, ...)

InterpolateRGBColors(-1.0, colors...) - outside bounds

if the first parameter is outside bounds the first of the last color will be used.

Query

WITH
    MEMBER [Measures].[Color] AS InterpolateRGBColors(-1,RGB(0,0,0),RGB(0,0,127),RGB(0,0,255))
SELECT
    [Measures].[Color] ON 0
FROM
    [Sales]

Result

Color
0

Color

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Color] AS RGB(0,0,0)
SELECT
    [Measures].[Color] ON 0
FROM
    [Sales]