UJK_VALIDATION_EXCEPTION:Property value not found

[Former Member]

Hi All

I am getting below error when executing script logic.

UJK_VALIDATION_EXCEPTION:Property value not found.

I got Entity and Intco as properties in my dimensions (entity and intco dim).

*WHEN Z_PARTNERCO

*IS <> PCC_DEF_CC

*REC(FACTOR=1,Z_COSTOBJECT=[Z_PARTNERCO].ENTITY,Z_PARTNERCO= [Z_COSTOBJECT].INTCO,EB_DATASOURCE ="Matching")

*ENDWHEN

Any ideas

[Former Member]

Hi,

Is this your entire code? Can you please share the entire code? As already suggested that please check whether the property has been maintained for all the members fetched from the xdim statement. I would also like to suggest that - since, you have Z_PARTNERCO= Z_COSTOBJECT.INTCO, you should restrict Z_COSTOBJECT dimension to one member.

Hope this helps.

[Former Member]

Thanks for your reply guys.

Here is my entire code

//Logic: Transfer_Matching.lgf

//Description: Logic that will notify partner profit centres of transactions against them

*SELECT(%Year%,"[YEAR]","Z_Version","[ID]='WB'")

*SELECT(%Months%,"[ID]","Z_Time","[YEAR]=%Year% AND [LEVEL] = 'MONTH'")

*XDIM_MEMBERSET Z_TIME = %Months%

*XDIM_MEMBERSET Z_VERSION = WB

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET EB_DATASOURCE= MANUAL

*XDIM_MEMBERSET EB_ACCT= TI,TO

*WHEN Z_PARTNERCO

*IS <> PCC_DEF_CC

*REC(FACTOR=1,Z_COSTOBJECT=[Z_PARTNERCO].ENTITY,Z_PARTNERCO=[Z_COSTOBJECT].INTCO,EB_DATASOURCE ="Matching")

*ENDWHEN

[Former Member]

Same code works on MS version BPC.

[Former Member]

Hi Satish,

that a script works on BPC MS, doesn't automatically means it also works on BPC NW.

Since you don't specify the dimension Z_COSTOBJECT nor Z_PARTNERCO in the XDIM_MEMBERSET, the logic will try to fetch the properties for all members of these dimensions. When you don't maintain the properties for all members the logic will not work.

I advice you to make a specification in your XDIM_MEMBERSET for the dimensions Z_COSTOBJECT and Z_PARTNERCO so you know that the properties are maintained for the selection you try to fetch, or you have to maintain the properties for all members of your dimensions Z_COSTOBJECT and Z_PARTNERCO.

But first i would suggest that your try the logic in the logic tester integrated with BW.

Run transaction SE38 in the basic screen of BW and than run UJK_SCRIPT_LOGIC_TESTER.

This will give you a possibility to run your script in a simulation, this way you can test the script first with only one member from which you know the properties are maintained to see if it works.

Harmen

[Former Member]

Hi Satish

Have you filled the property for all the members in the dimension?

I found out that while it is not always necesary, the logic checks if the property is filled for all the members it gets from the XDIM_MEMBERSET.

When there is a member for which the property is not entered it gives you this warning.

Harmen

[Former Member]

Hello,

Have you solved it? I am facing exactly the same problem.

Which version of BPC are you using? we have just implemented BW 7.5 SP06.

Any ideas?