SAP BO – WORKING WITH DOCUMENTS

Creating and editing documents

You can create or edit documents from the BI launch pad using SAP BusinessObjects Web Intelligence or Web Intelligence Rich Client, which allows you to work with documents offline without a connection to the corporate repository.

You can base documents on universes, which present data in relational or OLAP datasources as collections of objects, on local data sources such as Microsoft Excel or CSV files, on SAP BEx Queries, or on Advanced Analysis workspaces.

You create a new document, either a blank document, or a document based on a data source. Continue reading “SAP BO – WORKING WITH DOCUMENTS”

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”

Creating Webi Reports

Open the Java BI Launch Pad which can be found in below path on your desktop-

Start – All Programs – SAP Business Intelligence – SAP Business Objects BI Platform 4 – SAP Business Objects BI Platform Java BI Launch Pad

Create1.png

Internet explorer window opens showing below screen. Give the user name and password.

Create2.PNG

In the BI Launch Pad, you can view the reports in the Public folder and also you can create webi reports. The home screen looks like below where you can see your recent documents, messages and alerts. Continue reading “Creating Webi Reports”

Webi 4.0 Introduction

Webi is a reporting tool used extensively now to report on data coming from BW or directly reporting on HANA/ECC data.

Webi is not restricted to BI developers and can be used by business user to format and analyze data in a suitable way.

SAP acquired Business Objects tool in 2008 and renamed it as BO XI 3.1

At the end of 2011, BO XI 4.0 version was released.

These notes will discuss about versions 3.1 and 4.0 as there are lot of migration projects going on from 3.1 and 4.0 and around 70% of the business users are still using 3.1 version.

Component wise BO Architecture

Repository and database

Once you install BO in your machine, it will create a repository. This repository is sitting on a database. It can be oracle, sap bw, CSV file or XML which will act as source of data or a data warehouse.

All the universe, table structure, Bex queries structure etc. will be stored in the repository.

CCM

CCM stands for ‘Central Configuration Manager’. This is a tool where you can start/stop server, configure an new server etc. Continue reading “Webi 4.0 Introduction”

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”