SAP WORLDBegining of New ERP World

We’re used to seeing IT industry megavendors such as SAP augment their solutions with web 2.0 technology from smaller vendors, but now one of the leading enterprise 2.0 companies is turning to SAP for a cloud computing offers to extend new capabilities to customers.
At the Enterprise 2.0 2009 event in Boston, Jive and SAP announced that Jive is going to be a reseller of SAP’s on-demand BI solutions, providing “social BI” to their customers.
SAP has long been a customer of Jive Software’s Enterprise 2.0 collaboration platform, notably to power the forums on the SAP Development Network, and SAP’s Collaboration Workspace, and a few years ago SAP signed an OEM agreement to include Jive Forums as a standard part of the SAP NetWeaver portal application.
This announcement is a clear sign of the growing maturity of the enterprise 2.0 market, in two different ways.
First, it’s the first concrete results of SAP’s increased focus on the web 2.0 market, and in particular the investment in the SAP BusinessObjects portfolio of products, designed to transform the work of “business users” in the same way that ERP has transformed operational processes.
SAP BusinessObjects was one of the early pioneers in the on-demand business intelligence market, with a flexible platform that provides the best of both worlds: customers can use the same technology platform in a mix of on-demand or on-premise configurations, and move smoothly between the two. SAP’s agreement to partner with Jive is non-exclusive: the on-demand BI software is already used within other partner solutions including Oco.
Second, it shows that enterprise 2.0 solutions are real, and providing value in organizations. Jive’s 3,000 customers include many large organizations, that have been gathering valuable data about how companies collaborate internally and engage with customers and partners externally. As with any successful business process, they now want to examine and optimize that process, and mine that data with best-of-breed business intelligence tools.
These two trends were echoed by Susan Scrupski of ITSInsider, in her post And They’re Off. A Postcard From Enterprise 2.0 Event:
“This new venture, however, marks a clear initiative by SAP to (finally) take social software seriously, and likewise, it provides a grownup capability for a social software platform like Jive to deliver some clear business benefit.”
I believe business intelligence is an essential part of any successful enterprise 2.0 initiative, in order to:
Provide statistics on usage trends. Business intelligence helps proactively identify any technical or social roadblocks to effective deployment of collaboration tools, answering questions such as:
When are the peaks and troughs of user activity? What causes them?
Who has access to the system but is not using it?
Which users have recently stopped using the system? Do they share any common characteristics?
Are there any regular occasions where particular groups don’t use the system? Why?
Prove the ROI. Business intelligence functionality will help provide the data required to prove to skeptics of the value of collaboration and social computing inside organizations.
Are users of the system more likely to get better (or worse) employee evaluations or bonuses?
What’s the correlation between any groups of identified “top performers” and system usage?
Do sales people who use the system achieve quota faster than sales people that do not?
Does using the system replace other types of internal information dissemination, such as attending internal web seminars, or does it complement it?
Is there any correlation between system use and employee or customer satisfaction?
Are customers that engage in collaboration more or less profitable?
Optimize social relationships. If enterprise 2.0 software generates return on investment, it follows that it makes sense to try and optimize its use. Business intelligence systems can help decide where the network of relationships between employees, customers, and partners can be improved:
Are there certain key “connectors” that provide a valuable service, but are not being recognized as such within the organization?
Are there any groups of people that collaborate among themselves, but not with the rest of the organization? (e.g. bosses that frown on “their team” working with other departments)
Do similar groups (such as regional sales offices) have different patterns of relationships? Why?
Are there people that seem to be a negative influence on relationships within the organization? (e.g. detecting “bad bosses”
Did the new bonus or incentive system we just introduced stop people collaborating?

Analyzing sentiments. Collaboration technology generates a lot of textual information that can be analyzed using technology such as SAP BusinessObjects’ Text Analytics, for analyzing the sentiment of customers, partners, and employees, about products, processes, or the collaboration system itself.
Note that in every case, it’s not enough to have information just from the collaboration system – it must be combined with information from other key financial and HR systems in order to get a full view of what is happening. This means that organizations must have a strategic approach to implementing business intelligence across the organization.

Source: sapweb20.com

Data Extraction to flat files can be made in different ways but  extraction of data in Debug mode using EXIT_SAPLRSAP_001 sap exit is more efficient,less consumption of memory and time.

The Common Challenge that we go through in RSA3 is Memory and the Amount of data inside the Database 

For example lets take 0FI_GL_4,the table used are BSEG and BKPF .This Datasource Generally contains huge Data and when you execute the datasource , the system takes a lot of time and at the end it generates short Dump. the Dump is as shown below.

In order to over come the above challenge,  lets start up with Extraction using Debug Mode.

Detailed Steps:
Please follow the below steps…

Step1 

Log on to the ECC system . go to Transaction Code SE37 give the Function module name EXIT_SAPLRSAP_001.

Get into the function module and set a break point on the INCLUDE ZXRSAU01 Structure and exit from the screen.

Step2

Now Go to the Transaction Code RSA3.

”

Give the Datasource name 0FI_GL_4.

Increase the Data Records / Calls to 999999 and Display Extr. Calls to 1 because we can see all the data in single Data packet and can easily extract all the data to a flat file. 

Now press Execute (F8) since we have  already set a break point ,after a Few minutes the screen gets into the Debug mode and stops. At this time the data is ready for extraction inside the internal table C_T_DATA in a single Packet.

Step3

In the ABAP Debugger Screen, Type C_T_DATA[] as show bellow and press Enter.

Now it will show the total number records inside the datasource , here in this example the total number of records is 815572.

Step4

Double Click on the C_T_DATA, now we can view the entire data of the Datasource as shown below.

In case if the number of records are more than 999999 we should increase the DisplayExtr Calls to 2. and extraction is done in two different packets one after the other.

we have captured whole Data inside the internal table C_T_DATA,from the internal table we need to export it to a flat file using the icon save as excel sheet as shown in the figure below.

Step5 

Press Continue and save the data in a difftent name, here the name of the file is 0FI_GL_04_All_Data.

The system takes some time to get saved inside the local machine. wait for few minutes and then open the file which is saved in the local system.

The Output looks as below Shown.

Note : This extraction is advisable to install Microsoft Office 2007

Because in Microsoft 2003 the  Number of rows is  Limited to 65536

But in Office 2007 Excel supports more than 1 Million Records

Source:  Santhosh Nagaraj   SAP BI Consultant , Quinnox Consultancy Services , Bangalore