Applies to:
SAP Business Intelligence 7.0. For more information, visit the Business Intelligence homepage.
Summary
This document describes how-to map transformations easily in SAP BW, using Tabular View.
Author(s): Carlos Basto
Company: Accenture
Created on: 09.05.2011
Author bio
Carlos Basto is a Senior Programmer at Accenture. He has been involved in SAP BW Consulting and Support Projects.
Step by Step Solution
A way of mapping transformation 7.0 a little easier when some documentation requires this.
1. Find the transformation
2. After this, select: [display]
3. Select in SAP menu [Extras] and after [Tabular View].
4. This way, we have a TABULAR VIEW.
5. In Tabular View Header there will be links with interesting functionalities.
6. The highlighted options above allow us to view detailed used rules or not as much as all used
fields. For example: assignment or routine.
In this table, we can find data as Source, InfoObject Source, Target, Descriptions, Rule type etc.
7. However, we can`t use Ctrl C and V easily. To get there, we can select (with the right mouse
button) on the pagehead the option [View Source].
8. By using this option we get a view of the source code used on the page.
9. To get access to information easily is necessary to save this code as .XLS or .XLSX file.
test.xls
10. The listed data will be available to use Ctrl C and V which facilitates to filling out document.
HINT: Excel configurations as [Unmerge Cells] and [Filter] can help us in the data extraction.