One Valid Member on the Right Side

In these examples, the source account has only one valid member, and the destination account has two valid members.

In this example, Exp is used without specifying a Custom1 member on either side of the equal sign:

HS.Exp "A#TargAcct = A#SourceAcct"

The function puts this data into the intersections of the Custom1 members and the TargAcct account:

Custom1 Member

Data

Intersection

Member001

15

SourceAcct and Member003 (the only valid intersection for the SourceAcct account)

Member002

15

SourceAcct and Member003 (the only valid intersection for the SourceAcct account)

Member003

N/A

Not applicable. Member003 is an invalid intersection for the TargAcct account.

In this example, Exp is used with Member001 specified on the left side of the equal sign:

HS.Exp "A#TargAcct.C1#Member001 = A#SourceAcct"

The intersection of TargAcct and Member001 is set to 15, which is the data in the intersection of SourceAcct and Member003.

Tip:

If there were more than one valid intersection for the SourceAcct account and the Custom1 dimension, Exp would attempt to get data from the intersection of SourceAcct and Member001. If this were an invalid intersection, then Exp would leave the destination account unchanged.