select * from Orders where Freight > 300

GO

.setPivotResultSettings 'Index=1,

RowFields="[ShipCity] {None,SummaryCount,GrandCount} ASC",

DataFields="[Freight] {None,SummarySum,GrandSum} ASC",

FilterFields="[ShipCountry] {None,SummaryCount,GrandCount} ASC",

    ShowChart=true,

    ShowToolbar=true,

    Paging=true,

    Split=521,

    Chart="{pie}",

    Theme=default,

    RotX=341,

    RotY=-4,

    RotZ=0,

    ZoomScalar=0.9600001,

    ShowLegend=true,

    ShowLegendBorder=true,

    ShowGrid=true,

    FillGrid=true,

    GridOpacity=0.5,

    GridLineWidth=1.0,

    Title="",

    TitlePosition="Bottom Center",

    TitleCategory="",

    TitleValue="",

    UseTitleMargin=false,

    UseAxisTitleMargin=false,

    AxisTitleOnEdge=false,

    PieExplode=0.0,

    GroupSmallValues=true,

    SmallValuesThreshold=1.5,

    PieLabelDistance=3.0,

    PieShowLines=false,

    LineWidth=1.0,

    ShowMarkers=true,

    MapShowBackground=false,

    MapShowDetails=false,

    MapRange="",

    MapRangeColors="",

    Width=16.0,

    Height=10.0,

    Depth=5.0,

    SeriesSpacing=1.0,

    CategorySpacing=1.0,

    Font=Arial-PLAIN-10,

    LegendFontSize=1.0,

    SeriesFontSize=1.0,

    CategoryFontSize=1.0,

    ValueFontSize=1.0,

    TitleFontSize=1.75,

    AxisTitleFontSize=1.25,

    DataLabelFontSize=1.0,

    TopColor=#ebf0f5,

    BottomColor=#d7dcf5,

    PanX=0.0,

    PanY=0.0,

    Lighting=Default,

    Opacity=1.0,

    View2D=true,

    FitChartToImage=true,

    StackedPercent=false,

    ShowValueAxis=true,

    ShowValueAxisTicks=true,

    ShowValueAxisLines=true,

    ReverseValueAxis=false,

    ShowCategoryAxis=true,

    ShowCategoryAxisTicks=true,

    ShowCategoryAxisLines=true,

    ShowSeriesAxis=true,

    ShowDataLabels=false,

    ValueAxisNumberFormat="",

    CategoryAxisNumberFormat="",

    CategoryAxisDateFormat="",

    CategoryAxisDateTimeFormat="",

    CategoryAxisTimeFormat="",

    SeriesAxisNumberFormat="",

    SeriesAxisDateFormat="",

    SeriesAxisDateTimeFormat="",

    SeriesAxisTimeFormat="",

    NumericCategoryAxis=false,

    MergeAxis=true,

    SeriesAlias="default",

    SeriesSubType="",

    SeriesColumnType="Cube",

    SeriesMin="default",

    SeriesMax="default",

    SeriesColor="default",

    SeriesFunctionMetaData="true",

    ShowSeriesDataLabels="false",

    LegendPosition=Top Right,

    LegendWidthType=Fit,

    LegendWidth=100,

    LegendHeightType=Fit,

    LegendHeight=160,

    UseLegendMargin=false,

    ShowFixedCategoryCount=false,

    FixedCategoryCount=0,

    ShowFields=true,

    ShowTotal=true,

    ShowSubTotal=false,

    SortDataAscending=false,

    SortDataRowIndex=1,

    SortDataColIndex=0' 

 

 

 

 

 

 

Could it be the "Split=521" is forcing the text to be shifted left and down because there isn't enough width for it while "Fit to Image" is enabled?

I get some unusual text positioning in the bottom right when there are many labels stacking in that quadrant using OSX

v13.0.0 r6 ( no log errors )
and
v12.0.15-3 ( no log errors)

although I'm using Northwind Orders data.

I pasted in everything from Niels' chart script below except these lines (because I'm using different table columns)

    RowFields="[contact_country] {None,SummaryCount,GrandCount}",
    DataFields="[order_total] {None,SummarySum,GrandSum} ASC",



See attached screenshot from OSX




On 2/14/13 9:23 AM, Niels Gron wrote:

Matt,

I generated the script below in ADS 13.0.  The pie chart in 13.0-rc-7 had labels positions which seem incorrect to me.  See attached.  So I than ran the script in ADS 12.0.16 and I get this exception :

java.lang.ArrayIndexOutOfBoundsException: -85
    at com.sun.opengl.util.j2d.TextRendererImpl$GlyphProducer.getGlyph(TextRendererImpl.java:1643)
    at com.sun.opengl.util.j2d.TextRendererImpl$GlyphProducer.getGlyphs(TextRendererImpl.java:1573)
    at com.sun.opengl.util.j2d.TextRendererImpl.internal_draw3D(TextRendererImpl.java:799)
    at com.sun.opengl.util.j2d.TextRendererImpl.draw3D(TextRendererImpl.java:516)

Do we have a bug in ADS 13.0?  Do we have a bug in ADS 12.0?

thanks
-Niels


select * from orders where registration_date > '2012-1-1'
GO
.setPivotResultSettings 'Index=1,
    RowFields="[contact_country] {None,SummaryCount,GrandCount}",
    DataFields="[order_total] {None,SummarySum,GrandSum} ASC",
    ShowChart=true,
    ShowToolbar=true,
    Paging=true,
    Split=521,
    Chart="{pie}",
    Theme=default,
    RotX=341,
    RotY=-4,
    RotZ=0,
    ZoomScalar=0.9600001,
    ShowLegend=true,
    ShowLegendBorder=true,
    ShowGrid=true,
    FillGrid=true,
    GridOpacity=0.5,
    GridLineWidth=1.0,
    Title="",
    TitlePosition="Bottom Center",
    TitleCategory="",
    TitleValue="",
    UseTitleMargin=false,
    UseAxisTitleMargin=false,
    AxisTitleOnEdge=false,
    PieExplode=0.0,
    GroupSmallValues=true,
    SmallValuesThreshold=1.5,
    PieLabelDistance=3.0,
    PieShowLines=false,
    LineWidth=1.0,
    ShowMarkers=true,
    MapShowBackground=false,
    MapShowDetails=false,
    MapRange="",
    MapRangeColors="",
    Width=16.0,
    Height=10.0,
    Depth=5.0,
    SeriesSpacing=1.0,
    CategorySpacing=1.0,
    Font=Arial-PLAIN-10,
    LegendFontSize=1.0,
    SeriesFontSize=1.0,
    CategoryFontSize=1.0,
    ValueFontSize=1.0,
    TitleFontSize=1.75,
    AxisTitleFontSize=1.25,
    DataLabelFontSize=1.0,
    TopColor=#ebf0f5,
    BottomColor=#d7dcf5,
    PanX=0.0,
    PanY=0.0,
    Lighting=Default,
    Opacity=1.0,
    View2D=true,
    FitChartToImage=true,
    StackedPercent=false,
    ShowValueAxis=true,
    ShowValueAxisTicks=true,
    ShowValueAxisLines=true,
    ReverseValueAxis=false,
    ShowCategoryAxis=true,
    ShowCategoryAxisTicks=true,
    ShowCategoryAxisLines=true,
    ShowSeriesAxis=true,
    ShowDataLabels=false,
    ValueAxisNumberFormat="",
    CategoryAxisNumberFormat="",
    CategoryAxisDateFormat="",
    CategoryAxisDateTimeFormat="",
    CategoryAxisTimeFormat="",
    SeriesAxisNumberFormat="",
    SeriesAxisDateFormat="",
    SeriesAxisDateTimeFormat="",
    SeriesAxisTimeFormat="",
    NumericCategoryAxis=false,
    MergeAxis=true,
    SeriesAlias="default",
    SeriesSubType="",
    SeriesColumnType="Cube",
    SeriesMin="default",
    SeriesMax="default",
    SeriesColor="default",
    SeriesFunctionMetaData="true",
    ShowSeriesDataLabels="false",
    LegendPosition=Top Right,
    LegendWidthType=Fit,
    LegendWidth=100,
    LegendHeightType=Fit,
    LegendHeight=160,
    UseLegendMargin=false,
    ShowFixedCategoryCount=false,
    FixedCategoryCount=0,
    ShowFields=true,
    ShowTotal=true,
    ShowSubTotal=false,
    SortDataAscending=false,
    SortDataRowIndex=1,
    SortDataColIndex=0'