SAP BusinessObjects Report Conversion Tool Guide
■ SAP BusinessObjects Enterprise XI 4.0
2010-08-23
Copyright
© 2010 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
Business ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business
Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web
Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the
United States and in other countries. Business Objects is an SAP company.All other product and
service names mentioned are the trademarks of their respective companies. Data contained in this
document serves informational purposes only. National product specifications may vary.These materials
are subject to change without notice. These materials are provided by SAP AG and its affiliated
companies ("SAP Group") for informational purposes only, without representation or warranty of any
kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The
only warranties for SAP Group products and services are those that are set forth in the express
warranty statements accompanying such products and services, if any. Nothing herein should be
construed as constituting an additional warranty.
2010-08-23
Contents
Report Conversion Tool Overview..........................................................................................5Chapter 1
1.1
1.2
2.1
2.2
3.1
3.2
3.3
3.3.1
3.3.2
3.4
3.4.1
3.4.2
3.4.3
3.4.4
3.4.5
3.4.6
3.4.7
3.4.8
3.4.9
3.5
3.5.1
3.5.2
3.6
3.6.1
3.6.2
What is the Report Conversion Tool?.......................................................................................6
New features supported for conversion to Interactive analysis.................................................6
Report Conversion Tool working modes.................................................................................9Chapter 2
Report Conversion Tool Connected mode...............................................................................9
Report Conversion Tool Standalone mode...............................................................................9
Using the Report Conversion Tool........................................................................................11Chapter 3
Installing the Report Conversion Tool.....................................................................................11
Editing user settings for the Report Conversion Tool..............................................................11
Launching the Report Conversion Tool...................................................................................11
To launch the Report Conversion Tool in Connected mode....................................................11
To launch the Report Conversion Tool in Standalone mode....................................................12
Selecting reports....................................................................................................................12
To explore the repository.......................................................................................................13
To search for reports with the Report Conversion Tool..........................................................13
To select individual reports for conversion..............................................................................13
To select reports by folder for conversion..............................................................................13
To select reports by category for conversion.........................................................................14
To save and open lists of reports for conversion....................................................................14
To convert reports.................................................................................................................14
Report conversion status icons..............................................................................................15
Limitations in converting a report containing free-hand SQL or stored procedures.................16
Viewing conversion results and selecting the audit database..................................................17
To create an audit connection and assign it to the Report Conversion Tool............................17
To view the audit report for the Report Conversion Tool........................................................18
Publishing converted reports..................................................................................................18
To publish converted reports..................................................................................................19
To compare fully converted reports........................................................................................19
2010-08-233
Contents
Desktop Intelligence feature conversion...............................................................................23Chapter 4
4.1
4.2
Index 33
SAP BusinessObjects Desktop Intelligence feature conversion status...................................23
Formula conversion in the Report Conversion Tool................................................................29
More Information...................................................................................................................31Appendix A
2010-08-234
Report Conversion Tool Overview
Report Conversion Tool Overview
You use the Report Conversion Tool to convert SAP BusinessObjects Desktop Intelligence XI R2 and
XI 3.0 reports to Interactive Analysis XI 4.0 format in the SAP BusinessObjects Enterprise XI 4.0 platform.
Before you can convert your Desktop Intelligence reports, you first need to install and configure SAP
BusinessObjects Enterprise XI 4.0 client tools.
Note:
Desktop Intelligence reports are no longer supported in SAP BusinessObjects Enterprise XI 4.0. To
access your data from a Desktop Intelligence report in SAP BusinessObjects Enterprise XI 4.0, you
must convert the Desktop Intelligence report to an Interactive Analysis report using Report Conversion
Tool.
You use the Report Conversion Tool to convert the following types of report to Interactive Analysis XI
4.0 (WID) format:
• Desktop Intelligence reports whose dependencies are migrated to the XI 4.0 CMS using Upgrade
Manager. Dependencies include folders and objects, other application objects, and the universes.
It is recommended to use Upgrade Manager before you convert your Desktop Intelligence report to
Interactive Analysis report using Report Conversion Tool. If you do not use Upgrade Manager for
your Desktop Intelligence report, then you may not be able to refresh your Interactive Analysis report
due to:
• Unavailability of the source folder structure in the destination for your Interactive analysis report.
Note:
If you convert your Desktop Intelligence report to Interactive analysis report, by default, your
report will be saved to Public folder\Report conversion tool\Report conversion
tool documents in the destination CMS. However, you can also save it in a different location.
Manually creating a folder with the same source folder name will not refresh your Interactive
analysis report, as the folders are recognized by the application through their individual IDs known
as CUID and not folder names.
• Unavailability of other application objects and the universes.
• Desktop Intelligence reports created directly in SAP BusinessObjects Desktop Intelligence and
based on the data providers as follows:
• a Business Objects universe
• a Microsoft Excel document
• an ASCII file (formats ASC, PRN, CSV and TXT)
• free-hand SQL and stored procedures
2010-08-235
Report Conversion Tool Overview
Note:
• Desktop Intelligence is the new name of the product formerly called BusinessObjects. It was first
shipped under this new name in the BusinessObjects Enterprise XI release.
• Interactive analysis is the new name of the product formerly called Web Intelligence.
1.1 What is the Report Conversion Tool?
The Report Conversion Tool converts SAP BusinessObjects Desktop Intelligence XI R2 and XI 3.0
reports to Interactive Analysis XI 4.0 format and publishes the converted reports to the XI 4.0 CMS.
It retrieves reports from the source “Central Management Server” (CMS), into the “Public”, “Favorites”,
or “Inbox” folders. Once converted, you can publish to the same folder as the original Desktop Intelligence
report or to a different folder.
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, reimplemented, or removed by the tool during conversion.
The tool assigns one of three statuses to each report:
• “Fully Converted”
• “Partially Converted”
• “Not Converted”
The Report Conversion Tool also lets you audit your converted reports. This enables you to identify
reports that cannot be fully converted by the Report Conversion Tool and helps you understand why.
Note:
For more information about Desktop Intelligence feature conversion, see
Conversion Tool Guide
.
SAP BusinessObjects Report
1.2 New features supported for conversion to Interactive analysis
Following are the new features that are fully converted using the Report Conversion Tool:
2010-08-236
Report Conversion Tool Overview
DescriptionFeature
Query on Query
Fold/Unfold
After conversion of your Desktop Intelligence report to Interactive analysis report
using Report Conversion Tool, the Query on Query feature applied to your
Desktop intelligence report will be reflected in the converted Interactive analysis
report. The conversion status is Fully converted since Query on query feature is
supported in Interactive analysis. Query on query in Interactive analysis supports
the following operators:
• InList / NotInList
• EqualTo
• NotEqualTo
• GreaterThan
• GreaterThanOrEqualTo
• LessThan
• LessThanOrEqualTo
The other operators apart from the operators listed above, do not support Query
on query in Interactive analysis.
You can view or apply the Fold or Unfold feature in Outline view.
After conversion of your Desktop Intelligence report to Interactive analysis report
using Report Conversion Tool, the folded sections, tables, crosstabs, and breaks
will be unfolded in Interactive analysis report. You can then fold them manually.
The conversion status is Fully converted since Fold/Unfold feature is supported
in Interactive analysis.
Show/Hide
Fit to page
Using the Show/ Hide feature, you can hide sections, tables, cross tables, charts,
cells, dimensions, and measures to your Desktop Intelligence report. You can
also hide these through conditions.
After conversion of your Desktop Intelligence report to Interactive analysis report
using Report Conversion Tool, the objects that are hidden in your Desktop intelligence report will also be hidden in your Interactive analysis report. The conversion
status is Fully converted since Show/Hide feature is supported in Interactive
analysis.
Note:
Hiding Measure in Desktop Intelligence report will remove Measures from the
Interactive analysis report after conversion using Report Conversion Tool. However, the object is available under the Data tab in the left pane of your Interactive
analysis report and you can drag-drop this object to your report to view the values
in the table.
2010-08-237
Report Conversion Tool Overview
DescriptionFeature
In the Page setup options, you can apply the Fit to page feature to your Interactive
analysis report in Page layout mode.
If you apply Fit to page feature to your Desktop Intelligence report and convert it
to Interactive analysis report using Report Conversion Tool, the report is fully
converted and the Fit to page feature is available in your Interactive analysis report.
Note:
• If page size values entered is below 10 percent or above 400 percent, after
conversion, Report Conversion Tool will adjust the page size to 100 percent
since the valid value for scaling in Interactive analysis is from 10 percent to
400 percent.
• If Fit to page and margins are applied to your Desktop Intelligence report, then,
during conversion, Report Conversion Tool will set the margin values to the
default values in your Interactive analysis report.
2010-08-238
Report Conversion Tool working modes
Report Conversion Tool working modes
You can work with the Report Conversion Tool in two modes: “Connected” or “Standalone”.
2.1 Report Conversion Tool Connected mode
In “Connected” mode, the Report Conversion Tool is connected to the source and the destination CMS.
• You can convert Desktop Intelligence documents that are stored in the source CMS to Interactive
Analysis format.
• You can publish converted documents to XI 4.0 CMS.
• If a universe needs to be created on-the-fly during the conversion session, it is created in the CMS.
Note:
If your Desktop Intelligence report was created on free-hand SQL or Stored Procedures, then Report
conversion tool will create a universe on-the-fly as Interactive analysis does not support free-hand
SQL or Stored Procedures.
Security in Connected mode
When you work in “Connected” mode, the security rights of your user account are applied by the CMS.
2.2 Report Conversion Tool Standalone mode
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. Local means saved to
the computer's hard disk. This does not include network servers.
You cannot import documents to or export documents from a CMS when you are in “Standalone” mode.
The middleware required to create and refresh local, unsecured documents with local, unsecured
universes must be installed on the computer with the Report Conversion Tool.
• You can convert Desktop Intelligence documents to Interactive Analysis.
• You can convert documents created with earlier versions of Desktop Intelligence and XI 3.0 to
Interactive Analysis XI 4.0 provided the universes they are based on have been copied to the local
XI 4.0 universe folder and are unsecured (saved for all users).
2010-08-239
Report Conversion Tool working modes
• You cannot convert documents based on freehand SQL or stored procedures to Interactive Analysis
XI 4.0.
When to use Standalone mode
You use “Standalone” mode when you want to work with neither CMS security nor a CMS connection.
This allows you to convert any number of locally stored, unsecured documents in a single operation
without affecting CMS performance.
2010-08-2310
Using the Report Conversion Tool
Using the Report Conversion Tool
3.1 Installing the Report Conversion Tool
The Report Conversion Tool runs on Microsoft Windows platforms. It is installed by default when you
run a Client installation of SAP BusinessObjects XI 4.0. When you run a “Custom” installation, you must
select Report Conversion Tool to install it.
Note:
You must install Designer if you want to create an audit log or if you want to detect “Free-Hand SQL”
and “Stored Procedure” reports.
3.2 Editing user settings for the Report Conversion Tool
By default, users in the “Administrators” group or the “Report Conversion Tool Users” group have the
appropriate rights to use the Report Conversion Tool.
You can edit the user rights through the Central Management Console in the SAP Business Objects
Enterprise Applications > Report Conversion Tool section.
3.3 Launching the Report Conversion Tool
You can launch the Report Conversion Tool in either of its working modes:
• “Connected”
• “Standalone”
3.3.1 To launch the Report Conversion Tool in “Connected” mode
2010-08-2311
Using the Report Conversion Tool
In “Connected” mode, security is handled by the CMS.
When you launch the Report Conversion Tool in “Connected” mode, you have a client-server connection
to the CMS.
1.
Click Start > Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects
Enterprise Client Tools > Report Conversion Tool.
The Report Conversion Tool login page opens.
2.
In the Source fields, enter a valid user name and password, select the source CMS in the System
list, and then select the Enterprise authentication mode.
3.
In the Destination fields, enter a valid user name and password, select the destination CMS in the
System list, and then select the Enterprise authentication mode.
4.
Click Available Languages and select a language if you want to change the Report Conversion
Tool interface language.
5.
Click Log In.
The Report Conversion Tool is launched in “Connected” mode.
3.3.2 To launch the Report Conversion Tool in “Standalone” mode
In the “Standalone” mode, you cannot work with documents or universes that have been secured by a
CMS. To work with the universe, ensure that the universe is located at: C:\Documents and
Settings\Administrator\Application Data\SAP Business Objects\SAP Business
Objects XI 4.0\Universes. The mapped network drives are available in the Standalone mode.
1.
Click Start > Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects
Enterprise Client Tools > Report Conversion Tool.
2.
Select Standalone in the Authentication list.
The System, User Name, and Password fields are disabled.
3.
Click Available Languages and select a language if you want to change the Report Conversion
Tool interface language.
4.
Click Log In.
The Report Conversion Tool is launched in “Standalone” mode.
3.4 Selecting reports
You use the first screen in the Report Conversion Tool wizard to select reports for conversion. In
“Connected” mode, the pane on the left shows the CMS repository in tree format. You select reports
from the repository and move them to the list on the right for conversion.
2010-08-2312
Using the Report Conversion Tool
You can work with folders or categories when exploring the repository.
3.4.1 To explore the repository
To explore the repository, complete the following steps:
1.
Click Folder to view the repository by folder, or click Category to view the repository by category.
2.
To view the properties of a folder or category, right-click it and click Properties.
3.
To refresh the contents of a folder or category, right-click it and click Refresh.
4.
To view unconverted reports only, select Show unconverted documents only at the bottom of the
screen.
Related Topics
• Report conversion status icons
3.4.2 To search for reports with the Report Conversion Tool
If you know the name of a report you want to convert, you can search for it directly.
1.
Type the name of the report in the search box below the list of folders or categories.
2.
Click the Search icon to the right of the search box.
You can also search on partial report names. If you search on "Sales2," the search finds all reports
whose name begins with "Sales2," for example: "Sales2006" or "Sales 2007."
The Report Conversion Tool highlights the reports that correspond to your search.
3.4.3 To select individual reports for conversion
• On the Select Reports screen of the Report Conversion Tool wizard, select reports in the left pane
and either click >> or right-click the reports, and click Add documents to batch list to copy them
to the list of reports for conversion.
3.4.4 To select reports by folder for conversion
2010-08-2313
Using the Report Conversion Tool
1.
Click Folder to view the repository by folder.
2.
Right-click the folder that contains the reports that you want to convert.
3.
Choose either all documents in the folder or all documents in the folder and its subfolders:
• Click Select folder only to add all the documents in the folder to the list of reports for conversion.
• Click Select folder and subfolders to add all the documents in the folder and its subfolders to
the list of reports for conversion.
3.4.5 To select reports by category for conversion
1.
Click Category to view the repository by category.
2.
Right-click the category that contains the reports that you want to convert.
3.
Choose either all documents in the category or all documents in the category and its subcategories:
• Click Select category only to add all the documents in the category to the list of reports for
conversion.
• Click Select category and subcategories to add all the documents in the category and its
subcategories to the list of reports for conversion.
3.4.6 To save and open lists of reports for conversion
To save a list of reports for conversion, you must first have launched the Report Conversion Tool and
moved one or more reports to the list of files for conversion.
You can save the list of reports selected for conversion to a file (in XML format) and open this file later
to populate the list.
1.
With one or more reports present in the list of files for conversion, click Save List.
2.
Type the name of the list you want to create in the "Save" dialog box, and then click OK.
3.
To open the list later, on the Select and Convert Reports screen of the wizard, click Open List.
4.
Select the file you want to open and validate.
The documents in the file appear in the list of documents for conversion.
3.4.7 To convert reports
On the Select reports screen of the Report Conversion Tool wizard, you have placed the list of reports
to be converted.
2010-08-2314
Using the Report Conversion Tool
1.
To convert the data in the reports to text format, select Read all Cell Contents as Text.
The Report Conversion Tool converts the data to text format. The checkbox is selected by default.
If you unselect this option, the data is converted to hyperlinks.
2.
If the list of reports to be converted includes one or more reports containing free-hand SQL, select
Convert documents containing free-hand SQL / Stored Procedures.
The Report Conversion Tool will convert all reports, including those containing free-hand SQL. If
you do not select this option, documents containing free-hand SQL will not get converted.
3.
Click Next.
The "Converting" screen appears as the documents are converted. This screen lists all the documents
being converted, along with their conversion status.
3.4.8 Report conversion status icons
In the Select reports and Conversion in Progress screens of the Report Conversion Tool wizard, the
conversion status of reports is given by means of icons.
2010-08-2315
Using the Report Conversion Tool
DescriptionStatusIcon
Fully Converted
Partially Converted
Not Converted
The report structure and format are the same in SAP BusinessObjects Desktop Intelligence and Interactive Analysis.
Note:
Although the converted report structure is the same as the original
report structure, the report might still return different values in certain
circumstances because the Interactive Analysis calculation engine
does not always interpret this structure in the same way as the SAP
BusinessObjects Desktop Intelligence calculation engine.
Some report features were converted to Interactive Analysis, but
not all.
The SAP BusinessObjects Desktop Intelligence report was not
converted because it contains critical features that have no Interac-
tive Analysis equivalent.
3.4.9 Limitations in converting a report containing free-hand SQL or stored
procedures
With the Report Conversion Tool, you can convert SAP BusinessObjects Desktop Intelligence reports
that include free-hand SQL or stored procedures, subject to the following limitations:
• Designer must be installed on the local machine.
• Conversion of reports with free-hand SQL or stored procedures is only possible in Connected mode,
since the Report Conversion Tool needs to use the secured connection to the database that is saved
in the CMS.
• The free-hand SQL or stored procedure is converted to a universe whose name is the name of the
free-hand SQL or stored procedure.
• The universe uses the same connection that the SAP BusinessObjects Desktop Intelligence report
used for the free-hand SQL or stored procedure.
• For free-hand SQL or stored procedures that require parameter prompts, the generated universe,
depending on how it is set up in the SAP BusinessObjects Desktop Intelligence report, may handle
it in one of two ways:
• by setting the same parameters that were set in the SAP BusinessObjects Desktop Intelligence
report to be sent to the free-hand SQL or stored procedure
• by prompting on refresh of the Interactive Analysis report
2010-08-2316
Using the Report Conversion Tool
3.5 Viewing conversion results and selecting the audit database
When you have started the Report Conversion Tool and followed the steps in the wizard to select and
convert reports, the "Audit Conversion Session" screen appears.
The screen shows the converted reports by conversion status ( fully converted, partially converted, or
not converted). The percentage of reports that are converted in each category is shown.
You also use this screen to select an audit database connection in which the Report Conversion Tool
writes the details of conversion so that if some reports are not fully converted, you can analyze why.
To do this you must first create an audit database connection in Designer and assign it to the Report
Conversion Tool through the CMS or you can also use an existing default connection Conversion
Audit Connection. The Report conversion Tool audit statistics report is created using the Report
Conversion Tool audit universe which is linked to the Conversion Audit Connection. The Report
Conversion Tool audit statistics report is the default report, you may create your own report as well.
Note:
If you do not select the default connection, you must make sure that the connection selected is linked
to the Report Conversion Tool audit universe.
Related Topics
• Report conversion status icons
3.5.1 To create an audit connection and assign it to the Report Conversion Tool
Before publishing converted reports, you can have the Report Conversion Tool write the conversion
results to an audit database that you choose. If some reports are not fully converted, you can use this
data to analyze why. To use an audit database you must first create a connection in Designer and then
assign it to the Report Conversion Tool.
1.
Launch BusinessObjects Enterprise XI 4.0 Designer and log in.
2.
Select Tools > Connection.
3.
Click Add.
4.
Follow the steps in the “New Connection Wizard” to create the connection. For more information,
see the
Report Conversion Tool auditing supports Oracle, SQL Server, DB2, Sybase, and mysql databases
only. Auditing is not guaranteed to function with other RDBMSs.
Designer's Guide
.
5.
Log into CMC, click Applications > Report Conversion Tool > Properties, select a connection
for auditing and click Update.
2010-08-2317
Using the Report Conversion Tool
6.
In the "Save Conversion Results in Audit Database" screen of the Report Conversion Tool, under
Audit Settings, select the Save conversion results into audit database option and select the
audit connection from the list.
If the connection you just created does not appear in the list, click Refresh.
You can also choose how to add data to the table:
DescriptionOption
Delete the existing audit table before inserting new rows
Select this if you want to clear existing data in the audit table
before auditing the current conversion. Only the rows you
have previously written to the audit table are deleted. Rows
written by other users remain in the table.
Append new rows to the audit table
Select this if you want to add the current conversion data to
the existing audit data.
Finally, you can add a comment to each row in the table.
The conversion results will be written to this audit database for analysis.
3.5.2 To view the audit report for the Report Conversion Tool
You have selected an audit database connection for the Report Conversion Tool and converted reports.
You are on the Select converted documents to publish screen of the Report Conversion Tool wizard.
1.
Click Open Audit Report.
The location of the Report Conversion Tool audit statistics report is Public folder\Report
conversion tool\Report conversion tool documents\Report Conversion Tool
audit document\.
2.
In the login page that opens, enter your login to the audit database connection.
The audit report opens.
3.6 Publishing converted reports
When you have started the Report Conversion Tool and followed the steps in the wizard to select and
convert reports, then viewed the conversion results, the Publish Reports screen appears.
The Publish Reports screen lets you view conversion results.
The wizard step lets you publish both complete and partially converted reports. You can view reports
in BI Launchpad before publishing.
2010-08-2318
Using the Report Conversion Tool
3.6.1 To publish converted reports
You have selected and converted reports and viewed the conversion results. You are on the Publish
Reports screen of the Report Conversion Tool.
1.
Optionally, to see the audit report for the converted reports, if you have chosen to store the audit
data, click Open Audit Report underneath the Conversion Results list.
2.
Click the check box at the left of a row to select the report for publication. The checkbox is selected
by default, if you unselect the checkbox, the report will not be published.
3.
Select a report row and right-click to change the publishing details such as target name, target folder,
and target categories.
By default, the target name is the same as the source report name. You can change the target name.
4.
Click Next to publish the reports.
The converted reports are published. The "Publish Complete" screen appears when publication is
complete. It lists the names of the files and their publication status. At the bottom of the window, the
status icons give the number of reports in each status. The status includes:
• Fully published – The report is fully published.
• Partially published – The report is partially published because the universe in the destination machine
that is linked to your report is not available.
• Not published – The report is not published when a report existing in the destination machine is
being published and you select not to replace the existing report.
• Failed to publish – The report did not get published.
3.6.2 To compare fully converted reports
You have fully converted at least one report from Desktop Intelligence to Interactive Analysis format.
You are on the Audit Conversion screen of the Report Conversion Tool.
SAP BusinessObjects Desktop Intelligence reports and the Interactive Analysis reports that result from
their conversion may have differences in data due to calculation engine differences. From the Report
Conversion Tool, you can call the Delta Viewer of the Report Comparison Tool to compare original and
converted reports (fully converted reports only) to view data differences, if any.
1.
On the Save Conversion Results in Audit Database screen of the Report Conversion Tool, select
the Compare fully converted documents option.
2.
Set audit settings as desired.
3.
Click Next.
4.
Click OK in the Comparison box when comparison of source and converted documents is complete.
In the Select the converted documents to publish screen, use the View Differences button to
view the data differences between documents.
2010-08-2319
Using the Report Conversion Tool
5.
Click the View Differences button to open the Delta Viewer of the Report Comparison Tool.
3.6.2.1 Report comparison status icons for fully converted documents
The following table lists icons that indicate the report comparison status for fully converted documents:
DescriptionStatusIcons
Reports are identical.Identical
Modified
Manual Check
Required
The report is fully converted. However, because of differences in
calculation, the converted report is different from the source report.
• Requires manual check for charts/graphics.
• Reports are not fully compared because of errors such as Re-
port output could not be generated for Source.
3.6.2.2 The Report Comparison Tool
3.6.2.2.1 Delta Viewer
Delta Viewer is the main dialog box of the comparison tool. It enables you to view the details of the
comparison result.
The Delta Viewer opens, saves, and analyzes Report Output Comparison [.roc] files.
It uses the following colour codes to highlight the difference between 2 documents:
• Modified items are displayed in Green
• Removed items are displayed in Red
• Inserted items are displayed in Blue
• Identical items are displayed in Black
You can launch the Delta viewer when you open a [.roc] file, or after you have processed for a new
comparison.
2010-08-2320
Using the Report Conversion Tool
To analyze result using Delta Viewer
The Delta Viewer dialog box displays the details of the comparison between two documents.
The Report Comparision tool option menu includes the following:
• Tree panel.
• Block panel.
• Slice and Dice panel.
Delta Viewer supports the following views:
• Merged view - Enables the user to merge and view the both source and target systems report.
• Source view - Enables the user to view the source system report.
• Target view - Enables the user to view the target system report.
• Split view - Enables the user to view the split reports of both source and destination systems.
When you select a report element in the Report Panel, the result is displayed in the Block Panel and
in the Slice and Dice Panel if it is a table.
1.
From the View menu, select the Split view option.
The description of the report element in the source and in the destination document is displayed on
the same tab.
2.
Select the report element in the Report Panel.
The high level information of the report element is displayed in the Block Panel. Green, Blue or
Red text means that changes have been made during the migration. Table structure is displayed in
the Slice and Dice Panel.
2010-08-2321
Using the Report Conversion Tool
2010-08-2322
Desktop Intelligence feature conversion
Desktop Intelligence feature conversion
4.1 SAP BusinessObjects Desktop Intelligence feature conversion status
When you launch the conversion process, some documents are fully converted, while others are Partially
converted. The table below shows the Desktop Intelligence documents or reports that cannot be fully
converted to Interactive Analysis.
In some cases, the entire report cannot be converted when a certain feature is present.
SAP BusinessObjects Desktop Intelligence feature
Data providers
OLAP data provider
Universe data provider, where
the universe is not found in XI
4.0
Universe connection, where the
universe is not found in XI 4.0.
Queries
Filter with a Query Results
operand(query on a query).
Result in the Interactive
Analysis report
The report is converted
Conversion status or initialization file setting
Not convertedReport not converted
Not convertedReport not convertedXML data provider
Fully converted
Fully convertedThe report is converted
Not convertedReport not convertedFilter with a Calculation operand
Fully convertedThe report is converted.
Not convertedReport not convertedUser Object
2010-08-2323
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
Scope of analysis with filter on
a measure
An object whose definition includes the Designer @script
function
Result in the Interactive
Analysis report
Scope of analysis objects becomes result objects
Conversion status or initialization file setting
Partially convertedSetting is lostAutomatic refresh setting
Partially converted
Note:
If you apply an Aggregate filter
and set Scope of Analysis on a
measure object, the SQL generated for SAP BusinessObjects
Desktop Intelligence report and
Interactive Analysis report is
different.
Partially convertedThe report cannot be refreshed
Fully convertedThe sort is lostSort in a query
Document Properties
Enhanced Viewing setting does
not exist in SAP BusinessObjects Desktop Intelligence
Filters
Filter on a formula
Filter in a block is applied on a
measure
The Enhanced Viewing setting
is enabled
The filter is lost in some casesComplex global or block filter
A variable is created and the filter is applied to the variable
Fully convertedOption is lostDelete Trailing Blanks option set
Fully convertedOption is lostDo Not Retrieve Data option set
Fully converted
Filter/ComplexGlobalFilter or
Filter/ComplexBlockFilter
Fully converted
Filter/BlockMeasureFilterFilter is lost
2010-08-2324
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
Sections
Show/Hide Section Header formula
Show/Hide Section Footer formula
Fold/Unfold
Special report contents
Windows OLE object (static only)
Result in the Interactive
Analysis report
The section header is shown or
hidden if the formula is true.
The section footer is shown or
hidden if the formula is true.
Conversion status or initialization file setting
Fully converted
Fully converted
Fully convertedThe report is converted.Sections
Fully convertedThe report is converted.Tables, crosstabs, and breaks
Fully convertedConverted to GIF format
Picture or OLE object when dynamic (for example, path computed at runtime or using "Read
as pictures" properties)
Blocks
Across Edge Display settings in
crosstabs
Page break header after page
break setting
Page break footer after page
break setting
Fully convertedConverted to GIF formatPicture (TIFF) (static only)
Picture or object is deletedThe picture or object is lost
Fully convertedThe report is converted.Hide Block formula
Partially convertedThe settings are lost
Partially convertedSetting is lost
Partially convertedSetting is lost
2010-08-2325
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
Hide object (in the Block Pivot
settings)
Breaks
Break on multiple dimensions
Note:
This refers to a break defined
on more than one dimension,
not a block that has multiple
breaks on single dimensions.
Break on an object not in the
block
Result in the Interactive
Analysis report
Object is fully converted if the
object is of measurable type.
Conversion status or initialization file setting
Fully converted
Fully convertedThe report is converted.
Fully convertedThe report is converted.
Fully convertedThe report is converted.Folded break
Fully convertedThe report is converted.Value-based break
Pages
Functions
Fully convertedThe report is converted.Page setup options
2010-08-2326
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
ApplicationValue
BlockNumber
CurrentPage
GetProfileNumber
GetProfileString
Hyperlink
OLAPQueryDescription
PageInSection
Result in the Interactive
Analysis report
Appears as RepFormula ("original_syntax")
Conversion status or initialization file setting
Formula/UnsupportedFunction
CountAll
Date formats
All date formats
Cell format
Hide cell formula (free-standing
cells
Border styles
Variables
Converted to Interactive Analysis syntax.
Changed to an equivalent Interactive Analysis format according
to the mappings
The hide cell formula is lost and
the cell is always visible
Converted according to the
mappings
Partially converted
Fully converted
Fully convertedThe fill character is lostFill character
FormatCell/Appearance
Fully converted
2010-08-2327
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
Variable that references another
variable that cannot be converted
Grouped variables
Sorts
A block is sorted on an object
not included in the block
Charts
Result in the Interactive
Analysis report
The grouped variable is implemented with an If function.
Conversion status or initialization file setting
Fully convertedThe variable description is lostAll variables
Not convertedReport is not converted
Fully converted
Fully convertedThe report is converted.
Graph or MultiGroupChartOnly the first group appearsMultiple groups
3D Pie Charts
3D Charts
Series color
Rotation, elevation and start
angle
Plot area
Wall color
There is no plot area in Interactive Analysis 3D Pie charts
There is no plot area in Interactive Analysis 3D charts
The original relationship between a series and its color is
lost
These settings are lost in Interactive Analysis.
The plot area does not exist in
Interactive Analysis pie charts
and 3D charts
All walls have the same color in
Interactive Analysis
Graph or Pie3DChart
Graph or 3DChart
Fully converted
Fully converted
Fully converted
Fully converted
2010-08-2328
Desktop Intelligence feature conversion
SAP BusinessObjects Desktop Intelligence feature
Result in the Interactive
Analysis report
Save options
Write password or protection
password set
Fonts
Fonts are mapped between SAP
Font mapping
BusinessObjects Desktop Intelligence and Interactive Analysis
according to customizable rules.
4.2 Formula conversion in the Report Conversion Tool
The following formulas used in Desktop Intelligence reports are now converted by the Report Conversion
Tool:
• “MultiCube” (renamed in the Interactive Analysis report to “ForceMerge”)
• “DataProviderType”
• “Product”
Conversion status or initialization file setting
Not convertedReport is not converted
Fully converted
2010-08-2329
Desktop Intelligence feature conversion
2010-08-2330
More Information
More Information
LocationInformation Resource
SAP BusinessObjects product information
SAP Help Portal
SAP Service Marketplace
http://www.sap.com
Navigate to http://help.sap.com/businessobjects and on the "SAP BusinessObjects Overview" side panel click All Products.
You can access the most up-to-date documentation covering all SAP
BusinessObjects products and their deployment at the SAP Help Portal.
You can download PDF versions or installable HTML libraries.
Certain guides are stored on the SAP Service Marketplace and are not
available from the SAP Help Portal. These guides are listed on the Help
Portal accompanied by a link to the SAP Service Marketplace. Customers
with a maintenance agreement have an authorized user ID to access
this site. To obtain an ID, contact your customer support representative.
http://service.sap.com/bosap-support > Documentation
• Installation guides: https://service.sap.com/bosap-instguides
• Release notes: http://service.sap.com/releasenotes
The SAP Service Marketplace stores certain installation guides, upgrade
and migration guides, deployment guides, release notes and Supported
Platforms documents. Customers with a maintenance agreement have
an authorized user ID to access this site. Contact your customer support
representative to obtain an ID. If you are redirected to the SAP Service
Marketplace from the SAP Help Portal, use the menu in the navigation
pane on the left to locate the category containing the documentation you
want to access.
Docupedia
Developer resources
https://cw.sdn.sap.com/cw/community/docupedia
Docupedia provides additional documentation resources, a collaborative
authoring environment, and an interactive feedback channel.
https://boc.sdn.sap.com/
https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibrary
2010-08-2331
More Information
LocationInformation Resource
SAP BusinessObjects articles on
the SAP Community Network
Notes
Forums on the SAP Community
Network
Training
Online customer support
https://www.sdn.sap.com/irj/boc/businessobjects-articles
These articles were formerly known as technical papers.
https://service.sap.com/notes
These notes were formerly known as Knowledge Base articles.
https://www.sdn.sap.com/irj/scn/forums
http://www.sap.com/services/education
From traditional classroom learning to targeted e-learning seminars, we
can offer a training package to suit your learning needs and preferred
learning style.
http://service.sap.com/bosap-support
The SAP Support Portal contains information about Customer Support
programs and services. It also has links to a wide range of technical information and downloads. Customers with a maintenance agreement
have an authorized user ID to access this site. To obtain an ID, contact
your customer support representative.
Consulting
http://www.sap.com/services/bysubject/businessobjectsconsulting
Consultants can accompany you from the initial analysis stage to the
delivery of your deployment project. Expertise is available in topics such
as relational and multidimensional databases, connectivity, database
design tools, and customized embedding technology.
2010-08-2332
Index
A
audit report, to view 18
auditing
report conversion results 6
C
conversion
defined 6
conversion process
following wizard 12
conversion results
viewing 17
converting data
option 13
D
DataProviderType formula 29
description
Report Conversion Tool 6
Designer
installing 11
displaying
converted reports results 17
document security
publishing 19
documentation
online downloads 5
F
folders
browsing to select reports 13
ForceMerge formula 29
formula conversion 29
I
installing
client or server 11
Interactive Analysis
documentation 5
features 5
M
migrating
pre-requisites 5
repositories 5
where to go for information 5
MultiCube formula 29
O
opening
selected reports list 13
opening existing document list
conversion process 13
P
platforms
Windows only 11
pre-publishing
understanding conversion results
17
pre-requisites
installing BusinessObjects
Enterprise XI Release 3 5
installing Designer 11
user settings 11
Product formula 29
publishing
converted reports 18
document security 19
R
Report Comparison Tool 19
Report Conversion Tool
overview 5
what is it 6
wizard 12
report structure
converting only 13
reports
accessing them for conversion 6
reports, comparing 19
repositories
migrating 5
S
saving
selected reports list 13
selecting and converting reports
detailed steps 13
selecting reports
using folder tree 13
stored procedures 16
U
user settings
pre-prequisites 11
V
viewing
conversion results 17
2010-08-2333
Index
2010-08-2334
Loading...