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.