Allocation Query on referring property of another dimension for posting

[Former Member]

Hi guys

We have this following scenario.

Entity dimension (CASE_ID) has attribute of project type (PROJ_TYPE). It also has separate attributes (CASE_TYPE) segregating Hydrocarbon and non-hydrocarbon type of activities.

Now, all costs incurred on the Non H/C type cases are allocated to H/C cases. We would like retain the proj_type of sender (non H/C case) in the allocation record that posts to the receiver H/C case. We thought we would choose the audittrail dimension to help out.

Options tried:

All proj_types have also been created as auditrail members. In the allocation script, this is how that has been written

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CASE_ID     WHAT = $SND$;      WHERE %RECEIVER%;     USING = <<<;

*DIM ACCOUNT     WHAT = BASE_COST; WHERE = <<<;      USING = $REF$;      TOTAL = <<<;

*DIM AUDITTRAIL     WHAT = INPUT;      WHERE = $SND$.PROJ_TYPE; USING = <<<

*ENDALLOCATION

Now the script validates out fine, but when we run the allocation it says snd.proj_type is unknown.

We tried a few options such as hard coding a sender CASE_ID member into the code, but it doesnt like it. The only two viable alternatives we see are:

1. somehow select the sender case's proj_type earlier in the script and then refer the "WHERE" to that place.

2. instead of proj_type simply post the sender case Id in the audittrail, and then manipulate the reports to get our results.

Option 2 is not selling itself since it means we first have to maintain each non H/C case in the audittrail dimension. Option 1 - we would like but havent yet understood what syntax would work.

Any ideas?

regards

Shrikant

BPC 10.0 NW SP12

EPM add in SP 21 Patch 3

[Former Member · Accepted solution]

Shrikant,

This is what needs to be added to the allocation script. Your Option 1

*SELECT(%PRJCT_TYPE%,"PROJECT_TYPE","CASE_ID","[ID] = '$SND$'")

Then In each allocation block add one more line as below.

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CASE_ID  WHAT = $SND$;            WHERE = %RECEIVER%;       USING = <<<;

*DIM ACCOUNT  WHAT = BASE_COST;            WHERE = <<<;       USING = $REF$;       TOTAL = <<<;

*DIM AUDITTRAIL  WHAT = INPUT;            WHERE = %PRJCT_TYPE%;       USING = INPUT;       TOTAL = <<<;

*ENDALLOCATION

Regards

Nikhil

[former_member186338 · Accepted solution]

In addition, I have the question about the line:

*DIM CASE_ID

WHAT = $SND$; What is  %RECEIVER%???

WHERE %RECEIVER%;

USING = <<<;

[Former Member · Accepted solution]

Vadim,

%RECEIVER% is set of case id's filtered by a property where allocated values will be written. There is a SELECT statement used with %RECEIVER% on case id which Shrikant has not shown.

Regards

Nikhil

[former_member186338 · Accepted solution]

Looks like you can see the full script of Shrikant? Sitting near him?

Vadim

[Former Member · Accepted solution]

Yep, he is. We had this query and cracked the answer after the blog was created. Thanks for your help, as always.

[former_member186338]

Please provide the detailed info on dimensions and test code you have already developed!

Vadim