R

I have a report where i crunch some numbers and show an overall market value for the top 10 particular segments. The question I have is if I have some data that has lets say the top market value as being 57% and so on, why does the pie chart show larger portion that 57%? Is it because im not showing all segments and only the top 10? Any way to make the chart more accurate in its representation of the 57%? Sorry if I havent explained this very well.anyone have any thoughts on this? i will assume its the nature in how the pie chart works, my question is how to get the pie chart to be more representative of the actual percentages|||

Are you using filters on the pie chart?

Rather than using percentage values could you convert them to real values out of 100?

You may want to look at Dundas software's charting solutions as they could be more flexible than the out-of-the-box charts.

cheers,

Andrew

sql

R

When I'm viewing a measure spliced by all the members of a particular dimension, I get an error in regards to the member name's characters.

Here's how the error appears in the different clients -

SQL BI Studio:

TITLE: Microsoft Visual Studio

A list of actions for the selected items cannot be obtained because of the following error.
XML parsing failed at line 12, column 62: Illegal xml character.
.
This error may have occurred because the definition for at least one action is not valid. Verify the definition for each action using the Actions view.

ADDITIONAL INFORMATION:

XML parsing failed at line 12, column 62: Illegal xml character.
. (Microsoft SQL Server 2005 Analysis Services)

Reporting Service's VS query builder complains:
Error:
' ', hexadecimal value 0x08, is an invalid character. Line 1, position 94333. (System.Xml)

In SQL Management Studio:
When expanding the dimension's children, a message yields "Error occured

retrieving child nodes, The server sent an unrecognizable response"

3 free bugs for any SDETs out there :-)
Are there any known work arounds? What's the best way to filter out these characters (and which characters to we need to filter?)

Probably your dimension table contains invalid XML character as part of member name or key. You can go to the attribute which causes this problem and change the bindings on the NameColumn or KeyColumn (depending which one caused the problem) for InvalidXmlCharacters from the default Preserve to Remove or Replace. This will slow down processing of the attribute a little bit, but it should solve the problem.

HTH,

Mosha (http://www.mosha.com/msolap)