| 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 |
This blog wil be updated almost daily and the topics will be dealing with the daily support of SAP BusinessObjects BI support. So check back daily!
Tuesday, September 20, 2011
Apache Tomcat Versus Oracle BEA WebLogic
Sunday, September 11, 2011
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:
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.
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.
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.
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:
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.
The data that looked like this earlier
Will look like this
I hope this will be helpful to somebody.
*
**
***
****
*****
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
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.
- Create two new InfoObjects: Day Ending (Characteristics type and type CHAR with Length as 6 and Price Per Day (Key figure as Amount)
- Insert these InfoObjects Standard DSO
- 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
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.
*
**
***
****
*****
Tuesday, September 6, 2011
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:
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:
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 |
*************************************************
Subscribe to:
Posts (Atom)
