Installing SAP Data Services 4.0: Part 3 - Integrating with SAP BusinessObjects BI Platform

I came across a blog where the expert author Stuart Wallace provides details on installing SAP BusinessObjects Data Services. An excellent read.

Installing SAP Data Services 4.0: Part 3 - Integrating with SAP BusinessObjects BI Platform


I hope you will like it.
 
*****
****
***
**
*

How to fix Error 09 ...

Issue:

While activating the DataSource or even when executing an InfoPackage, you might come up with a “Caller 09 …” error message.

While trying to preview data from DataSource, you might come up with this type of error

“S:RSSDK:300 Field DATE not a member of /BIC/CAZDS_TEST_0 00040000001”

FIG 01: Error message in Monitor

 
This error message has the same roots as the error message in the inset box.

This might happen even if you are loading data from a DSO into an InfoCube.

Cause:

It is a memory dump; load got failed due to memory space unavailable.

Troubleshooting:

If you look at details, you will see this message

Error message from the source system

Diagnosis
An error occurred in the source system.

System Response
Caller 09 contains an error message.

Further analysis:
The error occurred in Extractor .
Refer to the error message.

Procedure
How you remove the error depends on the error message.

Note
If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

Check transaction code ST22 to see if there are short dumps.

Check transaction code SM12 to see if there are any locks.

Check transaction code SM21 to check system logs

Check transaction code SM37 to check status of the Job (finished or terminated).

Resolution:

Nevertheless, these points might help:

• If this is happening at the while loading that Data from DSO into the InfoCube, then drop the indexes and try reloading data in several ‘smaller’ request by slitting the data with an appropriate filter on an InfoObject for e.g. 0CALYEAR

• If the source is SAP systems and also if you are in Production environment, it would be necessary to activate the DataSource

1. Go to transaction code SE38
2. Run the program RSDS_DATASOURCE_ACTIVATE_ALL (If you are on SAP BW 3.5, then use this RS_TRANSTRU_ACTIVATE_ALL)
3. Select the Source System and select the DataSource name and click execute. Check box for "Only Inactive objects"

• If this error happens in dev environment and the Source Systems are non-SAP, I would recommend deleting the DataSource and creating a new one. This will surely fix the problem.

The messages in here might be helpful in getting this resolved.

I hope this will be helpful.

*****
****
***
**
*

Comprehensive List of BI Tools - 1 of 10 Parts

I'm starting this blog with a list of all BI tools that I came across. Hopefully I can cover this in 10 parts.

arcplan Enterprise Features: -          Application server works with Windows and UNIX environment and provides centralized web interface to manage Administration. -          Works with different types of DataSources such as ERP (including SAP ERP), relational databases, OLAP, Web Services, etc. -          Comes with arcplan Application Designer as a frontend report designer. Version: arcplan 7 Patch 2 (7.0.2.71) WebSite: http://www.arcplan.com Developed by: arcplan based in Düsseldorf, Germany

SAS Business Intelligence Features: -          SAS Analytics capabilities, including statistics, predictive analytics, data and text mining, forecasting, and optimization – all integrated within the business context for better, faster decision making. -          Portal and customizable dashboards -          Business visualization, Web and desktop reporting, Mobile analytics, Microsoft Office and SharePoint integration, Query and analysis Version: SAS 9.3 Website: http://www.sas.com/technologies/bi/index.html Developed by: SAS Institute Inc

IBM Cognos Business Intelligence Features: -          Designed for enterprise-level deployment -          WYSIWYG capability -          Supported DataSources include: Relational databases from IBM, Oracle, Microsoft, Teradata and Sybase, various sources accessible via ODBC and dimensionally aware sources like SAP BW. -          Supports ERP systems, including SAP R/3, PeopleSoft Enterprise, JD Edwards EnterpriseOne, Oracle eBusiness Suite and Siebel CRM. Version: v10.1 Website: http://www-01.ibm.com/software/analytics/cognos/business-intelligence/reporting.html Developed by: IBM

Will continue with list in part 2 ....

Apache Tomcat Versus Oracle BEA WebLogic

<>   <>     <>    <>    <> 

Issue Type ↓	Apache Tomcat	Oracle BEA Weblogic	Remarks
Version	Apache Tomcat 6.0.26	WebLogic Server 11gR1 (10.3.3)	Apache Tomcat works with BO XI 3.1 while WebLogic 10 is supported also supported
Features	Administration  and  cluster (needs to configure) support, multiple JVM support, OS Windows and Unix platform support, Memory requirements pretty less	administration and clustering support out-of-the-box, Multiple JVM support, OS Windows and Unix supported, minimum memory requirement needed
Acquisition	Comes with BusinessObjects Package hence licensing not a problem and it comes free	Significant license fee
Performance and JVM	Reliable	Reliable
Technical Support	Self Support (mostly from tech forums). No official support from Apache	Complete Vendor Support	In fact, customers prefer BEA Weblogic for efficient technical support but Tomcat is most widely used becuase it is free

Transposing the Fields in SAP BW Transformation

Scenario

The business records the daily exposure and positions into one record for a term. In my example, a term is for 10 days. So the record looks like this:

<> 

Transaction ID	Date	Day 1	Day 2	Day 3	Day 4	Day 5
646578	4/17/2011	432.00	606.00	2011.00	2169.00	379.00

This means that I will have to come up with 10 key figures in SAP BW InfoProvider design which might not be a good design.

Target Design

I wanted to show this as 1 key figure and with another field that shows what day it is.

Transaction ID	Date	Day Ending	Price Per day
646578	4/17/2011	01	432.00
646578	4/17/2011	02	606.00
646578	4/17/2011	03	2011.00
646578	4/17/2011	04	2169.00
646578	4/17/2011	05	379.00

Resolution

The solution presented in here is following this Dataflow: Source System -> Write-Optimized DSO -> Standard DSO. The solution given below can be applied between the Transformation that exists between Write-Optimized and Standard DSO. This can be applied in any Transformations.

Fig 1: Dataflow

This can be extended up to 25 fields. After 15 fields, it might give you an error.

First Solution:

One way to do was to write Start Routine and End Routine in Transformation.

Fig 2: Transformation - Start and End Routine

The code might look like this but you will need to modify this depending on your needs:

Start Routine:

DATA: wa_source_package TYPE _ty_s_SC_1.

    LOOP AT SOURCE_PACKAGE INTO wa_SOURCE_PACKAGE.
      wa_sp-/BIC/ZTRAN_ID = wa_source_package-/BIC/ZTRAN_ID.
      wa_sp-/BIC/ZDATE = wa_source_package-/BIC/ZDATE.
      wa_sp-/bic/ZPDP_DY1 = wa_source_package-/bic/ZPPD_DY1.
      wa_sp-/bic/ZPDP_DY2 = wa_source_package-/bic/ZPPD_DY2.
      wa_sp-/bic/ZPDP_DY3 = wa_source_package-/bic/ZPPD_DY3.
      wa_sp-/bic/ZPDP_DY3 = wa_source_package-/bic/ZPPD_DY3.
      wa_sp-/bic/ZPDP_DY4 = wa_source_package-/bic/ZPPD_DY4.
      wa_sp-/bic/ZPDP_DY5 = wa_source_package-/bic/ZPPD_DY5.

End Routine:


DATA: rem TYPE I.
    DATA: lt_rp TYPE TABLE OF _ty_s_TG_1,
          wa_rp TYPE _ty_s_TG_1.

    lt_rp[] = RESULT_PACKAGE[].
    REFRESH RESULT_PACKAGE.

    LOOP AT lt_rp INTO wa_rp.
      READ TABLE it_sp INTO wa_sp WITH KEY
      /BIC/ZTRAN_ID  = wa_rp-/BIC/ZTRAN_ID
      /BIC/ZDATE = wa_rp-/BIC/ZDATE
  
      IF  sy-subrc = 0.
        wa_rp-/BIC/ZDAY_END = 'Day 1'.
        wa_rp-/BIC/ZPPD_PR = wa_sp-/bic/ZPPD_DY1.
        APPEND wa_rp TO RESULT_PACKAGE.

        wa_rp-/BIC/ZDAY_END = 'Day 2'.
        wa_rp-/BIC/ZPPD_PR = wa_sp-/bic/ZPPD_DY2.
        APPEND wa_rp TO RESULT_PACKAGE.

        wa_rp-/BIC/ZDAY_END = 'Day 3'.
        wa_rp-/BIC/ZPPD_PR = wa_sp-/bic/ZPPD_DY3.
        APPEND wa_rp TO RESULT_PACKAGE.

        wa_rp-/BIC/ZDAY_END = 'Day 4'.
        wa_rp-/BIC/ZPPD_PR = wa_sp-/bic/ZPPD_DY4.
        APPEND wa_rp TO RESULT_PACKAGE.

        wa_rp-/BIC/ZDAY_END = '0ay 5'.
        wa_rp-/BIC/ZPPD_PR = wa_sp-/bic/ZPPD_DY5.
        APPEND wa_rp TO RESULT_PACKAGE.

Transformation looks like this:

Fig 3 : Transformation with Start and End Routine

Second Solution:

By using the Rule Groups
We can use the Rule Groups functionality to achieve the same what I did with Start and End routine.

1. Create two new InfoObjects: Day Ending (Characteristics type and type CHAR with Length as 6 and Price Per Day (Key figure as Amount)
2. Insert these InfoObjects Standard DSO
3. In the Transformation between, Write-Optimized DSO and Standard DSO, click on Rule Groups and create one.

• For day 1, give the name of the Rule group as Day 1, Map the Price Per Day 1 to Price Per Day and Hard code Day Ending as Day 1
• For day 2, give the name of the Rule group as Day 2, Map the Price Per Day 2 to Price Per Day and Hard code Day Ending as Day 2

Follow the same steps for all other days.

Fig 4: Rule Groups

The data that looked like this earlier

Fig 5: Data in Write-Optimized DSO

Will look like this

Fig 6: Data in Standard DSO

I hope this will be helpful to somebody.

*
**
***
****
*****

SAP Education – Listing of Available Certification Exams in the United States and Canada (as of 09/02/11)

As given to me Kenneth Schieffer (SAP Education Program Manager - North America):

·         To use the certification discount promotion in the attachment, register for exam(s) at Pearson VUE (http://www.pearsonvue.com/sap)

·         To register for exams at SAP delivery centers, call 1-888-777-1727 or email education.northamerica@sap.com

·         To register for training to prepare for certification, call 1-888-777-1727 or email education.northamerica@sap.com

Good luck with the certification exam!

NOTE: To register for any SAP exam at an SAP Delivery Center, please select the "Book" button from the exam description page or call North American Central Registration at 1-888-777-1727.

SAP Education uses Pearson VUE as an exam delivery partner in the US and Canada (www.pearsonvue.com/sap). You can use VUE’s website to locate a test center, schedule an exam, and view the available SAP exams.

*************************************************

US AND CANADA CERTIFICATION PROMOTION ANNOUNCEMENT

Until December 31, 2011, you can use promotion code 10CERTSS at Pearson VUE’s US and Canadian delivery centers (http://www.pearsonvue.com/sap) to register for 50% discount certification exams. This promotion cannot be used in conjunction with any other SAP certification promotion in the US and Canada and will not be extended into 2012.

*************************************************

For more information about SAP Education’s Certification Program, please visit:

Certification Program Description

Search for an Exam

Sample Questions

Policies & Procedures

Certification FAQ

eAcademies

Certification Spotlights


    o Certification Success Story – T-Systems

    o Fuel Your Career with SAP Certification

    o Outclass the Competition with SAP Certification


DON’T MISS THE NEW CERTIFICATION EXAMS (with more on the way including SAP BusinessObjects and Hana)!!


o P_BC_10 - SAP Certified Professional Business Consultant

o C_BOBIP_40 - SAP Certified Application Associate – SAP BusinessObjects Business Intelligence platform 4.0

o C_TEP10_702 - SAP Certified Technology Associate NetWeaver Portal 7.02

o C_TBIT44_73 - SAP Certified Development Consultant SAP NetWeaver 7.3 - Exchange Infrastructure

o C_TBIT51_73 - SAP Certified Technology Associate – Process Integration with SAP NetWeaver (PI 7.3)

o C_EPMBPC_75 - SAP Certified Application Associate - SAP BusinessObjects Planning and Consolidation 7.5

o C_EPMFC_75 - SAP Certified Application Associate - SAP BusinessObjects Financial Consolidation 7.5

Copyright/Trademark

Collaborate, engage, and learn with SAP Education Social Media

See the new SAP Education video: http://www.youtube.com/watch?v=diSw24AlUhE

SAP Education North America Course Schedules Powered by Crystal Reports - SAP and SAP BusinessObjects portfolio schedules: by week, by location, by course, and guaranteed-to-run.

EXAM CODE	DESCRIPTION	AVAILABLE AT SAP?	AVAILABLE AT PEARSON VUE?
NETWEAVER – BUSINESS INTELLIGENCE
C_TBW45_70	SAP Certified Application Associate- Business Intelligence with SAP NetWeaver 7.0	YES	YES
P_BIE_70	SAP Certified Application Professional - BI Enterprise Data Warehousing with SAP NetWeaver 7.0	YES	YES
P_BIR_70	SAP Certified Application Professional - BI Reporting and Analysis with SAP NetWeaver 7.0	YES	YES

EXAM CODE	DESCRIPTION	AVAILABLE AT SAP?	AVAILABLE AT PEARSON VUE?
SAP BUSINESSOBJECTS
C_BOCR_08	SAP Certified Application Associate - Crystal Reports 2008	YES	YES
C_BODI_20	SAP Certified Application Associate - SAP BusinessObjects Data Integrator XI R2	YES	YES
C_BOE_30	SAP Certified Application Associate - SAP BusinessObjects Enterprise XI 3.x	YES	YES
C_BOWI_30	SAP Certified Application Associate - SAP BusinessObjects Web Intelligence XI 3.x	YES	YES
C_BOBIP_40	SAP Certified Application Associate – SAP BusinessObjects Business Intelligence platform 4.0	YES	PLANNED
C_BOSUP_90	SAP Certified Support Associate – Incident Management with SAP BusinessObjects	YES	YES

*************************************************