1 create generic datasource

1. 1 create generic datasource • Transaction RS02

3. 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

4. 3 create an infoarea in BW • inforpovider right click create infoarea "demo info area"

5. 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

6. 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

7. 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

8. 7 create infosource • (infosources) • right click creat applic component "demo" • right click create infosource • Zdemo_ • if masterdata choose direct update md

9. 8 assign datasource • right click (infosouce) • assing datasource • select source system • (show active datasources) • find your datasource • assign to infosource ? yes

10. 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

11. 10 create update rule for cube • choose infosource name • next screen • disply key figures • activate

12. 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

13. RRMX bex analyzer • Create query

14. reload • infosources • system / infopackage • start • load scedule again? • yes