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

Characteristic as an Attribute of Key Figure BPS-BCS

Hi,

We're endeavoring to integrate BPS and BCS data for planning. Our issue is that our BPS data is COPA-like in that it's Key Figure-based. We are not using 0ACCOUNT. Our BCS data will be using FS Items.

My thought would be that this integration would be made easier if a Characteristic (FS Item) could be an Attribute of a Key Figure. I wouldn't need to then map and copy the data, I could just report it differently. The Business has agreed that a one-to-one relationship could exist between a Key Figure and a Cons Account.

I assume I could use a big FOX formula to convert the data in BPS, or write an external program...but those options could be difficult to maintain in the long-term.

Any suggestions?

Much appreciated.

LR

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2004 at 01:52 PM

    One additional point...we're considering the sotrage of this data in a transactional Cube that is separate from the primary BCS and BPS Cubes. We'd want to set it up to be able to create a Multi-Cube with the Actual data in BCS.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I've had some success with modelling both models in one cube. Just add 0ACCOUNT and 0AMOUNT to your cube and use a FOX formula, an Exit function or simple BW update rules to transform the data.

      Best regards

      Dirk

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2004 at 04:04 PM

    Thank you. Would it not be easier to make a Key Figure (ie Gross Sales) become an Attribute of 0CS_ITEM? That way, data doesn't need to be converted...just reported in another way?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

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.