BI Lauch Pad

Notes from SAP HELP

1 Using the BI launch pad

1.1 About the BI Launch pad

The BI launch pad has the following main tabs: Home, Documents, and any open document.

Use the Applications tab of the BI launch pad to start an application including Web Intelligence.

Use the Preferences menu to set the preferences.1.2       To log in to the BI launch pad

Before you can perform interactive analysis from the BI launch pad, you need the following information:

  • a URL to the BI launch pad (for example http://arcachon:8080/BOE/BI).
  • your login and password
  • your authentication, which controls the resources available to you

Contact your administrator for these details if you do not already know them.

Note:

By default the server name and Continue reading “BI Lauch Pad”

ABAP Dataflow & TransportS in BODS

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

This  post introduces the SAP BusinessObjects Data Services objects for extracting data from SAP application sources:
• SAP Applications datastores
• ABAP data flows
• transports Continue reading “ABAP Dataflow & TransportS in BODS”

Multiuser functionality in SAP Data Services

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

In this post you will create two local repositories and one central repository and perform the tasks associated
with sharing objects using Data Services. Continue reading “Multiuser functionality in SAP Data Services”

Recoverable workflow in BODS

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

This post describes on how to:

• Design and implement recoverable work flows.
• Use Data Services conditionals.
• Specify and use the Auto correct load option.
• Replicate and rename objects in the object library.

Continue reading “Recoverable workflow in BODS”

CDC in BODS

Changed-Data Capture

This post introduces the concept of changed-data capture (CDC). You use CDC techniques to identify changes in a source table at a given point in time (such as since the previous data extraction). CDC captures changes such as inserting a row, updating a row, or deleting a row. CDC can involve variables, parameters, custom (user-defined) functions, and scripts. Continue reading “CDC in BODS”

Joins and Lookup in SAP Data Services

Courtesy: SAP HELP DOCUMENTS ON SAP BusinessObjects Data Services 4.0 (14.0.1). All the images are copyright of the SAP Software.

 

This post discusses on join conditions and look up in Data Services.

Populating the Sales Fact Table from Multiple Relational Tables

Continue reading “Joins and Lookup in SAP Data Services”

Debugger in SAP Data Services

This post describes on how to use debugger in Data Services.

Using the interactive debugger

The Designer includes an interactive debugger that allows you to examine and modify data row by row by placing filters and breakpoints on lines in a data flow diagram.
A debug filter functions as a simple query transform with a WHERE clause. Use a filter to reduce a data set in a debug job execution. A breakpoint is the location where a debug job execution pauses and returns control to you.
This exercise demonstrates how to set a breakpoint and view data in debug mode. Continue reading “Debugger in SAP Data Services”

SAP Data Services Designer tool

This post gives you a short overview of the Data Services product and terminology.

Data Services Components

The following diagram illustrates Data Services product components and relationships-

Continue reading “SAP Data Services Designer tool”

Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube

This post is just for demonstrating the use of virtual infocubes and direct access DTPs as these are not used so frequently while modeling.

There is no data acquisition and the BI system connects remotely to the source when the query is called by the user. This is particularly useful where very less data need to be retrieved and it changes frequently.

There is also a concept of using Open ODS views if your BW system is based in HANA, where there is a similar access to source tables directly and queries are based on the source fields. Continue reading “Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube”