Skip to Content
0

Compare WEBI reports with chart data- Java SDK

May 26, 2017 at 06:35 AM

22

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers