locked
Specified XML file is either not valid XML or does not conform to the cart schema error importing a chart RRS feed

  • Question

  • Trying to create a multi axis chart and getting this error after editing the xml.  Any help would be greatly appreciated!

    <visualization>
    <visualizationid>{C33BB4B6-AFA7-E711-8114-5065F38B4251}</visualizationid>
    <name>Current to Prior Year Deobligation Comparison</name>
    <primaryentitytypecode>abs_contractcloseout</primaryentitytypecode>
    <datadescription>
    <datadefinition>
    <fetchcollection>
    <fetch mapping="logical" aggregate="true">
    <entity name="abs_contractcloseout">
    <attribute name="statecode" alias="status" groupby="true" />
    <link-entity name="abs_contractcloseout" from="abs_contractcloseoutid" to="abs_contractcloseoutid" link-type="outer">
    <attribute alias="Last Year" name="abs_excessfundsamount" aggregate="sum" />
    <filter>
    <condition attribute="abs_accessiondate" operator="last-year" />
    </filter>
    </link-entity>
    <link-entity name="abs_contractcloseout" from="abs_contractcloseoutid" to="abs_contractcloseoutid" link-type="outer">
    <attribute alias="This Year" name="abs_excessfundsamount" aggregate="sum" />
    <filter>
    <condition attribute="abs_accessiondate" operator="this-year" />
    </filter>
    </link-entity>
    </entity>
    </fetch>
    </fetchcollection>
    <categorycollection>
    <category alias="status">
    <measurecollection>
    <measure alias="ThisYear" />
    </measurecollection>
    <measurecollection>
    <measure alias="LastYear" />
    </measurecollection>
    </category>
    </categorycollection>
    </datadefinition>
    </datadescription>
    <presentationdescription>
    <Chart PaletteCustomColors="91,151,213; 237,125,49; 160,116,166; 255,192,0; 68,114,196; 112,173,71; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 124,175,221; 241,151,90; 186,144,192; 255,205,51; 105,142,208; 140,193,104; 50,125,194; 210,96,18; 150,83,159; 204,154,0; 51,90,161; 90,138,57;" Palette="None">
    <Series>
    <Series XAxisType="Secondary" LegendText= "This Year" LabelFormat="#,#,k;' ';' '" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" LabelForeColor="59, 59, 59" Font="{0}, 9.5px" IsValueShownAsLabel="True" ChartType="Column" />
    <Series LegendText= "Last Year" LabelFormat="#,#,k;' ';' '" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" LabelForeColor="59, 59, 59" Font="{0}, 9.5px" IsValueShownAsLabel="True" ChartType="Column" YAxisType="Secondary" />
    </Series>
    <ChartAreas>
    <ChartArea BorderDashStyle="Solid" BorderColor="White">
    <AxisY IntervalAutoMode="VariableCount" LineColor="165, 172, 181" TitleFont="{0}, 10.5px" TitleForeColor="59, 59, 59" LabelAutoFitMinFontSize="8">
    <MajorGrid LineColor="239, 242, 246" />
    <MajorTickMark LineColor="165, 172, 181" />
    <LabelStyle Format="#,#,k;' ';' '" Font="{0}, 10.5px" ForeColor="59, 59, 59" />
    </AxisY>
    <AxisX IntervalAutoMode="VariableCount" LineColor="165, 172, 181" TitleFont="{0}, 10.5px" TitleForeColor="59, 59, 59" LabelAutoFitMinFontSize="8">
    <MajorTickMark LineColor="165, 172, 181" />
    <MajorGrid LineColor="Transparent" />
    <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
    </AxisX>
    <AxisX2 IntervalAutoMode="VariableCount" LineColor="165, 172, 181" TitleFont="{0}, 10.5px" TitleForeColor="59, 59, 59" LabelAutoFitMinFontSize="8">
    <MajorGrid LineColor="239, 242, 246" />
    <MajorTickMark LineColor="Transparent" />
    <LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
    </AxisX2>
    </ChartArea>
    </ChartAreas>
    <Titles>
    <Title Font="{0}, 13px" ForeColor="59, 59, 59" DockingOffset="-3" Alignment="TopLeft" />
    </Titles>
    <Legends>
    <Legend Font="{0}, 11px" ForeColor="59, 59, 59" Alignment="Center" ShadowColor="0, 0, 0, 0" IsEquallySpacedItems="True" Docking="right" LegendStyle="Table" />
    </Legends>
    </Chart>
    </presentationdescription>
    <isdefault>false</isdefault>
    </visualization>

    

    Tuesday, October 3, 2017 3:03 PM

All replies

  • Have you tried the xrmtoolbox chart designer?
    Saturday, October 14, 2017 7:03 PM