How to get the color code from MDX query's cell properties?

Hi All,

I had used a formatted MDX query that colors the cell with the specified color values. While I pass the query as color code FORE_COLOR=#0000ff and obtained the applied value as 16711680 via the cell properties info dilaog. How this vlaue is generated?

I have to get the color value of the FORE_COLOR applied via the MDX query.

Kindly share your suggestions.

Note: I'm using MSSQL 2014.

MDX query used:

WITH MEMBER MEASURES.CELLPROPERTYDEMO AS [Measures].[Internet Sales Amount], FORE_COLOR=#0000ff, BACK_COLOR=IIF([Measures].[Internet Sales Amount]>7000000, #ff0000, #00ff00), FONT_SIZE=10, Font_flags=1, FORMAT_STRING='#,#.000' SELECT MEASURES.CELLPROPERTYDEMO ON 0,[Date].[Calendar Year].[Calendar Year].MEMBERS ON 1 FROM [Adventure Works] CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR, FONT_SIZE

Please find the attached screen shot for your reference:

Thanks in Advance.

Regards,

Amresh S.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amresh S9y ago
hi all,

I had found the answer earlier, now updating here for someone's reference.

The color code obtained is of long type and so a custom method have to be defined to get the actual color value.
Please refer the below code snippet for this color conversion.
SolidColorBrush GetRGBColorValue(int d)
{
      SolidColorBrush rgbColor = null;
      if (d> 0)
      {
          var b = d/ 65536;
          var g= (d- b* 65536) / 256;
          var r= d- b* 65536 - g* 256;
          rgbColor = new SolidColorBrush(Color.FromRgb(Convert.ToByte(r),
Convert.ToByte(g), Convert.ToByte(b)));
       }
       return rgbColor ;
}
Regards,
Amresh S.