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

Question

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.