bi retail connectivity

8/12/2019 BI Retail Connectivity

http://slidepdf.com/reader/full/bi-retail-connectivity 1/15

EHP5 for SAP ERP6.0

June 2011English

BI Retail: Connectivity(761)

SAP AGDietmar-Ho -Allee 166!1!0 "all#orf

$uil#ing $lo%& 'onfiguration Gui#e



German(



SAP Best Practices $) Retail* 'onne%ti+it( , 61 * 'onfiguration Gui#e

Copyright

/ 2011 SAP AG. All rights reser+e#. o art of this u li%ation ma( e re ro#u%e# or transmitte# in an( formor for an( ur ose ithout the e3 ress ermission of SAP AG. 4he information %ontaine# herein ma( e%hange# ithout rior noti%e. Some soft are ro#u%ts mar&ete# ( SAP AG an# its #istri utors %ontain

ro rietar( soft are %om onents of other soft are +en#ors.

i%rosoft "in#o s E3%el 7utloo& an# Po erPoint are registere# tra#emar&s of i%rosoft 'or oration.

)$ D$2 D$2 8ni+ersal Data ase S(stem i S(stem i5 S(stem S(stem 5 S(stem 3 S(stem 9S(stem 910 S(stem 9! 910 9! iSeries Series 3Series 9Series eSer+er 9:; 9:7S i5:7S S:<!07S:<!0 7S:=00 AS:=00 S:<!0 Parallel Enter rise Ser+er Po er; Po er Ar%hite%ture P7"ER6>P7"ER6 P7"ER5> P7"ER5 P7"ER 7 enPo er Po erP' $at%hPi es $la#e'enter S(stemStorage GP?S HA' P RE4A) D$2 'onne%t RA'? Re# oo&s 7S:2 Parallel S(s le3 ;S:ESA A)@)ntelligent iner "e S here etfinit( 4i+oli an# )nformi3 are tra#emar&s or registere# tra#emar&s of )$'or oration.

inu3 is the registere# tra#emar& of inus 4or+al#s in the 8.S. an# other %ountries.

A#o e the A#o e logo A%ro at PostS%ri t an# Rea#er are either tra#emar&s or registere# tra#emar&s of A#o e S(stems )n%or orate# in the 8nite# States an#:or other %ountries.

7ra%le is a registere# tra#emar& of 7ra%le 'or oration.

8 )@ @:7 en 7S?:1 an# otif are registere# tra#emar&s of the 7 en Grou .

'itri3 )'A Program eigh orhoo# eta?rame "in?rame ;i#eo?rame an# ulti"in are tra#emar&s orregistere# tra#emar&s of 'itri3 S(stems )n%.

H4 @ @H4 an# "<' are tra#emar&s or registere# tra#emar&s of "<' B "orl# "i#e "e'onsortium assa%husetts )nstitute of 4e%hnolog(.

Ja+a is a registere# tra#emar& of Sun i%ros(stems )n%.

Ja+aS%ri t is a registere# tra#emar& of Sun i%ros(stems )n%. use# un#er li%ense for te%hnolog( in+ente#an# im lemente# ( ets%a e.

SAP R:< SAP et"ea+er Duet PartnerE#ge $(Design SAP $usiness7 Ce%ts E3 lorer Stream"or& an#other SAP ro#u%ts an# ser+i%es mentione# herein as ell as their res e%ti+e logos are tra#emar&s orregistere# tra#emar&s of SAP AG in German( an# other %ountries.

$usiness 7 Ce%ts an# the $usiness 7 Ce%ts logo $usiness7 Ce%ts 'r(stal Re orts 'r(stal De%isions "e)ntelligen%e @%elsius an# other $usiness 7 Ce%ts ro#u%ts an# ser+i%es mentione# herein as ell as theirres e%ti+e logos are tra#emar&s or registere# tra#emar&s of $usiness 7 Ce%ts Soft are t#. $usiness7 Ce%ts is an SAP %om an(.

S( ase an# A#a ti+e Ser+er iAn( here S( ase <65 S An( here an# other S( ase ro#u%ts an#ser+i%es mentione# herein as ell as their res e%ti+e logos are tra#emar&s or registere# tra#emar&s of

S( ase )n%. S( ase is an SAP %om an(.

All other ro#u%t an# ser+i%e names mentione# are the tra#emar&s of their res e%ti+e %om anies. Data%ontaine# in this #o%ument ser+es informational ur oses onl(. ational ro#u%t s e%ifi%ations ma( +ar(.

4hese materials are su Ce%t to %hange ithout noti%e. 4hese materials are ro+i#e# ( SAP AG an# itsaffiliate# %om anies , SAP Grou for informational ur oses onl( ithout re resentation or arrant( ofan( &in# an# SAP Grou shall not e lia le for errors or omissions ith res e%t to the materials. 4he onl(

arranties for SAP Grou ro#u%ts an# ser+i%es are those that are set forth in the e3 ress arrant(

/ SAP AGPage < of 15




statements a%%om an(ing su%h ro#u%ts an# ser+i%es if an(. othing herein shoul# e %onstrue# as%onstituting an a##itional arrant(.

Icons

Icon Meaning

'aution

E3am le

ote or 4i

Re%ommen#ation

S(nta3

Typographic Conventions

Type Style Description

Example text "or#s or %hara%ters that a ear on the s%reen. 4hese in%lu#e fiel#names s%reen titles ush$uttons as ell as menu names aths an#

o tions.'ross-referen%es to other #o%umentation.

Example text Em hasi9e# or#s or hrases in o#( te3t titles of gra hi%s an# ta les.

E@A P E 4E@4 ames of elements in the s(stem. 4hese in%lu#e re ort namesrogram names transa%tion %o#es ta le names an# in#i+i#ual &e(or#s of a rogramming language hen surroun#e# ( o#( te3t for

e3am le SE E'4 an# ) ' 8DE.

Example text S%reen out ut. 4his in%lu#es file an# #ire%tor( names an# their athsmessages sour%e %o#e names of +aria les an# arameters as ell asnames of installation u gra#e an# #ata ase tools.

EXAMPLE TEXT Fe(s on the &e( oar# for e3am le fun%tion &e(s ,su%h as F2 or theENTER &e(.

Example text E3a%t user entr(. 4hese are or#s or %hara%ters that (ou enter in thes(stem e3a%tl( as the( a ear in the #o%umentation.

<Example text> ;aria le user entr(. Pointe# ra%&ets in#i%ate that (ou re la%e theseor#s an# %hara%ters ith a ro riate entries.

/ SAP AGPage = of 15




Contents

'onne%t $) an# Retail S(stems* 'onfiguration Gui#e......................................................... ........... 5

1 Pur ose................................................................................................................................... 52 Pre aration..............................................................................................................................5

2.1 SAP otes.....................................................................................................................5

< 'onne%ti+it(.............................................................................................................................6

<.1 o%al Settings................................................................................................................ 6

<.1.1 Define 'lient A#ministration SAP E'':SAP $)......................................................6

<.1.2 Define ogi%al S(stems SAP E'':SAP $).............................................................6

<.1.< Assign ogi%al S(stem to 'lient SAP E'':SAP $)................................................

<.1.= 'reate R?' 8ser SAP E'':SAP $).......................................................................

<.1.5 'reate R?' Destinations SAP E'':SAP $)...........................................................!<.1.6 A%ti+ate 4e%hni%al 'ontent SAP $)......................................................................10

<.1. Define R?'8SER as Default SAP $)...................................................................11

<.1. aintain ro osal for users in the Sour%e s(stem,A E %ommuni%ation .................12

<.2 'ross 'onne%ti+it(.......................................................................................................12

<.2.1 'onne%t SAP $) ith SAP E'' SAP $)...............................................................12

<.2.2 'onne%t ?ile S(stem in SAP $) SAP $)................................................................1<

/ SAP AG of 15




Connect BI and Retail Syste s: Con!ig"ration

#"ide

1 $"rpose4his %onfiguration gui#e ro+i#es the information (ou nee# to set u the %onfiguration of this

uil#ing lo%& manuall(.

4he %onfiguration gui#e %ontains a lot of #e en#en%ies et een the #ifferent se%tions. So it is+er( im ortant that (ou go ste ( ste through the %onfiguration gui#e. 7ther ise a %orre%tinstallation of the $) S(stem is not guarantee#.

% $reparation$efore (ou start installing this uil#ing lo%& (ou must install rereIuisite uil#ing lo%&s. ?ormore information see the uil#ing lo%& rereIuisite matri3 lo%ate# on the Do%umentation D;Don the Content Library age un#er Technical Information ( on the left na+igation ane .

%&1 S'$ otes4he follo ing notes are im ortant for this %onfiguration gui#e.

otes Description

101!055 Runtime errors hen a%ti+ating )nfo7 Ce%ts

102562! A#Custment to the RS $'4 ' READ 'D4 fun%tion mo#ule10<2=61 4he D@ arser #oes not start

10<66<6 )n#e3 of 0R4 4D 7'AS is rea# in%orre%tl( for AP

10=0 02 4erminations o%%ur hen a%ti+ating te%hni%al 'ontent

106!60 SAP $est Pra%ti%es for Retail DE ;1.600 $) a(outs

106 2 = RS'R * 7ffset in left si#e not a%%e te# for

10!55 Error ( release of 74$ u#get

10 <2 5 Error in the slo seller an(al(sis

7nl( the SAP notes 101!055 102562! 10<2=61 an# 10=0 02 %an e installe# at the eginningof the installation. 4he installation of the other notes is #es%ri e# in the %orres on#ing %ha ters.

Sa ote 10=0 02 installs the re ort ZZRS_TECH_CONTENT_ACTI ATE . "hen e3e%uting there ort (ou ha+e to enter as a%&age RS_TCO_TT .

/ SAP AG of 15




Connectivity

&1 *ocal Settings4his %ha ter #es%ri es all lo%al settings that are ne%essar( for ea%h %om onent li&e SAP E''an# SAP $).

Please erform the follo ing ste s in all rele+ant s(stems.

&1&1 De!ine Client 'd inistration + S'$ ,CC-S'$BI

.se4his a%ti+it( allo s (ou to %hange 'ustomi9ing settings. Kou ha+e to maintain this ste in SAPE'' an# SAP $).

$roced"re1. A%%ess the a%ti+it( using one of the follo ing na+igation o tions*

Transaction Code SCC4

S'$ BI Men" Tool! A"mini!tration Client A"mini!tration Client#aintenance

2. 7n the $i!play ie% &Client!&'O er ie% s%reen #o the follo ing*

a. ?ollo the menu ath $i!play → Chan)e .

. 'onfirm the arning message Ca*tion' The table i! cro!! client .%. Sele%t (our %lient.

#. 'hoose $etail! .

e. 'hange City to (our %it( ,e.g Palo Alto .

f. 'hange St" c*rrency to (our %urren%( ,for e3am le 8SD .

g. Automati% re%or#ing of %hanges

h. 'hanges to Re ositor( an# %ross-%lient 'ustomi9ing allo e#

i. e'A44 an# 'A44 allo e#.

<. 'hose Sa e .

=. Go a%& to the SAP Ea!y Acce!! menu.

&1&% De!ine *ogical Syste s + S'$ ,CC-S'$ BI

.se4he ur ose of this a%ti+it( is to %reate a logi%al s(stem for (our s(stems. 4o ena le%ommuni%ation et een s(stems ithin (our s(stem lan#s%a e (ou must

1. Define the s(stems as logi%al s(stems.

/ SAP AGPage of 15




2. Assign the logi%al s(stem to (our %lient.

4his ena les the s(stems to re%ogni9e the target s(stem as an R?' #estination. )f the logi%als(stem has alrea#( een %reate# s&i this a%ti+it(.

Kou ha+e to maintain this ste in SAP E'' an# SAP $).

ogi%al s(stems are #efine# %ross-%lient.


S'$ IM# Men" SA+ Net,ea er → Application Ser er I$oc Interface - Application Lin. Enablin) (ALE/ → 0a!ic Settin)! → Lo)ical !y!tem! → $efine Lo)ical Sy!tem

2. 'onfirm the arning message* Ca*tion' The table i! cro!! client .

<. 'hoose Ne% entrie! .

=. )n the Lo) Sy!tem %olumn enter a name for the logi%al s(stem that (ou ant to %reate.

5. )n the Name %olumn enter a #es%ri tion of the logi%al s(stem.

*og& Syste a e

L ogi%al s(stemM for e3am le RT/C* T011 Kour S(stem

4o #esignate logi%al s(stems a l( the naming %on+entionL M' 4L M

here is the s(stem name

an# is the %lient.

6. Sa+e (our entries.A trans ort reIuest for ,or.bench a ears.

. Sele%t an e3isting reIuest or %reate a ne reIuest if ne%essar(. A trans ort reIuest forC*!tomi1in) a ears.

. Sele%t an e3isting reIuest or %reate a ne reIuest if ne%essar(.

&1& 'ssign *ogical Syste to Client + S'$,CC-S'$ BI

.se

/ SAP AGPage of 15




4he ur ose of this a%ti+it( is to ma&e an assignment for the logi%al s(stem. S&i this a%ti+it( if alogi%al s(stem is alrea#( assigne# to (our %lient.

Kou ha+e to maintain :%he%& this ste in SAP $) an# SAP E''.


Transaction Code SCC4

S'$ IM# Men" Tool! A"mini!tration A"mini!tration Client A"mini!tration Client #aintenance

2. ?ollo the menu ath $i!play → Chan)e .

<. 'onfirm the arning message* The table i! cro!! client .

=. Sele%t (our ECC client .

5. 'hoose $etail! .

6. Enter the name of the logi%al s(stem of (our %lient.

. Sa+e an# %onfirm the arning message 0e caref*l %hen chan)in) the lo)ical !y!tem .

. 'hoose 0ac. t i%e.

&1&2 Create R/C .ser + S'$ ,CC-S'$ BI

.se4o ena le %ommuni%ation et een the SAP s(stems (ou ha+e to %reate an R?' user.

4he R?' user in the a li%ation %lient ena les multi le R?' %onne%tions. S&i this a%ti+it( if anR?' 8ser has alrea#( een %reate#.

Kou ha+e to maintain :%he%& this ste in SAP $) an# SAP E''.


Transaction Code SU01

S'$ Men" Tool! A"mini!tration 2!er #aintenance 2!er!

2. 7n the 2!er #aintenance' Initial !creen enter the follo ing #ata*

/ield na e .ser val"es8ser R?'8SER

<. 'hoose the Create utton.

=. 7n the #aintain 2!er s%reen enter the follo ing #ata*

'ddress

/ SAP AGPage ! of 15




ast ame R?'8SER

*ogon data

8ser t( e Dialog

Pass or# el%ome

De!a"lts

ogon anguage E

$ro!iles

Profiles /or ,CC:

S'$3'**

S'$3 ,4

S3BI54 3R/C

/or BI:

S'$3'** S'$3 ,4

S3BI54 M3R/C

5. Sa+e (our entries.

4he s(stem user R?'8SER is %reate#. 4o all %reate# te%hni%al users the rofilesSAP A is assigne# manuall( hi%h gi+es them full authori9ation rights. )f thisauthori9ation is not a li%a le to (our roCe%t (ou ha+e to restri%t the rights of theseusers a%%or#ing to (our %om an(Ns se%urit( oli%(.

&1& Create R/C Destinations + S'$ ,CC-S'$ BI

.seKou must maintain an R?' %onne%tion to (our E'' s(stem in the $) s(stem.

Kou must maintain an R?' %onne%tion to (our $) in the E'' s(stem.

$roced"re34 A%%ess the a%ti+it( using one of the follo ing na+igation o tions*

Transaction Code SM59

S'$ Men" SA+ Net,ea er → Application Ser er I$oc Interface - Application Lin. Enablin) (ALE/ → Comm*nication → Create R5CConnection!

/ SAP AG of 15




64 'hoose the Create utton on the Confi)*ration of R5C Connection! s%reen.

74 7n the u %oming s%reen enter the follo ing #ata*

/ield na e 8al"e

R?' Destination 4he logi%al name of (our E'' %lient or $) %lient.

'onne%tion 4( e <

Des%ri tion ?or e3am le* A name in hi%h the %lient an# s(stem a ears

84 'hoose the ENTER &e(.

94 4he s(stem %hanges automati%all( to the Technical Settin)! tab4

:4 7n this ta enter the follo ing #ata*

/ield na e 8al"e

4arget Host Host name of (our $) s(stem or E'' s(stem

S(stem num er the s(stem num er of (ou $) s(stem or E'' s(stem

6. 'hoose the ENTER &e(.. 7n the Lo)on ; Sec*rity tab enter the follo ing #ata*

/ield na e 8al"e

4ruste# S(stem o

Authori9ation for Destination Em t(

'lient 4he %lient num er of (our E'' %lient or $) %lientS(stem

8ser R?'8SER

Pass or# el%ome

. 'hoose the ENTER &e(.

!. 'onfirm the information message* 2!er can be *!e" for remote lo)on in tar)et !y!tem .

10. Sa+e (our entries.

11. 'hoose the utton.

A log similar to the follo ing one sho s (ou that the %onne%tion is #efine#.

/ SAP AG of 15





&1&6 'ctivate Technical Content + S'$ BI

.se4he fir!t time (ou enter the A#ministrator "or& en%h the s(stem a%ti+ates in a a%&groun# Cothe Technical Content .


Transaction Code RSA1

S'$ Men" #o"elin) $ata ,areho*!e ,or.bench' #o"elin)

2. )n the Replicate eta#ata #ialog o3 %hoose Only Acti ate .

<. )f a message a ears that (ou are onl( authori9e# to or& in %lient ... ,$rain 00! refer toSAP ote <16!2< ,#o not im ort the su ort a%&age ut use the #es%ri tion un#er se%tion,or.aro*n" .

=. ?lag the message* $o not !ho% thi! <*e!tion A)ain= in the u %oming s%reen.

5. 'hoose the >e! utton.

Res"lt

a&e sure that the %urrent Co has finishe# efore (ou ro%ee# ith the ne3t ste .'he%& the status of the a%&groun# Co using transa%tion SM 7 or S*#1 .

)f there are ro lems (ou must first sol+e them. 4hen (ou %an restart the a%ti+ationof the 4e%hni%al 'ontent ( using the transa%tion RSTCO_A$#IN4

&1&7 De!ine R/C.S,R as De!a"lt + S'$ BI


Transaction Code RSA1

S'$ BI Men" #o"elin) $ata ,areho*!in) ,or.bench *#o"elin)

/ SAP AG of 15




2. 7n the $ata ,areho*!in) ,or.bench' #o"elin) s%reen follo the menu ath Settin)! ?lobal Settin)! .

<. 'hoose the $i!play Chan)e utton on the $i!play ie% @RSA$#INA #aintenanceie% ' $etail! s%reen.

=. Enter the follo ing #ata*/ield na e .ser val"e

$" 8ser A E R?'8SER

5. 'hoose the Sa e utton.

ea+e the transa%tion in or#er to a%ti+ate the entries (ou ha+e ma#e.

&1&9 Maintain proposal !or "sers in the So"rcesyste ('*, co "nication)


Transaction Code

S'$ IM# Men" SA+ Net,ea er → 0*!ine!! Intelli)ence → Lin.! to Other So*rceSy!tem! → Connection 0et%een SA+ Sy!tem! an" 0I Sy!tem → #aintain propo!al for *!er! in the !o*rce !y!tem (ALE

comm*nication/64 7n the Chan)e ie% &0,'2!er in SS for ALE Comm*nication&'$etail! s%reen enter

R?'8SER in the SS *!er ALE4

74 'hoose Sa e .

&% Cross Connectivity

.se4his %ha ter #es%ri es all settings that are ne%essar( to %onne%t the %om onents of the SAPs(stem lan#s%a e ith ea%h other. 4he settings for ea%h %om ination of t o %om onents to e

%onne%te# are #es%ri e# in a se arate stru%ture no#e. 4he se arate se%tion hea#ings ma&e itossi le to i#entif( the a%ti+ities reIuire# to %onne%t %ertain %om onents ith ea%h other. 4he

se%tion hea#ings for %om onents that are not art of the installation %an e s&i e#.

&%&1 Connect S'$ BI ith S'$ ,CC + S'$ BI

$roced"re

/ SAP AGPage 1< of 15




34 A%%ess the a%ti+it( using one of the follo ing na+igation o tions*

Transaction code RSA1

S'$ BI Men" #o"elin) $ata ,areho*!in) ,or.bench *#o"elin)

64 'hoose #o"elin)4

74 'hoose So*rce Sy!tem!4

84 Right-mouse-%li%& in the in#o on the right 4

94 'hoose Create4

:4 a&e the follo ing entries*

/ield na e .ser val"es

A+aila le Destination ogi%al name of (our E'' S(stem

$a%&groun# user in sour%e s(stem R?'8SER

Pass or# for sour%e s(stem el%ome$a%&groun# user in $" R?'8SER ,%an not e %hange# in this

a%ti+it(

Pass or# for $" user el%ome

B4 )n the #ialog o3* +lea!e lo) on a! an a"mini!trator in the follo%in) !creen= %hoose Contin*e .

4 og on to the SAP E'' S(stem ith (our a#ministrator user.

!. 'hoose the %orre%t %lient.

10. 7n the Ne% So*rce Sy!tem Connection #ialog o3 %hoose Contin*e .

11. 7n the Chec. R5C "e!tination #ialog o3 %hoose 2!e4

12. 7n the Replicate #eta"ata #ialog o3 %hoose Only Acti ate .1<. Right- ouse-'li%& on the ECC So*rce Sy!tem .

1=. ?ollo the %onte3t menu ath Acti ate .


&%&% Connect /ile Syste in S'$ BI + S'$ BI

.se4his se%tion #es%ri es all settings that are ne%essar( for the %onne%ti+it( for an e3ternal s(stem -P' files on the "or&station ,for e3am le E3%el files or files on the a li%ation ser+er in SAP $).


4ransa%tion %o#e RSA1

SAP $) enu #o"elin) $ata ,areho*!in) ,or.bench' #o"elin)

/ SAP AGPage 1= of 15




64 'hoose #o"elin) .

74 'hoose So*rce Sy!tem! .

84 )n the right-han# frame mar& the entr(

94 Right- ouse-'li%& on

:4 'hoose Create4

B4 Enter the follo ing #ata*

/ield na e .ser val"es

ogi%al sour%e s(stem ?) E

Sour%e s(stem name ?) E

4 'hoose the $utton Contin*e .

D4 Right- ouse-'li%& on the ?) E Sour%e S(stem3 4 ?ollo the %onte3t menu ath Acti ate .

/ SAP AG of 15

bi retail connectivity

Documents