Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to get the color code from MDX query's cell properties?
Amresh S
May 25 2017 3:22 AM
246
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Error: wrong number or types of arguments
Retrive fast records in sql server