Repeat Delta Elucidate From OLTP to BW System

Repeat Delta Elucidate From OLTP to BW System

In some business process data loading will be conducted on hourly bases through Timestamp Field, are often required as delta criteria for generic delta extraction. However, in many tables such the timestamp field is not available; instead the creation/change date and time are available. Generic delta needs to function on one field. This article explains how exactly request are processed BW system to at OLPT server and what are the dependent fields are interlinked to fill the TIMESTAMP field on runtime extractor.

Read further at ...http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26717

Dynamic Attachment using Simple Transformation

Dynamic Attachment using Simple Transformation

The main focus of this article is not about sending mails when a work item is created, currently the main focus of this article would be to creating an attachment dynamically. The attachment can be a .DOC, .XLS, .PDF, .XML.

The term dynamic here refers to the data and content that are populated during the workflow execution that can be either populated in the workflow container or work item container. This article specifically deals with creating a excel sheet and it can be extended to such an extent where you can even populate list values inside the generated excel sheet.

Ok…… let me say you how it can be done in simple 3 steps.

1. Create a Business Class by including IF_WORKFLOW interface in the class.
2. Create a Simple Transformation,to populate the values in the excel sheet call the transformation from a method created in the business class.
3. Create a Standard task and include the new business class and method name and define the proper binding and finally include this task in a workflow.

Read here further... Link : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26428

Program to Activate Transformation & DTP

Program to Activate Transformation & DTP

OVERVIEW

This paper provides a code which can be used to activate inactive Transformation's and DTP's. SAP has provided various programs for activating info-providers, transfer rules, etc but these two programs were missing from the standard set of programs.

Link : http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d02513b2-7fb6-2c10-3a8b-887fc115d61b

PDF Download : http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d02513b2-7fb6-2c10-3a8b-887fc115d61b&overridelayout=true

How to save your Listcube selction screen and the output.

How to save your Listcube selction screen and the output.

Just found an quick information in SAP BI from LISTCUBE tcode so thought of sharing the same across others because I suspect only very very few make use of this .

Have you ever thought of how to save selection screen and output fields in tcode LISTCUBE? If not below are the steps to be followed to make use of it.

Advantages:

• This will help in reusability like avoiding the LISTCUBE tcode again and again for the same selections.
• This will also helps you to reduce certain amount of your manual work.

Link : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26903

How to Fetch Your Infopackage Details From R/3 System.

How to Fetch Your Infopackage Details From R/3 System.

Sharing a small piece of code which help you a lot in indentifying the BW system or Info package details at R/3 system while you write your custom code in CMOD at data source level. This code will help you in following below situations.

1) Remote Function Call: If you need to call Function Module written in BW system from R/3 system for any manual manipulation.

2) To Identify BW Load request details at CMOD code Level.

3) When a R/3 system is connected to Couple of BW system.

4) From one R/3 system when the data has to be sent differently for same data source to two different BW systems at CMOD level.

Read more at : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26901

The BW - HANA Relationship

The BW - HANA Relationship

With the announcement of HANA*, some customers, analysts and others have raised the question on how HANA relates to BW with a few of them even adding their own, home made answer in the sense that they speculate that HANA would succeed BW. In this blog, I like to throw in some food for thought on this.

Currently, HANA's predominant value propositions are

• (i) extremely good performance for any type of workload

• (ii) a real-time replication mechanism between an operational system (like SAP ERP) and HANA

Read more on SDN : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21575

Learn your BW in hard way

Useful information about BW system is spread into several tables in the system as itself.

That’s usual case. Skilled BW guy knows where to look in order to lookup information that is needed. It is common to know basic tables with IOs (RSDIOBJ), reports (RSRREPDIR), cubes (RSDCUBE), DSOs (RSDODSO), process chains (RSPCCHAIN) etc.

More technical BW guy would also know where to find information about basic BW system settings (tables RSADMINA, RSADMINS, RSBASIDOC, etc.).

To Read more : go to link below.

Link: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26171

Demystifying aggregates in SAP BI 7.0

Demystifying aggregates in SAP BI 7.0

Demystifying aggregates in SAP BI 7.0

Aggregates are subsets of InfoCube data, where the data is pre-aggregated and stored in a InfoCube structure. Aggregates on an Info Cube can be considered similar to that of an Index on a database table. Creating an Aggregate on an InfoCube is one of the few ways to improve performance of SAP BW Query. Subset of an InfoCube data is stored in an Aggregate. As a result, the response time that we get out of reading the data from aggregate will be much faster than reading from an InfoCube.

Read more @ http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26054

SAP BI Statistics Installation

SAP BI Statistics Installation

This blog shares author's personal experience during installation of "Standard BI statistics" on  BW system ; it is already provided by SAP as a standard content for analyzing performance of different cubes,reports in the system.

Link : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26437

How To Collect a Variant and ABAP Program in a Transport

How To Collect a Variant and ABAP Program in a Transport (BI - Process Chain)

Business Scenario

"Sometimes, you would need to collect a variant of an ABAP program and transport across systems (D/Q/P)."

Details:

You wish to have an automatic ticketing mechanism in which each process chain failure will generate a ticket ( in our case it's Remedy) and thus the efforts are tracked. So in each of your process chain's you want to check the failure(s) and intimate to the Firefighting team.

To achieve this you have setup a custom program step (in all chains) to generate a message with complete details of failure and you would want this program to get executed with a predefined variant across all boxes (DEV/QAS/PRD).

For this to happen, you may want to transport the variant along with the program step. Variants are not automatically collected in transports as we build them, nor when we drag a process chain into transport manager (even when using the before and after setting).

To read more... go to the original blog @ http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26516