Business Objects – Report Conversion Tool

We all know that Business Objects Desktop Intelligence is no more part of SAP BO 4.0 release and support of DeskI would end in 2015. Even though deski is back in SAP BO 4.1 mainly to support migration of Deski reports to the new platform we have a need to migrate Deski report to Webi.

How to do it? Deski reports can be converted to Interactive Analysis Webi reports with Report conversion tool.

 

What is Report Conversion Tool?

The Report Conversion Tool converts SAP Business Objects Desktop Intelligence XI R2 and XI 3.0 reports to Interactive Analysis XI 4.x format and publishes the converted reports to the XI 4.x CMS.

It retrieves reports from the source “Central Management Server” (CMS) into the Public, Favorites or Inbox folders. After conversion, you can publish to the same folder as the original Desktop Intelligence report or to a different folder.

The RCT tool works in 2 modes

  • “Connected” mode, the Report Conversion Tool is connected to a CMS.
  • In “Standalone” mode, the Report Conversion Tool is not connected to a CMS and no security is enforced. You can work with local, unsecured documents and universes only
report conversion tool step1

 

Drawbacks:

The tool does not convert all Desktop Intelligence features and reports. The level of conversion depends on the features in the original report. Some features prevent the report from being converted. Other features are modified, re-implemented, or removed by the tool during conversion.

The tool assigns one of three statuses to each report:

  • Fully Converted
  • Partially Converted
  • Not Converted

As Report Conversion Tool allows auditing of your converted reports, this enables you to identify reports that cannot be fully converted by the tool and helps you understand reason for same.

 

Some features not converted

  • Documents based on freehand SQL or stored procedures
  • Some objects eg sections, headers cannot be hidden in Web Intelligence documents
  • Page setup options eg page order, scale, Fit to N pages
  • Some filters on objects, folded breaks do not have the same behavior in Webi
  • Global filter formulas are not migrated into a Web Intelligence report filter
  • VBA automation

PS. Also the tool have some Java incompatibility problems when run on Windows 7. Running the tool from Business Object Enterprise server Windows 2008R2 was not an issue. 

 

Report conversion Tool Errors

Below are some of the error messages you may receive while running the conversion tool. I found compiled table with errors here

 

Status Message Possible Solution

 

Fully Converted   Report Converted Successfully – Please check formatting and verify contents
Not Converted .wid document could not be generated due to unknown reason Possible permission issue
Not Converted null, Universe not found Make sure the conversion is not running on your desktop. The report should be migrated to a folder within Business Objects.
Not Converted Unsupported Data Provider  
Not Converted Unsupported user object  
Partially Converted A formula from a Desktop Intelligence block filter cannot be migrated into a Web Intelligence block filter In DeskI, on the “Format filters” panel, you can drag and drop filters among multiple blocks or make it as global filter.In WebI, during the conversion, complex block and global filter could be removed in some cases. Regarding the usability, in WebI, you cannot drag and drop filters among multiple blocks and global, you need to recreate filter for different blocks manually. Another approach is to use input control, which provides flexibility to choose the range of filter.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Across options for crosstabs are not available in Web Intelligence 1) This may be happening because of a footer across the page. Try removing the page footer on the Format -> Table dialog.2) In the original Deski report, go to the cross tab format and uncheck show footer under across edge display. Then re-convert to Webi. Open the new Webi report, bring the properties up, uncheck show footer, then check show footer and then a column will appear on the far side, put your syntax or object back into the column and then it will be the same as the original Deski.
Partially Converted Block filters on measures do not have the same behavior in Web Intelligence DeskI can filter a measure in a block.In WebI: During conversion the filter is removed. You may add the filter after conversion, or use input control to apply the filter in a different way.Http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Blocks cannot be folded in Web Intelligence In DeskI: You may fold/unfold tables, sections and breaks. In WebI: To fold/unfold vertically is delivered starting from XI3.1 SP2. After conversion, all the report elements are unfolded. In BI4.0, the feature has been enhanced to fold horizontally as well as vertically on Sections, Table and Breaks. Furthermore, you can fold/unfold over the web which is not possible in DeskI.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Breaks cannot be folded in Web Intelligence In DeskI: You may fold/unfold tables, sections and breaks. In WebI: To fold/unfold vertically is delivered starting from XI3.1 SP2. After conversion, all the report elements are unfolded. In BI4.0, the feature has been enhanced to fold horizontally as well as vertically on Sections, Table and Breaks. Furthermore, you can fold/unfold over the web which is not possible in DeskI.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Breaks in Web Intelligence can only be set on objects present in the block In DeskI: You can break a block on a column which is not part of the block.In WebI: The break is removed during the conversion. In WebI, a workaround is to create a section with the column which is not part of the block, then remove the section label.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Breaks in Web Intelligence can only be set on one dimension In DeskI: When defining a break, you can apply breaks of multiple columns within one single level.In WebI: During conversion, the setting is removed. In WebI, this can be done by using formatting options. For examples, you can firstly add two breaks, in the “Manage breaks” window, enable the break header and foot for one break, and disable them for the other.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Conditional or permanent Hide Footer does not exist in Web Intelligence  
Partially Converted Conditional or Permanent Hide Block not available in Web Intelligence  
Partially Converted Conditional or Permanent Hide Cell does not exist in Web Intelligence In DeskI: This enables hiding content based on thresholds.In WebI: On XI3.1, there is workaround that columns can be hidden by using Alerters, when condition true (set always true) then apply formula to swap object in that same column. BI 4.0 release provides the conditional hiding functionality.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Conditional or permanent Hide Header not available in Web Intelligence  
Partially Converted Detail variables have no associated dimension in Web Intelligence  
Partially Converted Function not available in Web Intelligence DeskI has functions which are not corresponding to functions in WebI, including: ApplicationValue, BlockNumber, CurrentPage, GetProfileNumber, GetProfileString, Hyperlink, OLAPQueryDescription, PageInSection. In WebI: During conversion, these functions are replaced with RepFormula(“original_syntax”). Besides, the function CountAll is changed to WebI syntex as Count([object_name]; IncludeEmpty; All); and the function “MultiCube” is renamed to “ForceMerge”.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Keyword not available in Web Intelligence  
Partially Converted Objects cannot be hidden in Web Intelligence documents In DeskI: This enables hiding content based on thresholds. In WebI: On XI3.1, there is workaround that columns can be hidden by using Alerters, when condition true (set always true) then apply formula to swap object in that same column. BI 4.0 release provides the conditional hiding functionality.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Page break footer before page break does not exist in Web Intelligence In DeskI: You can define the Page break header/footer.In WebI: During conversion, the setting is removed.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Page break header after page break is not available in Web Intelligence In DeskI: You can define the Page break header/footer.In WebI: During conversion, the setting is removed.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Page setup options are not implemented in Web Intelligence (First page number, page order, scale, Fit to N pages) In DeskI: You may setup the page options for each document. In WebI: During conversion, original page setup options are lost and default Web Intelligence page options are appliedhttp://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Sorts on query objects are not supported In DeskI: You can apply sort at the query level. WebI doesn’t apply sort at the query level, during the conversion the sort on query is removed. Anyway, you can apply the sort at the report level.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted The formula of a global filter in Desktop Intelligence cannot be migrated into a Web Intelligence report filter In DeskI: On the “Format filters” panel, you can drag and drop filters among multiple blocks or make it as global filter. During the conversion, complex block and global filter could be removed in some cases. In WebI: You cannot drag and drop filters among multiple blocks and globale, you need to recreate filter for different blocks manually. Another approach is to use input control, which provides flexibility to choose the range of filter.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence
Partially Converted Unsupported ‘Do not regenerate SQL’ option  
Partially Converted Unsupported ‘Do not retrieve data’ option In DeskI: This helps you to build the report structure without retrieving the data. The option is lost during conversion. In WebI: You can accomplish the behavior in a different approach. Beside the “Close” button on the Edit query panel, there is an arrow, click on the arrow, you will find two options: one is “Apply changes and close”, the other is “Revert changes and close”. If you choose the first one, you go to the edit report mode, and you can build the report structure without retrieving the data.http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+from+Desktop+Intelligence+to+Web+Intelligence

 

Leave a Reply

Your email address will not be published. Required fields are marked *