Characteristic as an Attribute of Key Figure BPS-BCS

[Former Member]

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

[Former Member]

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

[Former Member]

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

[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