tag:blogger.com,1999:blog-3689647052791307812.post2165357351414055945..comments2024-01-27T22:41:04.808+11:00Comments on Richard Lees on BI: Elaborate your cubes with conditional formattingRichard Leeshttp://www.blogger.com/profile/05671716466559973540noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3689647052791307812.post-52469737135659367622011-03-17T07:33:37.931+11:002011-03-17T07:33:37.931+11:00Here are this and some other articles on Condition...Here are this and some other articles on Conditional formatting: <br /><a href="http://ssas-wiki.com/w/Articles#Conditional_formatting" rel="nofollow"><br />http://ssas-wiki.com/w/Articles#Conditional_formatting</a>Sam Kanehttps://www.blogger.com/profile/04716596325392309094noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-91874459233937176982008-12-09T08:06:00.000+11:002008-12-09T08:06:00.000+11:00Thanks Nick. I will be using this in RS. It's a ...Thanks Nick. I will be using this in RS. It's a pity RS doesn't just take AS formatting by default. You can spend a bit of time doing tedious formatting that is already in the cube.Richard Leeshttps://www.blogger.com/profile/05671716466559973540noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-23026103652314954632008-12-06T00:51:00.000+11:002008-12-06T00:51:00.000+11:00"Unfortunately, Reporting Services does not suppor..."Unfortunately, Reporting Services does not support these conditional formats yet"<BR/><BR/>I thought this was true too until a couple of months ago, I found out by accident. When you create an SSAS query with the SSRS report designer the cell proprty flags are automatically added to the query (CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS). <BR/><BR/>As long as these (or those that you want) are referenced in the MDX code you can set the appropriate properties of a specific report object to pick up whatever has been referenced in the query. e.g. =Fields!Internet_Order_Count.BackgroundColor.<BR/><BR/>Intellisense in the Expression editor will bring through whatever properties have been referenced in the MDX.<BR/><BR/>Cheers,<BR/>NickNick Barclayhttps://www.blogger.com/profile/16606624539083402212noreply@blogger.com