Ideal design required for COPA module in BW 7.3

[Former Member]

Hi,

We have standard configuration implemented for COPA module in ECC side and asked to implement same in BW, I've generated a COPA data source ECC side based on operating concern (Cost based) given by CO consultant and replicated to BW. Can somebody suggest me standard BW COPA flow (BW 7.3) which can fulfill maximum reporting requirements in BW.

Regards

[sander_vanwilligen · Accepted solution]

Hi Sree,

Recently I also worked on a new CO-PA data flow. Let me share how I have done it.

The CO-PA configuration of the Operating Concern is the starting point. I suggest to replicate the configuration as complete as possible. Generate the CO-PA DataSource as follows: all active Characteristics, all Line Item Characteristics, all Value Fields, all Calculated Key Figures (optionally, you might want to do it in BW), and all Fixed Fields. This will expose the maximum of data on the lowest granularity (i.e. document level).

In the Data Warehouse Layer you create a DSO containing InfoObjects for all extracted fields. I used my Data Warehouse InfoObjects approach to generate all InfoObjects. Please refer to for more information.

In the Architected DataMart Layer you will experience that Characteristics already exist to a large extend. E.g. Material related and Customer related but also Controlling related. You will have to create some custom Characteristics for the new objects (of course with the dependent requirements in terms of attributes, texts and possibly hierarchies).

The Key Figures will have to be created from scratch. I used LSMW for that because there were a lot of Key Figures to be created, based on the same Key Figure definitions but with different descriptions.
I exposed as much as possible, i.e. all Key Figues and Characteristics in the following Dimensions: Material, Customer, Organization, Sales and Controlling (next to the standard dimensions Time, Unit and Package).

Best regards,

Sander

[Former Member · Accepted solution]

Hi Sander,

First of all, I would like to thank you for taking your valuable time to answer my question. I've gone though the link (Generating Data Warehouse InfoObjects - Part 1: Introduction) and it has cleared all my doubts.

Regards,

Sreehari.

[RamanKorrapati]

Hi,

COPA - is custom generated data source, its depend on client requirement(depends on Operating concern).

Might be bit difficult to say reporting requirements which full fill.

Thanks

[Former Member]

Hi Ram,

Thanks for the input. Let me put in this way, if i want to bring raw COPA data from ECC to my first staging layer (say dso) in BW, can you suggest me standard dso to be installed from business content ?

Regards,

Sreehari.

[RamanKorrapati]

Hi Hari,

When data source was custom one how we expect standard dso for the same data source.

Need to go with custom dso.

Mean while check  COOM DSO's whether its have same fields of your copa data source or not.

Thanks

[Former Member]

Let me check Ram !!

Thanks.

[Former Member]

Hi Ram,

Just to update, i found Info cube 0COPA_C01, which somehow matches with my custom copa data source (Maximum fields are available). Going forward, i will create a ZDSO by taking this info cube as a template and then add required fields to it.

Regards,

Sreehari.