Tuesday, March 20, 2012

'Other' segment in a pie chart

Hello everybody,

I am creating a pie chart report from a cube. This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment.

Is it possible to implement this functionality with out writing a complex MDX query?

If not can anybody give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.)

For your information, this feature can be implemented using a third pary software such as 'Dundas chart for Reporting Service'.

Hi,

Does anybody has some idea?

--Amde

|||

This is answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=638700&SiteID=1&mode=1

-- Robert

No comments:

Post a Comment