How to send the value of a property of a dimension from APP1 to APP2 like dimension ID

[Former Member]

Hi to all,

When trying to push data from one application to another there is a way out if what you need is to map some properties of APP1 to some dimensions of APP2

This is the example taken from another post by B.R Vadim:

Example:

Application (source): APP1

Dimensions: A,B,C

Application (target): APP2

Dimensions: A,D,E

Dimension A have properties: DT and ET (target members of Dimensions D and E).

The code in APP1 will be:

*DESTINATION_APP=APP2

*RENAME_DIM B = D

*RENAME_DIM C = E

*WHEN A

*IS *

  *REC(FACTOR=0,B=A.DT,C=A.ET)

*ENDWHEN

This works perfectly but what would happen if APP1 has as dimension only A and B? is there a way out for BPC 7.5?

Thanks in advance

[Former Member]

Hi,

if APP1 has fewer dimensions than APP2 you can still transfer data. You can either hardcode one element for dimension E that will be used or you can add properties to dimension A  or B that indicate the member of dimension E.

in your script you can use

*SKIP_DIM and *ADD_DIM to deal with differences in the number / type of dimensions. The syntax for *ADD_DIM is

*ADD_DIM {dimension_id}.{value}

BR,

Arnold