Skip to Content
author's profile photo
Former Member

COPA DataSource (Sorry, but little urgent)

Hello Everyone,

I am back with a new problem. I am working with a COPA Datasource. We are supposed to extract the data into ODS object and then into BW InfoCube. Our problem is to use the ODS object (BW System) and then using Open Hub Service, extract the data into a flat file or a Transparent table and store it on Application Server. I have gone through some previous discussions related to this. They suggested looking for material on help.sap.com. I want to know if any of you worked with a similar scenario before.

My Questions:

1. When working with COPA datasource to extract summary data, what issues did any of you confront with.

2. Before using ODS to extract data into file or table, we have to determine the key in ODS. How can we determine the key in ODS.

3. What issues did you confront with when using Open Hub Service to extract data from ODS (BW) into flat file or Transparent Table.

I would very much appreciate your help. I hope that, i am clear. Let me know if you need any other information.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Dec 21, 2004 at 07:25 AM

    Hello Everyone,

    Could someone please help me.

    Thanks.

    G

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Dec 21, 2004 at 08:24 AM

    Hi,

    the biggest problem with CO-PA is generating the extractor (which is pretty straight ahead withe the current Plug-In) and handling the delta when you have problems or repostings in CO-PA.

    1. I would not use an ODS to store data, I would use a cube. The CO-PA basically stores its data in a kind of star scheme so why transfer it into a flat table? ODS reporting on CO-PA is probably getting quite slow when I look at the amount of records a CO-PA usually generates.

    I have a customer that produces about 40 million CO-PA records in BW each year.

    CO-PA extraction supports delta so it should be no great problem.

    2. As I said you don't need an ODS so you don't need to determine a key. Otherwise you would have to concatenate different fields into one to keep your key at 16 fields or lose details.

    3. Two Issues - one is licensing that you need to discuss with your SAP sales rep. But when you've done it Open Hub sets up quite easily. The biggest restriction is that you cannot set up variables. So if you don't want to extract delta data you need to change your restrictions regularly.

    A customer who uses Open Hub regularly and very intensive reprogrammed the whole thing to go around this problem. They had more than a hundred companies and needed to extract from about half a dozen of cubes flat files per company at different times (triggered by decentralized personnel). This is not what Open Hub can do on its own, you need to do some heavy programming.

    Best regards

    Dirk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dirk,

      Thanks for the response. But, could you throw some more light on the restriction regarding setting up variables. In what way is it related to Delta data update. Also, could i know more about summarization levels (the way they are used). Thanks for your time.

      Thanks.

      G