Powered By

Free XML Skins for Blogger

Powered by Blogger

Tuesday, December 30, 2008

Creating InfoSpokes in BW BI

Procedure

...

1. In the main menu of the Data Warehousing Workbench, choose Tools ® Open Hub Service ® Edit InfoSpoke Enter a technical name for your InfoSpoke. You can also select a template.

2. Choose This graphic is explained in the accompanying text Create InfoSpoke.

3. Enter a description for your InfoSpoke.

Tab Page: General

4. On the General tab page, select a data source. You can use InfoCubes, DataStore objects, MultiProviders or InfoObjects (attributes or texts). Note that you cannot use input help to select a MultiProvder, you have to enter it manually.

5. Select a destination. You can also enter the technical name of a destination that you are about to create.

6. Select an extraction mode. See InfoSpoke Extraction Mode.

7. Specify the number of rows per data package for the data records to be extracted. You can use this parameter to control the maximum size of a data package and thereby control the number of main memories that need to be made available to structure the data package.

Tab Page: Destination

8. Choose the Destination tab page and enter a description.

9. Select a Logical Target System.

10. Select one of the following destination types:

Database table: For the Deleting the Table Before the Extraction and Technical Key settings, see Extraction to a Database Table. You can also use the Notification to Third-Party Tool indicator to extract data from a third-party tool. See Extraction to Non-SAP Systems. In the RFC Destination field, enter the name of the RFC destination for your third-party tool. You can then choose Parameters to display the parameter table for the third-party tool.

File (CSV): Either choose Application Server or specify a local directory; specify a delimiter of type Character. If you choose the application server as the storage for the file, you can selectFile Name or Logical File Name from the dropdown box. If you choose Logical File Name, you get to the transaction for creating logical file names by double clicking on the field for the file name. See Extraction to Flat Files.

Tab Page: InfoObjects

11. On the InfoObjects tab page, select the InfoObjects that you want to transfer. The available fields are displayed on the right half of the screen. You use the arrow keys to transfer them into the left half of the screen.

The Key Fields for the Table Start pushbutton allows you to place key fields at the start of the field list. With extraction to database tables, you have to extract a field list of this type. With flat files, you need to specify the field list sequence yourself.

Tab Page: Selection

12. On the Selection tab page, you can restrict the selected fields even further. Only simple selections of single values and intervals are possible as restrictions. After you have confirmed your selection, you can use the Selection Category to exclude single values or intervals. To do this, click icon This graphic is explained in the accompanying text or This graphic is explained in the accompanying text (included) and then switch to This graphic is explained in the accompanying text or This graphic is explained in the accompanying text (excluded). The default setting is Included.

Extraction of InfoCubes with non-cumulative key figures:

Set the filter value for 0RECORDTP (record type) to ‘1’. This ensures that all markers in the compressed data of the InfoCube are extracted. You can extract non-cumulatives by compressing the InfoCube in regular intervals and extracting using 0RECORDTP = ‘1’.

Tab Page: Transformation

13. On the Transformation tab page, you can transform the data to be transferred using a BAdI. See InfoSpoke with Transformations using BAdI.

Activating and Executing InfoSpokes

14. Choose Activate InfoSpoke This graphic is explained in the accompanying text .

15. When the InfoSpoke has been activated successfully, choose This graphic is explained in the accompanying text Extraction in the Dialog Process. A status log is displayed.

If you do not want to start extraction straight away, that is, you want to schedule it to take place at a later time, you have to include the InfoSpoke in a process chain. See Including InfoSpokes in Process Chains.

Result

You have extracted data from an open hub data source into a database table or a flat CSV file.

No comments: