Oct 31, 2011

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

Oct 27, 2011

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

Oct 26, 2011

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

Oct 25, 2011

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

Oct 19, 2011

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

Oct 17, 2011

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

Oct 14, 2011

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

Oct 10, 2011

The Diary of a BW 7.3 Ramp-Up project (Part 5)

SAP Network Blog: The Diary of a BW 7.3 Ramp-Up project (Part 5)

Part 1 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23859
Part 2 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24869
Part 3 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25066
Part 4 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25629
Part 5 : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26033

Link to this last part : http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26498


ABAP on Steroids: practical use of parallel processing

SAP Network Blog: ABAP on Steroids: practical use of parallel processing

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

We've all been there, in the trenches, struggling with that long-running ABAP report that seemingly takes hours to complete. Year-end reporting, Financial analysis, Sales reports... you've exhausted the options of using alternative indexes for BSEG (BSIK, BSID, other BS* tables), the customer is screaming at the top of his lungs, but no matter what you do, that darned report just takes too long. And you haven't even released it to Q yet...

Intro

Parallel processing is not a new concept, but one that is regularly overlooked when it comes to increasing ABAP performance. Why?

Your SAP system will (normally) have more than one process available at any given time. Still, most of us insist on using just one of them. This is a bit like a manufacturer relying on only one truck to bring the products from his plant to the shopping malls, when there's a whole fleet of trucks just standing by!

Not only that, but most SAP systems spans more than one application server, each with a range of (hopefully) available processes. So, what are we waiting for?


So Read more on the blog.