cube create for sales report

[Former Member]

My senior people they want see the report of 13 periods (or) 13 cycles of sales report and compare the data with pervious data and make into one report

My issue is like this

<b>Branches year percentage</b>

03-04 04-05 05-06

Delhi 8000 5000 1,00,000

A.P 4000 7000 50,000

panjim 10,000 2000 20000

etc --- --- -

---

Here my issue is like that, we people implemented sap 0n year 05-06 .pervious data that is (03-04, 04-05) date was there in legacy system.

Now my senior people told me that, there want to keep all data i.e legacy system data and r/3 date into one cube and make that into sales report

Can u plz tell me how create a cube and put all data that is 2003-2006 date into one cube and how to compare these

[former_member181964]

Hi,

See in R/3 system is there any SAP datasources are there or not if they are available in R/3 (Tcode RSA5)then install it and then replicate it in BW and create Infosource and Infocube and load data.If you want to load all the data into single cube, assign all datasources to single Infosource and load data.

The following link will give the details about Infocube creation.

http://help.sap.com/saphelp_nw04/helpdata/en/74/e8caaea70d7a41b03dc82637ae0fa5/frameset.htm

Thanks

Reddy