150 likes | 272 Views
1 create generic datasource. Transaction RS02. 2 replicate in bwsource systems . Source Systems > Data Sources select info area right click replicate data sources in info area select replicated with minus sign . 3 create an infoarea in BW .
E N D
1 create generic datasource • Transaction RS02
2 replicate in bwsource systems • Source Systems > Data Sources • select info area right click replicate • data sources in info area • select • replicated with minus sign
3 create an infoarea in BW • inforpovider right click create infoarea "demo info area"
4 create infoobject catalog for char & kf infoobjects • infoobjects demo infoarea create infoobject catalog • chars for "demo" (IOC) • choose ifnoobject type • kf for "demo" • activate
5 create inoobjects for chars and kf • undr catalog right click create infoobject • Zcustomer_demo • Zmat_demo • enter data type and length • master data /texts • uncheck with md with texts • activate infoobject • if you choose md or text it will create md and txt tabls in /bic/m... and /bic/t.... • for key figures... • create infoobject • select type /unit from existing • activate
6 create infocube • infoprovider • infoarea • rigt clk • create infocube or copy std cube • "demo_cube" • select chars for cube • find and transfer <= • at least one time characteristic • 0fiscyear <= • Create dimensions • (template ? no, create • 3 dim reserved 16 total (time unit datapackage reserved) • customer, product • assign charss • select kf's • activate cube ( double click on infocube to see def
7 create infosource • (infosources) • right click creat applic component "demo" • right click create infosource • Zdemo_ • if masterdata choose direct update md
8 assign datasource • right click (infosouce) • assing datasource • select source system • (show active datasources) • find your datasource • assign to infosource ? yes
9 maping and transfer rules : • enter infoobjects created on righ hand side • propose transfer rules • if not mapped red X • click an choose a approp valu • you can see commmunication structure • aactivate infosource
10 create update rule for cube • choose infosource name • next screen • disply key figures • activate
11 create infopackage • goto infosource • client right click create infopackage • from / to selection • processing psa and targetdata targets select it • update • schedule • foreground / back ground • start • choose monitor to see loading • refresh • details ( for debugging if going wrong) • cube • manage (right clikc) • contents
RRMX bex analyzer • Create query
reload • infosources • system / infopackage • start • load scedule again? • yes