Compare WEBI reports with chart data- Java SDK

[Former Member]

Hello Experts,

I am developing an application to compare the Webi reports from two different environments.

I tried exporting the report to excel and comparing the Excel files using Java apache POI library.It worked well for Table data but for chart data ,the chart is exporting as image in BI4.1 so, not able to compare using the java library.

Si,I tried exporting the webi report to XML using SDK and comparing the XML files.But the Item ID in the XML format seems different for the reports,even if the reports are same.Find below the XML code for chart data,

-<mapset>
-<map name="image/png">
<![CDATA[ {"dynareas":[{"id":"root/legend/legendItem@0","ItemID":"-1791768267","tbids":["6"],"zones":[{"coords":[287,155,386,168],"shape":"R"}]},{"id":"root/xaxis/label@0","idxs":"0","dims":{"fdbid":"2","dbids":["2"]},"zones":[{"coords":[97,262,153,278],"shape":"R"}]},{"id":"root/xaxis/label@1","idxs":"1","dims":{"fdbid":"2","dbids":["2"]},"zones":[{"coords":[154,262,210,278],"shape":"R"}]},{"id":"root/xaxis/label@2","idxs":"2","dims":{"fdbid":"2","dbids":["2"]},"zones":[{"coords":[211,262,267,278],"shape":"R"}]},{"id":"root/plotarea/group@0/series@0/bar@0","ItemID":"-1791768267","idxs":"0","meas":[{"vom":8096123.6,"dbid":"5","fvom":"$8,096,124"}],"zones":[{"coords":[104,159,148,258],"shape":"R"}]},{"id":"root/plotarea/group@0/series@0/bar@1","ItemID":"-1791768267","idxs":"1","meas":[{"vom":1.3232246E7,"dbid":"5","fvom":"$13,232,246"}],"zones":[{"coords":[161,95,205,258],"shape":"R"}]},{"id":"root/plotarea/group@0/series@0/bar@2","ItemID":"-1791768267","idxs":"2","meas":[{"vom":1.50591428E7,"dbid":"5","fvom":"$15,059,143"}],"zones":[{"coords":[218,73,262,258],"shape":"R"}]}],"dbid2tbid":{"5":"6"},"feedareas":[{"id":"PrimaryValues","zones":[{"coords":[5,12,97,258],"shape":"R"}]},{"id":"RegionColor","zones":[{"coords":[283,128,390,172],"shape":"R"}]},{"id":"AxisLabels","zones":[{"coords":[97,258,268,295],"shape":"R"}]}],"tbid2name":{"6":"Sales revenue"},"staticareas":[{"id":"root/legend","zones":[{"coords":[283,128,390,172],"shape":"R"}]},{"id":"root/legend/title","zones":[{"coords":[287,132,387,149],"shape":"R"}]},{"id":"root/xaxis","zones":[{"coords":[97,258,268,295],"shape":"R"}]},{"id":"root/xaxis/title","tbids":["3"],"zones":[{"coords":[97,283,268,283,268,295,97,295],"shape":"P"}]},{"id":"root/yaxis","zones":[{"coords":[5,12,97,258],"shape":"R"}]},{"id":"root/yaxis/title","ItemID":"-1791768267","tbids":["6"],"zones":[{"coords":[5,12,17,258],"shape":"R"}]},{"id":"root/plotarea","zones":[{"coords":[97,12,268,258],"shape":"R"}]}],"legend_items_data_context":[{"id":-1791768267,"v":[{"id":"5","v":"1.7E308"}],"c":"0;[0;143;211;0]","m":"0;[]"}],"metadata":{ "axiscontexts":[{"axis":"0","ctxts":[ {"coord":"0","datapath":[{"id":"DP0.DObc","h":false,"n":"Year","v":"2004"}]},{"coord":"1","datapath":[{"id":"DP0.DObc","h":false,"n":"Year","v":"2005"}]},{"coord":"2","datapath":[{"id":"DP0.DObc","h":false,"n":"Year","v":"2006"}]}]} ], "contexts":[{"bid":"2","c3id":"4" ,"axisbased":[0],"valuecontext":[{},{},{}]}, {"bid":"3","c3id":"6" ,"valuecontext":{}}, {"bid":"5","c3id":"9" ,"axisbased":[0],"valuecontext":[{},{},{}]}, {"bid":"6","c3id":"11" ,"valuecontext":{}}]} } ]]>
</map>
</mapset>

Can anyone please help me with the comparison using XML format of WEBI report?

Thanks and Regards,

Preethi Mala