Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    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 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
    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 comment
    10|10000 characters needed characters exceeded