Skip to Content
author's profile photo Former Member
Former Member

Converting key figure model to account based

Dear All,

We have loaded table COSP into BW. It's key figures are Transaction value, Object value and Controlling value..... but each key figure is split into 13 (one for each period). That is, it's key figure based.

We have also loaded table COVP, which has the same key figures, but not split into 13 periods. Period values exist on separate rows on the table. That is, it's account based.

Our objective is to create a multiprovider across the DSOs that hold the data for each table.

Question - Is it possible to transform the table data of COSP into an account based format so that it's compatible with COVP account-based format?

Regards,

Frederick

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 26, 2011 at 06:33 AM

    Hi Frederick,

    In addition to the previous comment that might get more at the root of the problem, yes it is possible to convert from a key-figure to an account model. I'd recommend using transformation rule groups to do this, which will allow you to create a different rule-group for each time-based key figure and in each rule group specify the rules for populating your time characteristics. You can maintain non-time characteristic mappings centrally in the main rule-group, so you don't need to maintain all mappings 13 times (or however many periods you have).

    Cheers,

    Ethan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 26, 2011 at 06:27 AM

    Hi,

    Can you not use DataSources 0CO_OM_CCA_9 & 0CO_OM_CCA_1 instead?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The table was imported from an old instance of SAP 4.0B which does not have BW extractors.

      We are importing data from 4.0B only for storage purposes (because the server will be switched off soon), but with some additional reporting added on for controlling actual and plan values.

      I wish there was the benefit of standard extractors....

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.