Sap BI: Load Transaction Data From Flat File

Load Transaction Data From Flat File:

We will figure out how to stack value-based information from a Flat File with the assistance of a situation.

Situation: Load information to the DSO named "DEMO_DSO". The DSO has the accompanying fields.

Key Fields:

• ZCUST - Customer

• ZMAT – Material

Information Fields:

• ZPRICE – Material Price

• Gives look access to the Steps to Load information to DSO from Flat record

Step 1: Create source framework for level document.

• Go to exchange code RSA1

• Click the OK catch.                     

In the following screen,

• Explore to Modeling tab->Source Systems.

• Right tap on the organizer named FILE and pick "Make" from the setting menu.

In the following screen,

• Enter the Logical System Name.

• Enter the Description.Click Continue Button.

 
Step 2: Create Application segment.

• Go to exchange code RSA1

• Click the OK catch.

• Explore to Modeling tab->Data Sources.

• Pick the Source System.

• Right snap - > Create Application Component.    

• Enter the Technical Name.

• Enter the Description.

• Click Continue.

Step 3: Create Data Source.

• Go to exchange code RSA1

• Click the OK catch.

 

• Explore to Modeling tab->Data Sources.

• Right snap - > Create Data Source.

• Enter Technical Name.

• Pick the DataType DataSource.

• Click Continue.

• Enter the Fields demonstrated as follows. This Structure ought to be the same as the DSO to which exchange information is to be stacked.    

• In the Extraction tab, pick the Adapter as "Burden Text-Type File from Local Workstation".

• Pick the record way where the level document to be stacked is set in the framework and enact information source.

Step 4: Create change between Data Source(Source) and DSO(Target).

• Go to exchange code RSA1.

• Click the OK catch.

• Explore to Modeling tab->InfoProvider.

• Make Transformation.

  

• Enter Target Object Type.

• Enter Target Object Name.

• Enter Source Object Type.

• Enter Source Object Name.

• Enter the Source System.

• Click Continue.

• Beneath screen demonstrates the change made with programmed mapping of the Source fields to the Target fields.

   
Step 5: Create Data Transfer Process.

• Right-Click on DTP envelope and pick the alternative "Make Data Transfer Process" from the setting menu.

  

• Beneath screen demonstrates the DTP made.

   
Step 6: Create Infopackage and Schedule dataload to the DataSource(PSA).      

• Go to exchange code RSA1.

• Click the OK catch.

 

• Explore to Modeling tab->DataSources.

• Right tap on the DataSource - > Create InfoPackage.

   

• Enter the InfoPackage Description.

• Click Save.

   

• Click on Schedule tab.

• Click Start catch to begin the heap from the level record to the Data Source.

  
Step 7: Load information to the DSO.

• Click Execute tab in the DTP.

• Click the Execute Button to begin information load from the DataSource(PSA) to the DSO.

     
Folkstrain offers  a best online training for sap bi in usa, uk and globally with professionals in usa, uk and globally with professionals@ sap bi online training

Sap Hr: Master Data

About Sap Hr: Master Data:

Maintaining the HR Master Data capacity permits you to keep up representative information undertakings like entering the information, overhaul, and so forth.

Information identified with a representative is entered in different Infotypes. For instance, Infotype 0002 contains individual data of a representative like name, date of birth, conjugal status, and so forth. Infotypes are utilized to amass comparative information and makes it less demanding to prepare.

Keeping up HR Master Data capacity permits you to get to a worker's Infotype records separately. Likewise, you can utilize quick section capacity to keep up representative information all the while for numerous workers.

Playing out a Personnel activity in HR framework like enlisting a representative, includes entering colossal information in the framework. You need to enter arrangement of Infotype data identified with a worker.

HR Master Data Structure:

The key segments for HR Master Data in SAP Human Capital Management framework are as per the following:

• Data sort or known as Infotype

• Data subtype or known as Info subtype

• Object Identification to separate between information records

• Information structure components qualities

• Relationship

Processing HR Master Data:

There are numerous capacities, which can be utilized to process HR expert information in framework. These permit you to make or alter the current records in the framework.

Create capacity:

The Create capacity permits you to enter the new Infotype record in the framework. You can make new Infotype record and likewise, hold the old records in the framework. Legitimacy of new record is characterized.

Change capacity:

The Change capacity is utilized to alter a current Infotype without making another Infotype. Utilizing the change work, the past estimation of Infotype is changed and any past worth is not put away.

Delete capacity:

The Delete capacity permits you to erase an Infotype record in the HR framework. When you erase an Infotype record with time requirement 1, it expands the past record consequently.

Copy capacity:

The Copy capacity permits you to make another Infotype record and upgrade history. This capacity does not enter information on another screen but rather requests that enter data on a screen containing the information.

Display capacity:

You can utilize the Display capacity to see an Infotype on the screen. In showcase mode, you can't process or redesign information.

Utilizing the List capacity, you can show an outline of the considerable number of records put away for a predefined Infotype.

Selecting HR Master Data:
To get to a worker information, you should enter the representative's staff number and the Infotype whose information records you need to handle. You can discover work force numbers, regardless of the possibility that you don't have any acquaintance with them precisely, by utilizing the Search Help for Personnel Numbers.

When you seek a worker, you can check the representative Infotype record in the framework. Infotype inquiry can be performed utilizing the accompanying strategies −

• Selecting an Infotype by name or number: You can play out a quest for an Infotype in the event that you know its name or number.

• Selecting an Infotype utilizing useful region: You can likewise seek an Infotype utilizing useful region as SAP HCM framework contains comparative Infotypes aggregate together.

                            1. Individual Data
                        
                            2. Finance Data

• Selecting Infotype utilizing content: You can likewise seek an Infotype by writing content hunt term. Framework shows all the Infotype whose name coordinates the pursuit thing.

• Selecting an Infotype utilizing Personnel record: You can likewise seek an Infotype utilizing a faculty document.

Folkstrain offers a best online training for sap hr in usa, uk and globally with professionals. On your flexible timings with experts@ sap hr online training

Hadoop: Introduction To Apache Storm

Apache Storm:

Apache Storm is an open source motor which can prepare information in realtime utilizing its dispersed engineering. Tempest is basic and adaptable. It can be utilized with any programming dialect of your decision.

We should take a gander at the different parts of a Storm Cluster:

Radiance hub: The expert hub (Similar to JobTracker)

Manager hubs:. Begins/stops laborers and speaks with Nimbus through Zookeeper

ZooKeeper hubs:. Organizes the Storm group

Here are a couple of wordings and ideas you ought to get acquainted with before we go hands-on:

Tuples. A requested rundown of components. For instance, a "4-tuple" may be (7, 1, 3, 7)

Streams. An unbounded arrangement of tuples.

Gushes. Wellsprings of streams in a calculation (e.g. a Twitter API)

Jolts. Process information streams and deliver yield streams. They can:

• Run capacities;

• Channel, total, or join information;

• Converse with databases.

Topologies. The general computation, spoke to outwardly as a system of spouts and jolts

Establishment AND SETUP VERIFICATION:

STEP 1: CHECK STORM SERVICE IS RUNNING

We should check if the sandbox has storm forms up and running by login into Ambari and search for Storm in the administrations recorded:

STEP 2: DOWNLOAD THE STORM TOPOLOGY JAR FILE

Presently we should take a gander at a Streaming use case utilizing Storm's Spouts and Bolts forms. For this we will utilize a basic use case, nonetheless it ought to give you the genuine experience of running and working on Hadoop Streaming information utilizing this topology.

How about we get the jug record which is accessible in the Storm Starter unit. This has different case too, yet we should utilize the WordCount operation and perceive how to turn it ON. We will likewise track this in Storm UI.

STEP 3: CHECK CLASSES AVAILABLE IN JAR

In the Storm illustration Topology, we will utilize three primary parts or procedures:

Sentence Generator Spout

Sentence Split Bolt

WordCount Bolt

You can check the classes accessible in the jug as takes after:

STEP 4: RUN WORD COUNT TOPOLOGY

How about we run the tempest work. It has a Spout occupation to produce irregular sentences while the jolt tallies the distinctive words. There is a part Bolt Process alongside the Wordcount Bolt Class.

How about we run the Storm Jar record.

STEP 5: OPEN STORM UI

How about we utilize Storm UI and take a gander at it graphically:

STEP 6: CLICK ON WORDCOUNT TOPOLOGY

The topology is situated Under Topology Summary. You will see the accompanying:

STEP 7: NAVIGATE TO BOLT SECTION

Click on tally.

STEP 8: NAVIGATE TO EXECUTOR SECTION

Click on any port and you will have the capacity to see the outcomes.

Folkstrain provides a complete in depth training for hadoop in usa, uk and globally with real time experts and professionals@ hadoop online training

Business Analyst Requirement Presentation

A business prerequisite is a formal report that addresses the need of the partners for the undertaking or item. There is no standard configuration to exhibit the business prerequisite. Notwithstanding, it ought to cover the item or task portrayal in enough detail to examine, break down, archive and accept.

A business necessity can be introduced in any of the accompanying ways

• A table or a spreadsheet

• A graph (work process)

• A diagram

• A model ( substance relationship chart)

• A model or reproduction

• An organized sentence or content format

Step by step instructions to sort out and show a business necessity:

Step 1: Categorize the necessities

Place particular necessity to its significant classes

For specialized partners there ought to be specialized prerequisite class, for non-specialized partners there ought to be bland necessity classification

Every association ought to make sense of which classification suits their guidelines

Classification should likewise be possible in light of their sorts (practical versus business). In spite of the fact that this is not pertinent to all cases

Step 2: Gather and mastermind prerequisites in a legitimate request. So when partners survey the prerequisites, it is anything but difficult to explore furthermore recognize missing things.

Step 3: Prepare a rundown of the necessities that is intended to be evaluated by particular partners.

For instance, if a partner is from specialized foundation then he might want to know just the specialized part of the item

Step 4: If following prerequisite to each other is troublesome then utilize one of a kind identifiers, ease in tractability.

Step 5: In specific situations, you may need to present same prerequisite in various routes for various partners. For instance, one partner favors a graphical arrangement while different lean towards an organized sentence design

Step 6: Prepare a chapter by chapter guide for every one of the necessities, it helps partner to effectively track prerequisites

Step 7: Use devices that assistance in displaying and arranging the prerequisites

Step 8: In your prerequisite record, evacuate every single superfluous necessity, and sort out necessity reports by procedure stream

Step 9: Map the prerequisites you have accumulated to a specific stride in a procedure stream, this will help analysts to relate necessity to process stream

Step 10: Use a table for introducing complex necessity. Use visual cues to highlight the key part of prerequisite

Useful Tips For Presenting Requirements:

For better presentation and following of prerequisites for partner, here are a few tips that may be useful to BA.

• Classifying necessity is tedious and may not be achievable for each association to make new classification every time. For best practice, it is prescribed that there ought to be a standard arrangement of classifications which can be normally utilized by BAs, partners, subject specialists and specialized groups

• Your prerequisite ought to be set up in setting to your gathering of people. Comprehend who are the key players, influencers and chiefs. (Partners, specialized staff, designers, and so forth.)

• Characterize one prerequisite at once. Every prerequisite ought to be nuclear

• Maintain a strategic distance from vagueness by staying away from acronyms like and so forth., approx., et cetera

• Try not to allude to a prerequisite that is yet to be characterized

• Maintain a strategic distance from copy and opposing articulations

• Break complex prerequisite into reasonable and reviewable focuses

• Abstain from depicting how the framework will accomplish something just specify what framework will do

Folkstrain offers a best online training for ba in usa, uk and globally with real time experts and professionals on your flexible timings@ ba online training

Overview Of Sap Crm Product Master

 CRM Product Master: 

SAP CRM gives item ace to the administration of items some portion of various business forms in your association

Regarding SAP CRM, Products are merchandise that are the object of your organization's business exercises. Items can be substantial, for example, a PC, or immaterial, for example, administrations like PC support

SAP CRM Product expert can be utilized to keep up and recover all data on the items that your association buys or offers
    

• It works same over all procedures required in the three modules of SAP CRM, i.e., deals, administration and promoting

• The part chose to get to the Product expert inside CRM UI decides the item sorts that can be kept up by current client

• SAP CRM underpins up to six distinct sorts of item        

Taking after are the SAP standard Product Types:

• Material

• Administrations

• Guarantees

• Financing

• IP

Out of these item sorts IP and Financing are industry particular
Case of items:

SAP CRM bolsters synchronization of ERP material expert information with CRM Product expert =

• ERP material expert comprises of different information and perspectives. Some of these perspectives can't be prepared in CRM. As a rule, just General information, Basic information and Sales-particular information can be exchanged to the CRM framework

• Likewise, least changes can be made inside CRM if item information is exchanged from ERP to CRM

SAP CRM gives usefulness to keep up relationship between items. For instance, for an accessible item we can have administration parts, embellishments or administrations, and so forth. These connections can utilized as a part of the Product Proposal usefulness

In Product Proposal, framework peruses the Product information and utilizing certain properties like connections kept up, it proposes different items that can be utilized as a part of the business exchange

Taking after are case of accessible relationship sorts that can be kept up in the CRM framework:

• Segments

• Administrations

• Administration Parts

• Contenders

• Frill

SAP CRM likewise gives usefulness to keep up an item as configurable

For this situation, the item contains variations (can considered as variables) which can hold the quality allocated amid the item arrangement. For instance, for an item "Screen", we can have a variation for "Screen Size" where we can allocate esteem for the measure of screen amid the item arrangement

Modifying settings identified with the item design are kept up in the SPRO settings

The item design application in SAP CRM has a JAVA based front-end. This application is called as Internet Pricing and Configurator. It is additionally required in arranging the evaluating for the items in the SAP CRM framework

SAP CRM gives usefulness to connection this IPC Application with the item ace. Subsequently, for a configurable item, we can call IPC Application from the CRM Web UI

Item Master can likewise be kept up with SAP GUI utilizing taking after exchanges:

• COMMPR01 – Product Master

• COMM_HIERARCHY – To keep up chains of importance and classifications

• COMM_SETTYPE – To maintainSet Types and Attributes

Folkstrain offers a best online training for sap crm in usa, uk and globally with professionals. On your flexible timingsa@ sap crm online training

Sap BI: Characterstics Settings

SAP BI:
SAP BI (Business Intelligence) is a leading data warehousing and reporting tool. It helps convert raw data into information and insights that help improve business margins. This course is geared to make a BI expert

Characteristics Settings – Display Name:
As a matter of course, when a trademark is added to the inquiry, it shows the portrayal indicated in SAP BW. It is conceivable to supplant this with redid content as takes after.

• Click on Properties

• Select the General tab

• Enter Description

Characteristics Settings – Display Properties: 
Select the Display tab of the properties window of the chose trademark.

The "Showcase as" choice is utilized to show either just the Key or just Text or both Key and Text.

In the event that a trademark has 2 or a greater amount of Short/Medium/Long Text populated, "Content View" is utilized to show relating content.

It is conceivable to sort information rising/diving either by the trademark or any of its properties.

The "Outcome Rows" choice is utilized to appear or conceal sub-all out for fundamental trademark.

            

Characteristics Settings – Display Records:
The showcase choice is utilized to characterize what information is seen by client amid information determination (in channels) and after report execution.

• Select the Advanced tab of the properties window of the chose trademark.

• Access Type for Result Values. Pick one of these qualities.

• "Posted qualities" is utilized to demonstrate just records that have a few exchanges connected with them

• "Expert Data" shows all expert information records regardless of whether an exchange exists for them or not. It is insufficient if utilized with zero concealment.

Channel Value Selection. Pick one of these qualities.

• Just Posted Values for Navigation: The framework shows just posted qualities from the current navigational state.

• Just Values in InfoProvider: The framework shows just values contained in the InfoProvider.

• Values in Master Data Table: It is quicker, yet may bring about zero records coordinating choice criteria.

           

Folkstrain offers a best online training for sap bi in usa, uk and globally with real time experts. On your flexible timings with professionals@ sap bi online training

Sp Hr: Creation Of Organizational Structure

Sap Hr:

SAP Human Capital Management (HCM) is additionally called SAP-HR. SAP HCM comprises of imperative sub-modules like Personnel Administration (PA), Organizational Management (OM), Time, Payroll

Organizational Structure:

• It depends on Organizational arrangement.

• Hierarchical arrangement gives establishment of Organizational Management.An association utilizes an authoritative arrangement to speak to connections between individual divisions and workgroups

• The hierarchical arrangement utilizes components called objects like Persons (P), Jobs (C), Positions (S), Organizational Units (O), Cost Center (K) and so on.

There are interfaces show that help one to construct Organizational Structures


Creation Of Organizational Unit:

Step1:

In the SAP summon brief , Enter exchange PPOCE



Step2:
 
In the following SAP screen, enter the begin date of the Organizational Unit and snap the check mark
   


 Step3:

The New Organizational Unit will showed in both the Overview and Detail screen territories
  


Step4:

In the subtle elements segment , enter points of interest as per the Business Blueprint.          



Step5:

Click the Save the Button. The Overview Area will likewise change as takes after

Folkstrain offers a best online training for sap hr in usa and all over the world. On your flexible timings@ sap hr online training