SAP HANA By Rahul Bindroo Session 1

SAP HANA for SAP BI 7.3

Hi ,


Welcome to this video blog edition of HANA by Rahul Bindroo.
I have tried to put the basic concept in place without making it too technical to understand the appliance .


Thank you once again for visiting this blog.

Regards
Rahul Bindroo
rahulbindru@gmail.com

Day 4: Basic settings for BI sever before starting Developements

Hi ,

This is Rahul Bindroo

SAP Netweaver Certified Professional 

and Certified Project Management Professional. 

rahulbindru@gmail.com

I welcome you to 4 day of this training

We have discussed about following points last time, let us take them one by one:-

1. Is our BI System is connected to Source system?
2. Are global settings completed?
3. Are exchange rates transferred?
4. Are permitted characters added?
5. Is material number format added?
6. Is wait time for monitor set?
7. Is source system id assigned to source system?
8. Is conversion of logical system for transports completed?
9. Is report setting done?
10. Are new webtemplates attached and are workbook templated designed?
11. Are webservices configured and activated?

TOPIC 1:-Is our BI System is connected to Source system?

Please check what all are you source systems out following points last time, let us take them one by one:- YOu may be connecting to SAP ECC system , flat file or third party. We have different options of connecting to these source systems based on the available connectors . Let us consider SAP ECC first.

This activity is majory done by basis consultant but it may be required that you may also have to do this in some implementations.

a: ECC

You need to do following:-

1. Create logical systems and assign them to Clients with whom you want to connect
2. Create a user id for with the correct roles in ECC and BI system
3. Create a RFC connection
4. Set user id as a communication user id in BW.

B: FILE

Incase you want file its very simple just add word FILE in logical system name in BW while creating a source system in tcode RSA1--->Source systems

C) Third party

Say you want to connect to SQL or ORACLE  based database you can do it easily using DB and UDI connet. I will discussion these in more detail in next sessions.

TOPIC 2:-Are global settings completed?

you may need currencies,unit of measurement,fiscal year variants and factory calender details from your source system for that you need to load data from the source system tables and need to update that to BI Tables. This can be done by

IN BW-RSA1-Source system-->Rtclick newly created source system name-->transfer global settings

TOPIC 3:Are exchange rates transferred?

Say you are in system where you need to report in multiple currencies and you know for that you need to convert data using the exchange rate. In case you have tables updated in BI with this data this can be handled directly in reports or while data load. Now the question is how to  bring this data to these SAP BI tables.

IN BW-RSA1-Source system-->Rtclick newly created source system name-->Transfer exchange rate

TOPIC 4:Are permitted characters added?

Now once we start loaded the data we get a very big problem that is the source data is having few special characters like '#,@,%,!) etc and while loading we get a error. What to do..Guys we just need to check if special characters are added in system to be allowed.

Now how can we do this:-

There are various ways to handle this think but at this moment lets keep simple thing with us

In BW-tcode RSKC -- add ' !"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' 

TOPIC 5 :Is material number format added?


You may get a error setting for material conversion not found if you dont go for this setting.
Remember go to source system first and check the Material number length and end then add same length for material in BI system.


You can go through SPRO or OMSL transaction code.


First in ECC Source System :tcode OMSL -- CHECK Material No. Lenght, for example  if we see 14 there  then
Go to BW - TCODE-OMSL-ENTER same length (say in our example 14) and click save button.

Day 3: Basic Settings

Hi ,

For any question contact  Rahul Bindroo ,SAP Netweaver Certified Professional , Certified Project Management Professional at rahulbindru@gmail.com




Hey welcome guys..! Now lets now connect to our new system and check the following

1. Is our BI System is connected to Source system?
2. Are global settings completed?
3. Are exchange rates transferred?
4. Are permitted characters added?
5. Is material number format added?
6. Is wait time for monitor set?
7. Is source system id assigned to source system?
8. Is conversion of logical system for transports completed?
9. Is report setting done?
10. Are new webtemplates attached and are workbook templated designed?
11. Are webservices configured and activated?

In my next day block i will try to take them one by one...

Till then good night ...

Day 2 :SAP SD Module For BI

For any question contact  Rahul Bindroo ,SAP Netweaver Certified Professional , Certified Project Management Professional at rahulbindru@gmail.com

I welcome you to my blog....




We need to have some basic understand of the modules before we start the implementation for the module. Let me try to give you some basic overview of Sales module of SAP ECC which will help you to gather requirements. First thing remember for every module do understand the business flow . this is important. Guys Please note....!

I have given above a small picture to help you understand the module.

A small Example: Let us say you our www.globalbsc.com which manufactures Laptop bags.
You get orders from companies and you deliver the same in those schools. Now lets see where sales process starts. There is xyz company which calls you and says that they have requirement for 300 bags. Now how this sales process begins:-

1. They ask you to send a document which will carry prices for the bags and discounts and mail the same. This document is initially produce by us( www.globalbsc.com) and shared with the xyz company. THIS IS CALLED QUOTATION.
2. This quotation is received by xyz company and approved by their Purchasing team . They send you a order to buy the 300 bags . This document is called Purchase order
3. This purchase order will become a base for you to process sales. You book a entry in your ERP system or other system to keep a track this is called 'Sales Order'. 
4. Once this process is completed you start a Selecting bags and packing them this is a sales process called as PICKING.
5. Once this is completed you pack the bags and send them to the xyz company. you will also create a entry in system updating that bags are sent. There is a document which is sent to xyz company which will carry the information what is sent .This is a document which may be called as BILLING DOCUMENT.(say we call this as Invoice ). This process in SD Is called BILLING.
6. Now in system you should also track what money you need to receive from xyz company. This is a process which gets connected to finance and is called ACCOUNTS RECEIVABLE..

Broadly if you observe sales and distribution is comprised of 4 basic process steps:-

1. Sales- Involes quotation (ABOVE 1-3)
2. Shipping-Picking
3. Billing-step 5 
4. FIAR-6

I would suggest if you still want to read more then do find my new blogs but at this moment i will say this is sufficient as a beginner.

So lets meet in our next class for understand the basic settings we have to make in ECC and SAP BI system

You can post your questions directly to me at

rahulbindru@gmail.com