English 中文(简体)
using colors in calculated member
原标题:
  • 时间:2009-11-24 03:28:21
  •  标签:
  • colors
  • mdx

Im using this query in MDX for a calculate measure

topcount(nonempty([StatusPlanes].[Status].Status.members,[Measures].[Planes]),1)(0).member_caption

this will bring me this result

Dimension1 Measure Center 1 Status 1 ---> i want this text blue Center 2 Status 2 ---> i want this text in red Center 3 Status 3 Center 4 Status 2

the thing I want to do is to add some color depending on the status... is this possible in mdx???

thank you in advance

Adriana

问题回答

You can set the color with code similar to that in this blog post

The format of the color property is documented here

You can use CELL PROPERTIES.

The property you are looking for is FORE_COLOR

However, take into account that your front-end tool must support it (not all of them do)





相关问题
using colors in calculated member

Im using this query in MDX for a calculate measure topcount(nonempty([StatusPlanes].[Status].Status.members,[Measures].[Planes]),1)(0).member_caption this will bring me this result Dimension1 ...

Using colors with MDX calculated measure

I m using this query in MDX for a calculated measure topcount(nonempty([StatusPlanes].[Status].Status.members,[Measures].[Planes]),1)(0).member_caption This will bring me this result Dimension1 ...

How can I convert a color image to grayscale in MATLAB?

I am trying to implement an algorithm in computer vision and I want to try it on a set of pictures. The pictures are all in color, but I don t want to deal with that. I want to convert them to ...

Hex colors: Numeric representation for "transparent"?

I am building a web CMS in which the user can choose colours for certain site elements. I would like to convert all colour values to hex to avoid any further formatting hassle ("rgb(x,y,z)" or named ...

How to change out-of-focus text selection color in Xcode?

Okay, I ll bite. I ve got really pleasant code/window colors set up in Xcode. Ordinarily, my selection color is very visible. When I am doing a project search and iterating through the results, ...

How to change Gmap markers color?

I ve a custom google map with different points: Markers[0] = new Array(new GMarker(new GLatLng(45.0, 9.0)), "Location1", "<strong>Address Line</strong><br/>Some information"); ...

热门标签