Select Page

SAP BI Online Training in Hyderabad

SAP BI Online Training Hyderabad Ameerpet

Business Intelligence can be referred to as a company data for facilitating the process of decision making. This is highly crucial in every organization using SAP today, and hence the need for the same has increased tremendously. In the current economic scenario, business results like profitability, market share, growth are more important and viewed as the crucial factors of success. Therefore, if you want to get the best results for your business, getting trained on SAP BI  is the wisest thing to do. Enroll for our SAP BI training in Hyderabad Ameerpet, and get the opportunity to learn the subject from the scratch.

Information is one the key tools in making the right business decision. Therefore, it can be referred to as a decision support system These devices are based on the use of intelligence information system. Obtaining the training can not only help in making the right business outcome, but it can even help an individual in framing an excellent career for the future.

What To Expect?

When you join our SAP Business Intelligence training in Hyderabad, you can expect to learn loads of things. Regardless the part of the course you select, you can expect to get some crucial features.

  • All the courses come with significant and live lectures along with demonstrations, topics, and customized settings.
  • Along with theoretical knowledge, you will gain valuable insight into the practical grounds so that implementing the same in the business scenario is not difficult.
  • At the end of training, there will be two sets of exams for preparing you for certification.
  • You will get 24/7 support and access to the instructor
  • Lifetime access to our training materials
  • Mobile friendly interface
  • Free updates
  • Practice with server access
  • Neatly packaged training content
  • Certification preparation materials
  • Interview preparation materials.

We are highly confident that with our dedicated and active learning hours, the exam will be a sure shot success for our students.

Things To Learn:

There are several things you will learn in our SAP BI  training institutes in Hyderabad. Some of the common things that you can expect to learn include:

  • Fundamentals of data warehousing,
  • BW architecture,
  • Introduction to SAP R/3, ECC, and BW,
  • Multidimensional modeling,
  • PSA Source system,
  • Transfer rules,
  • Loading master data using flat files,
  • Process chains,
  • Open hub service,
  • Data marts,
  • Aggregates,
  • Delta management,
  • Loading master data from ECC,
  • SAP landscape and transports
  • Query properties, genetic extractors,
  • Web application design
  • BW and XI integration,
  • BW and APO integration,
  • Mini project and many more to mention.

These are only some of the many things mentioned, and therefore, you can easily get an idea of the valuable insights that you will gain from our course, as a whole.

Duration Of The Course:

The course duration varies based on the schedule you choose. However, it can range anything from 8 hours to 35 hours. We cover some particular topics at a given time. Before following up with our SAP BI  real time training in Hyderabad, you can check out some of the important things in this context.

  • You should monitor the sequence of our course so that you are always on track. As a result, it will enable you to avoid moving randomly.
  • The exercises that we mention in our course should be complete, and this in turn will allow you to be in perfect touch with the course. Our exercising materials are available at the end of a unit. These exercises will be your learning stick as well as the pillar of your success in the time to come.
  • In case you have any difficulty, you can get back to us anytime you want without any hesitation. We will be more than happy to help you.
  • Our course is entirely based on the technological current trend of Business Intelligence. We upgrade our courses from time to time based on the latest technical trends.

Making The Most Of the Future:

Among the several modules of SAP, the question might apparently come to your mind as why BI. Well, in this always changing fast paced world, consumers look forward to connecting like never before. A business relies on IT to survive and grow in the time to come. When you make the right choice, you can get out with satisfactory results. To get opportunities into the best organization or acquire success in your own business, SAP BI /BW training in Hyderabad is the right choice for you. By learning our course, you can adapt to the markets and tap the right opportunities present in front of you. We aim to support you wherever and whenever.

In reality, SAP Business Intelligence involves lots of hard work. The key to success is to concentrate on the topic that is taught, and the willingness to being proactive with research. Well, you can be completely assured that  SAP BI  BO training in Hyderabad will do this work for you in the most flexible approach due to which you will not have any difficulty in the overall learning process. This is also one of the principal reasons for which we have scores of candidates joining us at each training session.

It is time to stay ahead in the competitive market by learning about the technology in demand. Join our training course today, and win a competitive position in the market. We will teach you the entire concept step by step right from the scratch so that you do not have any difficulty in understanding the same.

We would like to help you with both the core and advanced courses based on your current skills and background. Thus, we are sure that you will find something that suits your requirements. Therefore, do not delay any more. Get in touch with us at the earliest and enroll for our course. We are sure that you will be more than satisfied with it.

SAP BI/BW Classroom Notes

SAP (Systems, Applications, Products) having 64 applications.

Two server systems:

1) ECC (ERP Central Component – ABAP) Live System

2) BI (Data Warehousing System) Independent Server

Axon is the world’s best SAP implementing partner

SAP Introduction

SAP was introduced in 1972; place name called Waldorf, Germany.

SAP Data Warehousing Versions:

1998:        1.0 A ] called BIW (Business Information Warehouse)

1.0 B ]

2.0 A ]

2.0 B ]

2.1 C ] called Business Warehouse (BW)

3.0 A ]

3.0 B ]

3.1 C ]

3.5    ]

2006:        7.0    ]

7.1    ] BI Net Weaver (due few defects in 7.1 & 7.2 versions

7.2    ] introducing 7.3 version)

2011:        7.5    ] BI + Data Structures (DS) + Business Objects
We will find icon – VPN (Virtual Provider Network) on client network in the place of <SAP Management Console>

VPN Companies are  CISCO, ATNT, CITRIX etc.
Types of Data

There are two types of data in a standard business practice:

1) Master Data & 2) Transaction Data

Master Data: It is the data which is not going to change frequently and maintains uniqueness (no duplicate).  It represents all real life entities such as customers, vendors, materials, plants, etc. (called as Primary Keys).

Transaction Data: It is the data which is going to change very frequently, allows duplication.  It represents entities such as measures, quantity, amount, etc. (called Foreign Keys) which are a reference to the Master Data.

The goal of SAP-BI: The primary purpose of SAB_BI is to offer complete end to end data warehousing solutions.

To log on SAP, <double click> on SAP Management Console, <right click> on System, <click> on start <enter> Username and Password : (UN – sapuser/ pw – india123)

<double click> on SAP Log On (in real time scenario can access min. 6 systems) due to landscape.

<select> BI Server, <click> on log on (in real time scenario will be created by SAP – Basis/ ABAP team of clients). <enter> Username and Password and <click> enter

Now it will show as follows: SAP EASY ACCESS.

In real time, it will show as SAP EASY ACCESS FOR SATYAM

In BI there are three areas in SAP as follows:

1) Extraction (ECC)

2) Modeling (BI) &

3) Reporting (Bex/BO)

 

Modeling (BI):

Data Warehouse Work Bench (or) Administrator Work Bench.  It is the primary phase of SAP-BI.  It is a technological platform to create, modify and customize all kinds of Meta Data Objects of SAP-BI.

It is a tool for controlling, monitoring and maintaining all of the process connected with data staging and processing in SAP-BI.

Functions of Data Warehouse Work Bench.

There are seven functions:

  • Modeling
  • Administration
  • Transport Connection
  • Documents
  • BI Contents
  • Translation
  • Meta-Data Repository

1) Master Data Loading Manually

Cust A/c. 100 200 300 400 500
Cust Name Mike Mark Shyam Sashi Satyam
Cust. Age 20 30 35 32 37
Cust. Add USA UK INDIA GERMANY INDIA
Cust. Ph. 11111 22222 33333 44444 55555

1) Master Data Loading Manually

 

Navigation (1)

 

Step 1 – Create Info Area

Step 2 – Create Info Object Catalog

Step 3 – Create Info Objects

Step 4 – Maintain Master Data Manually

 

Step 1 – Create Info Area :

 

Info Area is used to organize Info Cubes, Data Store Objects and Info Objects.  Each Info Cube is assigned to an Info Area.  Through an Info Object is assigned to an Info Area as well.  The maximum no. of Characters allowed is 30

 

Step 2 – Create Info Object Catalog :

 

Info Object Catalog organize Info Objects.  The maximum no. of Characters allowed is 30.  There are two types of Info Object Catalogs:

  • Characteristics and
  • Key Figures

 

0       – All standard objects start with (0)

Z & Y         – Global naming standards        

 

<click> on Info Provider under Modeling, <righ click> on Info Area (which is already created) select <create Info Object Catalog>

 

Edit Info Object Catalog

Info Object Catalog – ZIOC_CH_SONYSony Master Data Catalog

(Technical Name)    (Long Description)

Info Area – ZIA_SONYInfo Area for SONY

 

<Enter> Info Object Catalog Technical Name and Description.  Select Info Object Type as – Character <click on create (F5)>

 

Step 3 – Create Info Objects :

 

In BI Characteristics & Key Figures are collectively called Info Objects.  The structure, the information needed to create data targets such as :

  • Info Cubes
  • DSO (Data Store Objects)
  • Info Objects and
  • Reports etc.

There are core basic building blocks of SAP BI.  All the business evaluation objects such as Products, Customers, Vendors, Revenues, Stock, Profits etc.,  are also called Info Objects.

 

The maximum No. of Characters allowed for Technical Name is (9).

 

<click on Info Object> under Modeling, expand Info Area, <right click> on Info Object Catalog, <select> <create Info Object>

 

Create Characteristic

Char – ZCA_SONY (Technical Name)

Long Description – Customer Account Number (description)

_/ <click continue>

<select> data type – NUMC

<enter> the length – (3) and <click> Activate

 

Attribute Object : <click on> Attribute <Tab> <click on create Attribute> (below General Tab)

Create Attribute (Customer Name)

Attribute  – ZCN_SONY (Technical Name)

Create Attribute as Characteristic …

Ref. Char….

Template…..

_/ <click continue>

<select> data type – CHAR

<enter> the length – (5) and <click> Continue

 

05-03-2012 : Navigation (1) (continued)

 

Create Attribute (Customer Age)

Attribute  – ZC_AGE_SONY (Technical Name)

Create Attribute as Characteristic …

Ref. Char….

Template…..

_/ <click continue>

<click on> create attribute enter the Technical Name and <click on> continue and enter.

<select> data type – NUMC

<enter> the length – (2) and <click> Continue

 

Create Attribute (Customer Address)

Attribute  – ZC_ADDR_SONY (Technical Name)

Create Attribute as Characteristic …

Ref. Char….

Template…..

_/ <click continue>

<click on> create attribute enter the Technical Name and <click on> continue and enter.

 

<select> data type – CHAR

<enter> the length – (7) and <click> Continue

 

Create Attribute (Customer Phone)

Attribute  – ZC_PH_SONY (Technical Name)

Create Attribute as Characteristic …

Ref. Char….

Template…..

_/ <click continue>

<click on> create attribute enter the Technical Name and <click on> continue and enter.

 

<select> data type – NUMC

<enter> the length – (5) and <click> Continue and now Activate

 

It will show (3) options as follows :

 

<select>

() Activate dependent info objects

()

()

_/ <click continue>

(screen appears as follows)

Characteristic – ZCA_SONY MAINTAIN MASTER DATA LIST

 


Step 4 – Maintain Master Data Manually :

 

<click on> Maintain Tab (F6), <click on> Execute (F8), <click on create>

 

<click on create> Fill all required columns (given data) <click on save>, <click on Back (F3)> <enter> Customer Account No. <click on> Execute.

 

Flat File : (in real time scenario – end user will create flat file)

 

2) Master Data loading from Flat File (source) to Info Objects (target)

 

Navigation (2)

 

Steps :

 

  • Create Flat File
  • Create Info Area
  • Create Info Objects Catalog
  • Create Info Objects
  • Create Application Component
  • Create Data Source
  • Create Info Package
  • Insert Characteristics as a Data Target
  • Create Transformations

10) Create DTP

 

Step 1 – Create Flat File :

 

SMID SM_NAME SM_AGE SM_ADDR SM_PH
S1 Shekar 35 SR Nagar 11111
S2 Ramu 27 Ramnagar 22222
S3 Vinay 34 Bowenpally 33333
S4 Krishna 33 Somajiguda 44444

<click> on save, select desktop <enter> file name (csv format)

<enter> file name, <select> csv format <click save> SDINFO.CSV

 

Step 2 – Create Info Area :

 

<enter> Transaction Code rsa1. <click enter>

<click> on Info Provider under Modeling <right click> on Info Provider <select> Create Info Area.

 

Create Info Area

Info Area – ZIA_GM (Technical Name)

Long Description – Info Area for GM (Description)

_/ <click continue>

 

 

 

Step 3 – Create Info Object Catalog :

(Info Object Catalog will be only one)

 

<click> on Info Objects under Modeling <right click> on Info Area <select> Create Info Object Catalog.

Create Info Object Catalog

Info Object Catalog– ZIOC_CH_GM (Technical Name)

Long Description – Info Object Char for GM (Description)

_/ <click continue>

 

<select> Info Object Type as CHAR <click> on create and <click> on Activate

 

Step 4 – Create Info Object (Fields) :

 

<right click> on Info Objects Catalog <select> on create Info Object

Create Info Object

Info Object – ZSMID_GM (Technical Name)

Long Description – Info Object for GM (Description)

_/ <click continue>

 

<select> Data Type as CHAR, Length (2) <click> on Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Sales Man Name as follows :

Create Attribute

Enter Sales Man Name – ZSM_NAME (Technical Name)

_/ <click continue>

 

<select> Data Type as CHAR, Length (6) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Sales Man Age as follows :

Create Attribute

Enter Sales Man Age – ZSM_AGE (Technical Name)

_/ <click continue>

 

<select> Data Type as NUMC, Length (2) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Sales Man Phone No. as follows :

 

 

Create Attribute

Enter Sales Man Age – ZSM_PH (Technical Name)

_/ <click continue>

 

<select> Data Type as NUMC, Length (5) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

06-03-2012 : Navigation (2) (continued)

 

Step 5 – Create Application Component :

 

Application Component are used to organize Data Sources.  They are similar to the Info Areas used with Info Cubes.  The maximum No. of Characters allowed for Technical Name is [32].

 

<click on> Data Sources under Modeling <right click> on Data Sources <select> Create Application Component <enter>

Application Component – ZAC_GM (Technical Name)

Description – Application Component for GM (Description)

_/ <click continue>

 

Step 6 – Create Data Source :

 

A Data Source is not only a Structure in which source system fields are logically grouped together, but also an Object that contains ETL related information.

 

We have four types of Data Sources they are :

 

  • Data Source from Transaction Data
  • Data Source from Master Data Attributes
  • Data Source from Master Data Text
  • Data Source from Master Data Hierarchy (only in 7.3 version)

 

If the Source System in ECC, replicating a Data Source from a Source System will create identical Data Source Structures in the BI System.

 

The maximum No. of Characters allowed for a Data Source Technical Name is [32]

 

<right click> on Application Component <select> Create Data Source

Create Data Source

Data Source – ZDS_GM_ATTR (Technical Name)

Source System – ZG_SS

Data Type Data Source – () Master Data Attributes

_/ <click continue>

 

<select> Data Type Source as Master Data Attributes

<enter> Data Source Technical Name

<click on> Continue

<enter> Long Description – Data Source for GM Master Data Attributes

<click on> Extraction Tab

<browse> Name of the File <select> Desktop <select> File <click> Open

 

Header Rows to be ignored [1]

Expand Data Format <select> [csv]

Data Separator [comma (,)]

Escape Sign (Semi Colon (;)]

 

<click on> Proposal Tab <click on> Load Example

<click> on Fields Tab, <click on> Yes

 

Copy Sales Man ID Technical Name <paste on> Info Object Column

Copy Sales Man Technical Name <paste on> Info Object Column.

Copy Sales Man Address Technical Name <paste on> Info Object Column

Copy Sales Man Phone Technical Name <paste on> Info Object Column

 

<click on> <Enter> and <click on> <Copy>

<click on> <Preview> <click on> <Read Preview Data> and

<click on> Activate

 

07-03-2012 :

 

Step 7 – Create Info Package :

 

An Info Package specifies when and how to load from a given source system.  BI generates a [30] digit code starting with ZPAK as an Info Package Technical Name

 

PSA – Persistant Stagging Area :

 

It is a data staging area in BI.  It allows us to check data in a intermediate location before the data are send to its destination.

 

<right click> on Data Source,

<select> to create Info Package,

<enter> Info Package Description,

<click> on Save

<click> on Schedule, <click> on Start

<click> on Monitor (you can view Monitor scale).

<click> on PSA Maintenance,

<click> on continue

 

 

Step 8 – Insert Characteristic as a Data Target :

 

<click> on Info Provider under Modeling <right click> on Info Area

<select> characteristic as Info Provider

<enter> Customer Account No. – Technical Name under Info Object

Column example: (ZCA_SONY)

<click on continue>

 

Step 9 – Create Transformation :

 

<right click> on your SMID_Attribute,

<select> Create Transformation

 

Create Transformation

Target of the Transformation

Object Type – Info Object – Sub Type Object – Attribute

Name – ZSMID_SONY (example)

Source of Transformation

Object Type

_/ <click continue>

 

<select> Source of Transformation as – Data Source

<browse> on Data Source <click on continue>

<click on> Find, <enter> Data Source Technical Name,

<click on> OK, <click on> OK, <click on> Continue, <click on> Activate

 

Step 10 – Create Data Transfer Process (DTP) :

 

<right click> on SMID Attirbute

<select> Create DTP, <click on continue>

 

Creation of Data Transfers

_/ <click continue>

<click on> Activate, <click on> Execute, <click on> Execute,

<click on> YES, <click on> F3, <click on> F3,

<right click on> SMID Info Object, <select> Manage <select> request

<click on> Contents, <click on> Contents <click on> Execute

 

3) Real Time Requirement/ Real Time Scenario:–

 

We have one Info Object Employee for which we have to load the Master Data.  This Info Object contains Employee Information.

 

 

The Master Data is Employee ID and the Attributes are :

 

  • Currency Key
  • Employee Annual Salary
  • Employee Category
  • Employee Date of Birth (DOB)
  • Employee Country
  • Employee Designation
  • Employee Date of Joining (DOJ)

 

This Info Objects contains TEXT where we load Employee Names.

 

Now for loading we have two csv files :

 

  • Contains Master Data Attributes
  • Contains Master Data Text

 

Navigation Steps (3)

 

  • Create Flat File (Client Will provide in real time)
  • Create Info Area
  • Create Info Objects Catalog
  • Create Info Objects
  • Create Application Component
  • Create Data Source
  • Create Info Package
  • Insert Characteristics as a Data Target
  • Create Transformation

10) Create DTP

 

Flat File (in csv Format) :

 

EMP_ID Curr. Key E_Salary E-Cat E_DOB E_Country E-Desgn. E_DOJ
9500000 INR 70000 A 19920125 India Clerk 20100102
9600000 USD 5000 B 19800114 USA Manager 20100103
9700000 GBP 3000 C 19600222 UK Lead 20100104
9800000 EUR 6000 D 19850617 Europe Asst.Mgr. 20100105
9900000 INR 60000 E 19770918 India Pro. Mgr. 20100106

 

Step 2 – Create Info Area : ZIA_TRR_HR

 

<enter> Transaction Code rsa1. <click enter>

<click> on Info Provider under Modeling <right click> on Info Provider <select> Create Info Area.

 

Create Info Area

Info Area – ZIA_TRR_HR (Technical Name)

Long Description – Info Area for TRR (Description)

_/ <click continue>

 

Step 3 – Create Info Object Catalog :

(Info Object Catalog will be only one)

 

<click> on Info Objects under Modeling <right click> on Info Area <select> Create Info Object Catalog.

Create Info Object Catalog

Info Object Catalog– ZIOC_CH_TRR (Technical Name)

Long Description – Info Object Char for TRR (Description)

_/ <click continue>

<select> Info Object Type as CHAR <click> on create and <click> on Activate

 

Step 4 – Create Info Object (Fields) :

 

<right click> on Info Objects Catalog <select> on create Info Object

Create Info Object

Info Object – ZEMPID_TRR (Technical Name)

Long Description – Info Object for TRR (Description)

_/ <click continue>

<select> Data Type as NUMC, Length (5) <click> on Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click on> Attribute Tab in ZEMPID_TRR

<enter> 0CURRENCY under Attribute

 

<select> Data Type as CHAR, Length (2) <click> on Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Employee Salary as follows :

 

Create Attribute

Enter Sales Man Name – ZEMP_SAL (Technical Name)

_/ <click continue>

<select> Data Type as NUMC, Length (6) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab,

<click> on Create Attribute Tab for Employee Category as follows :

Create Attribute

Enter Sales Man Age – ZEMP_CAT (Technical Name)

_/ <click continue>

<select> Data Type as CHAR, Length (1) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Employee Date of Birth as follows :

 

Create Attribute

Enter Sales Man Age – ZEMP_DOB (Technical Name)

_/ <click continue>

<select> Data Type as DATS, Length (8) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Employee COUNTRY as follows :

 

Create Attribute

Enter Sales Man Age – ZEMP_CONT (Technical Name)

_/ <click continue>

 

<select> Data Type as CHAR, Length (6) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Employee Designation as follows :

 

Create Attribute

Enter Sales Man Age – ZEMP_DESG (Technical Name)

_/ <click continue>

 

<select> Data Type as CHAR, Length (7) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

<click> on Attribute Tab, <click> on Create Attribute Tab for Employee Date of Joining as follows :

 

Create Attribute

Enter Sales Man Age – ZEMP_DOJB (Technical Name)

_/ <click continue>

 

<select> Data Type as DATS, Length (8) <click> on continue <click> on create Activate. <click> on Master Data/ Text Tab, <deselect> () short text exist & () with text box.

 

Step 5 – Create Application Component :

 

Application Component are used to organize Data Sources.  They are similar to the Info Areas used with Info Cubes.  The maximum No. of Characters allowed for Technical Name is [32].

<click on> Data Sources under Modeling <right click> on Data Sources <select> Create Application Component <enter>

 

Application Component – ZAC_TRR (Technical Name)

Description – Application Component for TRR (Description)

_/ <click continue>

 

Step 6 – Create Data Source :

 

<right click> on Application Component <select> Create Data Source

 

Create Data Source

Data Source – ZDS_TRR_ATTR (Technical Name)

Source System – SOR_SYS

Data Type Data Source – () Master Data Attributes

_/ <click continue>

 

<select> Data Type Source as Master Data Attributes

<enter> Data Source Technical Name

<click on> Continue

<enter> Long Description – Data Source for GM Master Data Attributes

<click on> Extraction Tab

<browse> Name of the File <select> Desktop <select> File <click> Open

Header Rows to be ignored [1]

Expand Data Format <select> [csv]

Data Separator [comma (,)]

Escape Sign [Semi Colon (;)]

<click on> Proposal Tab <click on> Load Example

<click> on Fields Tab, <click on> Yes

 

Copy Sales Man ID Technical Name <paste on> Info Object Column

Copy Sales Man Technical Name <paste on> Info Object Column.

Copy Sales Man Address Technical Name <paste on> Info Object Column

Copy Sales Man Phone Technical Name <paste on> Info Object Column

<click on> <Enter> and <click on> <Copy>

<click on> <Preview> <click on> <Read Preview Data> and

<click on> Activate

 

Step 7 – Create Info Package :

 

<right click> on Data Source,

<select> to create Info Package,

<enter> Info Package Description,

<click> on Save

<click> on Schedule

<click> on Start

<click> on Monitor (you can view Monitor scale).

<click> on PSA Maintenance,

<click> on continue

<click> on F3

 

Step 8 – Insert Characteristic as a Data Target :

 

<click> on Info Provider under Modeling

<right click> on Info Area

<select> characteristic as Info Provider

<enter> Customer Account No. – Technical Name under Info Object

Column example: (ZCA_TRR)

<click on continue>

 

Step 9 – Create Transformation :

 

<right click> on your EMPID_Attribute,

<select> Create Transformation

Create Transformation

Target of the Transformation

Object Type – Info Object – Sub Type Object – Attribute

Name – ZEMPID_TRR (example)

Source of Transformation

Object Type

_/ <click continue>

<select> Source of Transformation as – Data Source

<browse> on Data Source <click on> Continue

<click on> Find,

<enter> Data Source Technical Name,

<click on> OK, <click on> OK,

<click on> Continue,

<click on> Activate

 

Step 10 – Create Data Transfer Process (DTP) :

 

<right click> on EMPID Attirbute

<select> Create DTP, <click on continue>

Creation of Data Transfers

_/ <click continue>

<click on> Activate,

<click on> Execute, <click on> Execute,

<click on> YES,

<click on> F3, <click on> F3,

<right click on> SMID Info Object,

<select> Manage <select> request

<click on> Contents, <click on> Contents <click on> Execute

 


09-03-2012

 

Employee Name want to display as Text Data

 

  • By default in Real-time Scenario EMP NAME / COMPANY NAME to be a Text Data (Textual Description of an Entity)

 

4) Master Data Text Loading From Flat File to Info Object :

 

Navigation Steps (4)

 

  • Create Flat File (Client Will provide in real time)
  • Create Info Area
  • Create Info Objects Catalog
  • Create Info Objects
  • Create Application Component
  • Create Data Source
  • Create Info Package
  • Insert Characteristics as a Data Target
  • Create Transformation

10) Create DTP

 

Step 1 – Create Flat File :

 

EMP_ID EMP_NAME
2054360 MIKE
2054361 MARK
2054362 PETER
2054363 JOHN
2054364 SRIKAR
2054365 VAMSI

 

Step 2 – Create Info Area :

          (Already available not required to create onceagain)

 

Step 3 – Create Info Object Catalog :

          (Already available not required to create onceagain)

 

Step 4 – Create Info Objects :

EMP_ID already exists (not required)

Basically SAP is in three languages

(1) English (2) French (3) Germany

[_/] Text Language Dependent

[ ] Language Key – Mandatory for Text Data

By default opens English Language only


 

0TXTSH     – Represents Short Text Exist Object

0TXTMD    – Represents Medium Text Object

0TXTLG     – Long Text Object

OLANGU   – Text Language Dependent

By default Medium Text will be selected in real time scenario.

 

Step 5 – Create Application Component : (not required)

 

Step 6 – Create Data Source :

 

<click> on Data Sources under Modeling

<right click> on Application Component

<select> Create Data Source

<enter> the Data Source Technical Name

<select> ZDS_MD_TXT as Data Source

Data Type Data Source as – Master Data Text

<click> on Continue

Enter Data Source Description – DS for Text

<click> on Extraction

<browse> Name of the File (example: TEXT FILE.CSV) select File

<enter> Header Row to be ignored [1]

Data Format [csv]

Enter Data Separator [,] coma

Escape Sign [;] semi colon

<click> on Proposal tab

<click> on Load Example Data

<click> on Fields Tab

<click> on [Yes]

<enter<  Text – OTXTSH

<click> on Preview

<click> on Read Preview Data

<click> on Activate

 

Step 7 – Create Info Package :

It is independent for every Object Data Source

 

<right click> on Data Source,

<select> to create Info Package,

<enter> Info Package Description,

<click> on Save

<click> on Schedule

<click> on Start

<click> on Monitor (you can view Monitor scale).

<click> on PSA Maintenance,

<click> on continue

<click> on F3


 

Step 8 – Insert Characteristic as a Data Target :

(Not Required – if deselected then only required)

 

Step 9 – Create Transformation :

 

<right click> on your EMPID_Attribute,

<select> Create Transformation

 

Create Transformation

Target of the Transformation

Object Type – Info Object – Sub Type Object – Text

Name – ZEMPID_TRR (example)

Source of Transformation

Object Type

_/ <click continue>

<select> Source of Transformation as – Data Source

<browse> on Data Source <click on> Continue

<click on> Find,

<enter> Data Source Technical Name,

<click on> OK, <click on> OK,

<click on> Continue,

<click on> Activate

 

Step 10 – Create Data Transfer Process (DTP) :

 

<right click> on EMPID Text

<select> Create DTP, <click on continue>

 

Creation of Data Transfers

_/ <click continue>

 

<click on> Activate,

<click on> Execute, <click on> Execute,

<click on> YES,

<click on> F3, <click on> F3,

<right click on> SMID Info Object,

<select> Manage <select> request

<click on> Contents, <click on> Contents <click on> Execute


 

10-03-2012

 

Master Data Types : There are three types of Master Data in BI

  • Attribute
  • Texts
  • Hierarchy

 

1) Attributes :

 

Attributes are Info Objects that are logically subordinate to a Characteristics and cannot be selected in the query.

 

Types of Attributes :

  1. Display Attributes
  2. Navigational Attributes
  3. Componing Attributes
  4. Time Dependent Attributes
  5. Time Independent Attributes
  6. Transitive Attributes

 

  1. a) Display and Navigational Attributes :

Characteristics Attributes can be converted into Navigational Attributes, they can be selected in the query in exactly with the same way as the Characteristics from an Info Cube.

 

In this case a new edge dimension is added to the Info Cube.

 

During the data selection for the query the Manager connects the Info Provider and the Master Data Table (join).  In order to fill the query :

Example : Costs of Cost Centre drill down to Person Responsible.

 

You use the Attribute Cost Centre Manager for the Characteristic is Cost Centre.

 

If you want to Navigate in the query using the Cost Centre Manager, we have to create Attribute – Cost Centre Manager as Navigation Attribute and flag it as a Navigational Characteristic in the Info Provider.

 

Note: Cost Centre  (Info Object) – Characteristic (Financial Term in real time scenario)

Example :  a) Salary

  1. b) Travel Expenses
  2. c) Shift Allowances
  3. d) A/C Erection
  4. e) Party Expenses

Person Responsible – Dependent Attribute

 

When executing the query there is no difference between Navigation Attributes and Characteristic for an Info Cube.

 

All Navigation functions in the OLAP Processor are also possible for Navigation Attributes Master Data.

Example: (For Display & Navigation Attributes)

 

5) Loading From Flat File to Info Objects

 

Navigation Steps (5) :

 

  • Create Flat File
  • Create Info Area
  • Create Info Objects Catalog
  • Create Info Objects
  • Create Application Component
  • Create Data Source
  • Create Info Package
  • Insert Characteristics as a Data Target
  • Create Transformation

10) Create DTP

 

Step 1 – Create Flat File :

 

EMP_ID Curr. Key E_Salary E-Cat E_DOB E_Country E-Desgn. E_DOJ Joining Time
NAV ATTR DISP ATTR DISP ATTR NAV ATTR DISP ATTR DISP ATTR NAV ATTR NAV

ATTR

NAV ATTR
9500000 INR 70000 A 19920125 India Clerk 20100102
9600000 USD 5000 B 19800114 USA Manager 20100103
9700000 GBP 3000 C 19600222 UK Lead 20100104
9800000 EUR 6000 D 19850617 Europe Asst.Mgr. 20100105
9900000 INR 60000 E 19770918 India Pro. Mgr. 20100106

 

CURRENCY (Display Attribute) :

<click> on Attribute Tab

<enter> 0CURRENCY

 

SALARY (Display Attribute) :

<click> on Create Attribute Tab

<select> Create Attribute as Key Figure

<enter> Salary Technical Name ZSAL

<click> on Continue

<enter> Salary Description

<select> Data Type – Amount

<enter> Unit/Currency – OCURRENCY

<click> on Continue

 


CATEGORY (Navigational Attribute) :

<click> on Create Attribute Tab

<enter> Category Technical Name – ZEMP_CAT

<select> Data Type – CHAR

<select> Length [1]

<deselect> Attribute on Check Box

<click> on Continue

 

DATE of BIRTH (Display Attribute) :

<click> on Create Attribute Tab

<enter> Date of Birth Technical Name – ZEMP_DOB

<select> Data Type – DATS

<select> Length [1]

<select> Attribute only [_/] Check Box

<click> on Continue

 

COUNTRY (Display Attribute) :

<click> on Create Attribute Tab

<enter> Country Technical Name – ZEMP_CONT

<select> Data Type – CHAR

<select> Length [8]

<select> Attribute only [_/] Check Box

<click> on Continue

 

DESIGNATION (Navigational Attribute) :

<click> on Create Attribute Tab

<enter> Designation Technical Name – ZEMP_DESG

<select> Data Type – CHAR

<select> Length [7]

<deselect> Attribute only Check Box

<click> on Continue

 

DATE OF JOINING (Navigational Attribute) :

<click> on Create Attribute Tab

<enter> Date of Joining Technical Name – ZEMP_DOJ

<select> Data Type – DATS

<select> Length [8]

<deselect> Attribute only Check Box

<click> on Continue

 

JOINING TIME (Navigational Attribute) :

<click> on Create Attribute Tab

<enter> Joining Time Technical Name – ZEMP_JOT

<select> Data Type – TIMS

<select> Length []

<deselect> Attribute only Check Box

<click> on Continue

Note: System by default take Info Object followed by Attributes as

ZEMPID_TRR_ZEMP_JOT

 

 

<click> on Navigation [ON/ OFF] Spindle icon for Joining Time

<select> Texts of Character (TE)

– do – the same for Employee Date of Joining

– do – the same for Employee Designation

– do – the same for Employee Category

<click> on Activate

<click> on Continue, Continue, YES

 

 Step 5 – Create Application Component :

 

Application Component are used to organize Data Sources.  They are similar to the Info Areas used with Info Cubes.  The maximum No. of Characters allowed for Technical Name is [32].

 

<click on> Data Sources under Modeling <right click> on Data Sources <select> Create Application Component <enter>

Application Component – ZAC_TRR (Technical Name)

Description – Application Component for TRR (Description)

_/ <click continue>

 

Step 6 – Create Data Source :

 

<click> on Data Sources under Modeling

<right click> on Application Component

<select> Create Data Source

<enter> the Data Source Technical Name

<select> ZDS_MD_TXT as Data Source

Data Type Data Source as – Master Data Text

<click> on Continue

Enter Data Source Description – DS for Text

<click> on Extraction

<browse> Name of the File (example: TEXT FILE.CSV) select File

<enter> Header Row to be ignored [1]

Data Format [csv]

Enter Data Separator [,] coma

Escape Sign [;] semi colon

<click> on Proposal tab

<click> on Load Example Data

<click> on Fields Tab

<click> on [Yes]

<enter<  Text – OTXTSH

<click> on Preview

<click> on Read Preview Data

<click> on Activate

 


Step 7 – Create Info Package :

It is independent for every Object Data Source

 

<right click> on Data Source,

<select> to create Info Package,

<enter> Info Package Description,

<click> on Save

<click> on Schedule (Maintain Info Package)

<click> on Start

<click> on Monitor (you can view Monitor scale).

<click> on PSA Maintenance,

<click> on continue

<click> on F3

 

  • Data Selection (only selected data will load)
  • Extraction
  • Processing (only one processing in BI i.e., PSA)

In BW (4) Options are in enable mode

Synchronous PSA (at Transactional Data level)

 

Update Data                                               [_/] Parallelism

 

() PSA and then in the Info Object (Package by Package)

() PSA and Info Object in Parallel (Package by Package)

() Only PSA []* Update subsequently in Data Targets

() Only Info Objects

* Only BI 7.0 version–After Executing DTP Data will go to Info Object

 

Step 8 – Insert Characteristic as a Data Target :

 

<click> on Info Provider under Modeling

<right click> on Info Area

<select> characteristic as Info Provider

<enter> Customer Account No. – Technical Name under Info Object

Column example: (ZCA_TRR)

<click on continue>

 

Step 9 – Create Transformation :

 

<right click> on your EMPID_Attribute,

<select> Create Transformation

Create Transformation

Target of the Transformation

Object Type – Info Object – Sub Type Object – Attribute

Name – ZEMPID_TRR (example)

Source of Transformation

Object Type

_/ <click continue>

 

<select> Source of Transformation as – Data Source

<browse> on Data Source <click on> Continue

<click on> Find,

<enter> Data Source Technical Name,

<click on> OK, <click on> OK,

<click on> Continue,

<click on> Activate

 

Step 10 – Create Data Transfer Process (DTP) :

 

<right click> on EMPID Attirbute

<select> Create DTP, <click on continue>

 

Creation of Data Transfers

 

_/ <click continue>

 

<click on> Activate,

<click on> Execute, <click on> Execute,

<click on> YES,

<click on> F3, <click on> F3,

<right click on> SMID Info Object,

<select> Manage <select> request

<click on> Contents, <click on> Contents <click on> Execute

 

Get in Touch

+91 9989 1344 70

info@rcptec.com

Register Now






Drop your mail and Get Free e-books,
Free Videos, Certification Info, Session Updates and Lot More
If we Can't Convince you, no one can!