What is SAP BusinessObjects Predictive Analytics? 

0

The Big Trends in Business Intelligence Competency Centers

0

The Big Trends in Business Intelligence Competency Centers

0

 

Updates on BI4.1 SP06 and Plans for BI4.2

0

1abi42

 

3afig

BPC – RELEASED NOTES AND KBAS

0

BPC-NW

2049365 BPC NW 10 model copy error: Invalid BW namespace definition
2060078 GetActiveconnection did not work
2074370 BPC NW: Does Business planning and consolidation support SAML Single Sign On?
2075296 EPM Add-In 10: EPMContextMember does not retain member of a locked context
1996802 Unable to delete associated roles after deleting environment
2028818 Lite Optimize package not working as expected on BPC 7.53 with HANA DB
2066596 An exception ‘CX_SY_RANGE_OUT_OF_BOUNDS’ occurs while loading infoObject master
2068920 Dump error ‘ASSIGN_TYPE_CONFLICT’ when importing master data and text from info
2071021 Cannot import text when there is no master data existing for a certain ‘Attribu
2011994 In BPC 10.1 Why is ‘Create’ button grayed out
1968164 Introduction of IMG parameters and programs related to Report Query Cache on HA
2036295 QTD and YTD data is not correct for INC and EXP account
2055261 The key words [LEVEL **] not support in member formula when HANA MDX enabled
2074406 TSV_TNEW_PAGE_ALLOC_FAILED dump when refreshing report – BPC NW
2075662 BPC MDX query is on top of default query
2040546 UJSTAT does not work when write back calls script logic
1703160 Fail to delete BPC Application (multiprovider) when deleting / cleaning AppSet
1988519 BPC-NW Transports using ChaRM

 

BPC-MS

1505572 Reporting Services Error when Running Security Reports
1785586 BPC MS: Variance in expected values when using offline distribution and collect
1820002 BPC: Exception: ExecuteScalar requires an open and available Connection
1934069 BPC MS Server Manager Authentication Error
2074884 Comment count appears in one application set but not another
2067959 BPC MS 10: Sizing information
2072060 EPM Add-In 10 SP19 – Context inside EPM Pane not available
2073277 BPC : Error :  “The following componets are required: 2007 Microsoft Office Sui
2073665 BPC10: Cannot create new conversion file
2074905 How do you limit the view package status to show only the packages run by that
2075292 BPC MS 10.0 Error: Task Scheduler failed to start “\DM_xx_xxxxx_nn.job” task”

 

EPM-XLS

2058776 EPM add-in for Microsoft Office SP19 Patch 01
2058719 ALL: Limitations for Guided Member Recognition
2070680 BWINA: Descriptions not available in Member Selector
2072802 INABW: Error when opening workbook from server
2073369 ALL: Multi-member page axis with several reports
2073553 ALL: Member Selector unresponsive

SAP Predictive Analysis 1.19: What’s new in SAP Predictive Analysis 1.19

0

Several new features have been introduced in SAP Predictive Analysis 1.19. In this video, we’ll review these features.

Watch this Tutorial

World of Big Data – “Microsoft / Infinity Room”

0

World of Big Data –  “Microsoft / Infinity Room”  

White paper – Hadoop Using SAP Data Services and SAP HANA

0

white_paper_icon

 

This white paper, developed at SAP co-innovation Lab,  explores how IT organizations can use solutions from SAP and our partners to harness the value of large volumes of data stored in Hadoop, identify salient entities from unstructured textual data, and combine it with structured data in SAP HANA to leverage meaningful information in real-time.

View this Document

Best Practices and Lessons Learned from Vodafone’s SAP HANA Implementation – Webinar

0

webinar

 

DATE: Wednesday, 20 February 2013
START TIME: 8:00 a.m. PT, 10:00 a.m. CT, 11:00 a.m. ET, 5:00 p.m. CET
PRESENTER: Mark Heffernan

 

SUMMARY

In December 2012, Vodafone went live on the SAP HANA platform. Today, SAP HANA supports a data mart scenario that speeds up Vodafone’s crucial financial month-end close process.Join SAP, Vodafone, and Accenture Project Team members for the next CSA Know-How Network Webinar on February 20, 2013, to hear about lessons learned and best practices for implementing and running SAP HANA.

 

During the Webinar, Mark Heffernan, SAP, will lead a discussion on project scope and benefits, detailed implementation requirements, detailed modeling examples, and the next steps for SAP HANA at Vodafone.

 

 

CALL-IN INFORMATION

DIAL-IN NUMBER(S): CSA Know How Series dial-in numbers
ACCESS CODE: 118045
WEB ACCESS: https://sap.emea.pgiconnect.com/know_how/

R/3 Data Cleansing or Validation Using Data Services (ABAP Program Method)

0

Data Cleansing

 

Process to Cleanse or Validate the data in R/3(ECC) andLoad it back to R/3 tables using Data Services.

One can perform R3 data validation and cleansing using Data Services, with one of the following methods:-

1. ABAP PROGRAM

2. USING IDOC

3. USING BAPI

In this example i have used the first method, i. e ABAP Program.

To handle this i have created custom table in ECC and stored few records into it. Then using Data Services extracted the data from ECC and did the required transformation and finally uploaded into the ECC table with ABAP Progarm.

Following is the step by step approach to handle R3/ECC table data.

 

1. Create a DataStore with R3/ECC Credentials.

image

 

2. Create a Project (Ex: PROJECT_R3_EXTRACT).

image

3. Create a Batch Job (Ex: R3JOBRUN).

 

image

4. Now the screen will look like below.

 

image

5. Under the Job add a WorkFlow.

image

6. Under WorkFlow add a DataFlow.

image

7.Double click on DataFlow.

8. Drag and Drop the R/3 Flow from the palate.

9. Provide the Source DataStore Name, ABAP file name to be generated , ABAP program name in R/3 and the Job Name. Follow the 8 character naming convention.

image

10. Drag and Drop aTemplate Table for staging purpose. Then Drag and drop the transformation in Between R/3 Flow and Template Table and Map Accordingly.

image

11. Map the R/3 flow with transformation and then to the Template Table.

image

12. Double click on the R/3 Flow to Add the source table , transformation and transporter.

image

13. Drag and Drop the Source R3/ECC table and transformation.

image

14. Drag and Drop the Transport from the right palate.

image

15. Map the Source table with Query(Transformation) then the query to Transport.

16. Double click on the Transport and provide the data file name (the output file where the final data will be stored after Validation and Cleansing).

 

image

 

17. Double click on the Query, Drag and Drop the required source fields into the Query. Here we can apply the required transformation (Validation, Quality and Cleansing Techniques).

image

18. Double click on the Transport to view whether the required fields to transfer are mapped or not.

 

image

 

19. Go back to the DataFlow Level and double click on the template table (Staging Table) to confirm the mapping, look into the transformation in between.

image

 

20. Save the Project. image

 

21. Execute the Batch Job.

image

22.In  the below screen the Job execution is showing errors but once you map the template table with transformation you will not get any errors.

image

 

23. After successful Execution of the Job Check the Data File and the ABAP Program File generated in the Provided Path at the time os DataStore Creation. (R/3 credentials path, In my Ex: D:\USR\SAP)

24. Once the DataFile is generated , We can upload the DataFile into the target table using a ABAP Program (Ex: ZFILEUPLOAD Program).

image

image

image

image

 

image

 

25. Execute the above Sample Program in SE38, which is used for file uplaod. Change the Code according to your file structure.

26. After execution the input screen will pop-up, where we have to provide the DatafFile path and name. (Select browse for selection DataFile).

image

 

image

 

27. After execution or Run, the qualitative data will be uploaded into the R3/ECC tables.

This Article is written by chintada shankar who is working as a Sr. BW/BI/BO Consultant