Day: February 27, 2018

#Technology At Mobile World Congress (MWC) 2018, Huawei officially released the 5G multi-service fronthaul bearer solution. It supports multiple types of services including mobile service transmission, cloud-based private line, and wide coverage of home broadband to help operators use one network for multiple purposes. The solution greatly reduces the network construction cost and site construction period and maximizes network value. This solution is key to Huawei’s X-Haul 5G bearer solution, and will further consolidate the leading advantages of Huawei’s X-Haul 5G solution. http://bit.ly/2F7cO4i #Huawei #BigData #AI

There has been a shift in the way business applications are developed with the availability of SAP HANA. Idea is to move logic (code) as much as possible to the Database so as to get performance benefits. To simplify this code push down to database, SAP has provided new data modelling technique called Core Data Services (CDS).

SQL based data definition is used to define CDS views with additional concepts of associations (similar to joins) and annotations. To know more about CDS annotations click here.

CDS has become the keystone for application development as this can be used to build core transactional functionality as well as analytical content for reporting.

In this Document we will see how CDS views can be used for Delta Data Extraction or Real Time Streaming to BW

Pre-requisites

BW data extraction is not supported by S4HANA 1511. Minimum system requirement is S4HANA 1610 or Higher. With 1610 SAP has introduced some new annotations to facilitate data extraction to BW using CDS views.

Source Requirements

Full Data Extraction or Direct Access: Minimum of NetWeaver 7.5 SP04 or equivalent.

Delta Extraction: Minimum of NetWeaver 7.5 SP05 or SAP BW/4HANA SP01

Target Requirements

Minimum of NetWeaver 7.3 SP08 or equivalent (ODP recommendation)

For the extraction of data into BW, ensure an ODP source system of type ABAP_CDS is available to connect to the source system.

Extraction shown in this document is done on system on S4HANA 1610 with embedded BW components.

Delta Extraction of CDS-ODP source to BW

In this example Delta extraction will be shown for changes in the FI documents. CDS view to fetch the delta records for any changes in the FI document with object class ‘BELEG’ or ‘BELEGMASS’ or ‘BELEGR’ will be created and used for the same.

Create Delta enabled CDS View

* Go to the Eclipse editor and create a CDS View.

* Provide CDS View details

* Select The Transport number

* CDS view with blank template will be generated

* Provide the SQL View name (with this name view will be created in back-end system) and write the view query logic. Make sure to use the Analytics annotations for the element/field to be considered for delta identification (it could be Date or timestamp type filed)

* As we need timestamp field (for multiple time execution in a day) for delta extraction and we don’t have the same in CDHDR table, convert the change date and change time into time stamp and cast it to timestamp format (By default the converted field is created of type Char). Also use Semantics annotation to enable the filed for delta extraction as shown below.

* Activate the CDS View. It will generate the View in backend system with the name provide in step 5.

* The timestamp field we created in our view will be created with data type DEC. But nothing to worry, it will be work as timestamp only.
* Execute the View to see the content and verify the generated timestamp field

* With this, we have created our delta enabled CDS view.

Create a BW data source

* Open the BW perspective in eclipse and create a BW Project. Under the Data Sources tab in left hand side window, you should see your source Logical system under ODP-ABAP CDS views node

* Under the Logic system you will see the node for different application areas. Select the node under which you want to create your Data Source. Right click on the node->New->Data Source

* You will get the below pop up window with default values for BW project and Source System. Click Next.

* In the next popup window select the “Proposal from operation Data Provider” radio button and click Next.

* In the next popup window, select the CDS View created in earlier steps and Click Next.

* Enter the Data Source description and click Finish

* Data Source created as shown below. Click on Activate Icon to activate the Data Source.         

* Once Activated, click on “Extraction” tab highlighted in above step. You can the Data Source is created with Delta Process “After Images via Delta Queue (FI-AP/AR for example).

* Right click on the Data Source in the light side window and click Replicate.

* Select your Data Source and click Next

* Click Finish

* Job with Successful replication will be displayed. Refresh the screen if job is not yet finished.

* We have successfully created a DataSource for our CDS View.

Create Advanced Data Store Object

* GoTo BW Repository Node in the Left side window. Select a Repository and right click on it to create New Data Store Object

* Enter the Details as shown below and Click Finish

* Advanced Data Store Object is created. Click on Active to activate the same.

Create Transformation

* Right Click on Data Store Object and click on create Transformation

* Provide the details of the Data Source in the next window

* Transformation is created with Proposed mapping between Data Source and DSO. Activate the Transformation by clicking on the Activate Icon.

* Transformation is activated Successfully as is shown in Version

Create Data Transfer Process (DTP)

* Right Click on DSO and click on New->Data Transfer Process

* On the next screen details are be filled by default. Click Continue.

* DTP is created. Activate the same.

* DTP must be activated Successfully.

Create Infopackage

* Open TCODE RSA1 in backend system and under the Data Source Node select the Data Source “ZDELTA_ACDOCA” we created.

* Right click on the Data Source and Click Create Infopackage

* Enter the InfoPackage description, select the Data Source and click Save.

* Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab.

* Go to the update tab and select Initialize the delta process

* GoTo Schedule tab and start the extraction

* Monitor the extraction. All the records are fetched and the delta processed is analyzed. This means now with Delta run only delta records should be fetched.

* Now let’s make a change in one the document. Doc Header text is changes as shown below.

* Go to the Update tab in the infopackage and select the Delta radio button

* GoTo Schedule Tab and start the extraction.

* Monitor the Extraction. We can see there are 21 records are extracted.

* GoTo TCODE ODQMON and see the Documents which are changes to verify if the extract is corresponding to the changes we made. As seen in screen shot below all the 21 records are for the documents we changed.

Enabling Real-Time Streaming

* Go to SAP Gui and open TCODE RSPC

* Go to Process chain, right click on the top node and click create Process chain

* Provide the Process chain name and long description

* Click on Create

* Provide Process variant name and description

* Maintain Start process screen will appear. Click on Save.

* Add the DTP and aDSO activation processes from the Left side window to the Process Chain by dragging and dropping to the process chain highlighted below. The connect the Variant to DTP by dragging Variant to DTP

* Click on streaming button.

* Select the ‘Process Chain Runs in Streaming Mode’ check box. Set the Error threshold and Log retention according to requirements. Click OK

* Activate the process chain by clicking on Activate icon

* Process chain is activated successfully and the Events are created for the same as highlighted below

* With this we Real time streaming is enabled for the Data flow and we see a Data extraction job is triggered and waiting for any changes. Now let’s check if data changes are getting reflected at real time.

* Let’s make the changes in same Document header text again and save.

* Check in tcode ODQMON. As we can see these is one Real time extraction request. Double click on the same

* There are 105 rows extracted. Double click on the row.

* We can see the entries for the change we made are there in the extracted records

With this we have completed the Real Time Data Streaming to BW using the CDS view. http://bit.ly/2BRE6JX #SAP #SAPCloud #AI

Since the very first day of our business, we faced the biggest problem of handling our clients and manage them in a systematic format. All our details need to be handled manually that was a time-consuming task. Since a decade, we really invested our precious hours to keep track of our clients and build co-ordination in-between. But with the advancement of technology, we received a big solution to this problem.

There are industries where you always require handling your clients with care and keeping track of all sorts of information associated with your clients. In such a scenario, the search for the best contract manage software starts and internet is surfed to filter the best one for your business.

Today, the market is flooded with multiple selections, but only a few of them are considered to be the most reliable for your business. ContractExperience is one of the booming products that is really a game changer in the way you serve your clients. With this product, it has become really easy and secure to manage the clients on the right platform and serve the best of your services.

But where multiple branded products are already ruling the industry, how the ContractExpereicne stands out of the crowd and build its unique identity for the business owners.

There are many traits that you will receive the use of this contract lifecycle management software.

Centralized Contract Repository: The feature of centralized contract repository is already a common feature in all contract management software. But here you will find highly refined indexing of all the contracts that allows response within seconds and lets you find the information within the fluctuation of seconds. The tool offers you an online mode or local repository system where you can store the information of your clients.

High-level Client Data Security: Security is always the top priority whenever you are working as a big brand. On the similar note, you are also required to maintain the clients’ data at your end without breaching the loopholes. This software lets you maintain the security via multi-factor authentication. With the inclusion of two-step authentication process, it becomes really hard to breach the system and publicize the sensitive information about your contracts and your clients.

Easy Integration and Modification: The software is highly beneficial to track your existing as well as past clients. It allows you to easily manage the user permissions that omit the problem of handling client’s report by different employees of the company. Along with that, it can be easily integrated with other applications that make it an easy to integrate the tool for the businesses. With each contract, you will also be reminded of the contract status on a day to day basis.

Analytics & Reporting Data: It’s important to track the current status of your client’s task and other sorts of information related to your current or past client. In all the cases, you require a reporting and analytics dashboard that brings all the tracking information at one desk. This contract lifecycle management software is blessed with the availability of report logs, analytics data and other sorts of dashboards that will really be helpful to bring the data on a single screen.

Easy to Track ROI: Now all your efforts to serve your clients is based on earning a profit. But how much are you actually earning with the help of your services? This application allows you to track the Return on Investment in accordance with every contract you handle. No extra customization is required to export the ROI information. You can find the entire information associated with the client and the overall revenue you achieved.

So, in future, all the new startups will really find this article helpful as it will update then in advance about the best contract lifestyle management software that will really help them focus on business growth from the very first day. Even if you are already running a business, this content will help you manage your existing clients in a wise and systematic manner. http://bit.ly/2BU1syy #SAP #SAPCloud #AI