"Branching" workstatus approval functionality

[Former Member]

Hi

I would like to be able to write to dimension property columns from within an input schedule.

Is this possible?

For example I want to change the contents of the "owner" property assigned to an ORG dimension member based on some criteria within an input schedule.

This is linked to a requirement I have for providing some sort of "branching" workstatus approval functionlity, ie for criteria A, Mr Smith changes the workstatus otherwise Mr Jones changes the workstatus. For either criteria only one person must receive an email alert and have the right to change the workstatus and therefore lock data.

Thanks

Phil

[Former Member]

Hi,

My understanding says its not possible because the input schedule fethes all the details from the fact tables of the application, which doesnt store the details of the properties of the dimensions.

However, I believe, you should try to change the value of the property in the script logic. Based on your conditions, you can manipulate the propertie values.

Hope this helps.

[Former Member]

Excellent suggestion Nilanjan, I was not aware that script logic could change dim properties.

I have used it to move data between applications and for calculating/generating records in the fact tables based on dim properties but I have not written back to dim property columns themselves.

Do you have an example of the syntax for changing dim properties?

I use the following to check properties - how do I set the property?

*WHEN ACCOUNT.GROUP_CAT

*IS "RENTS"

Many thanks

[Former Member]

Hi,

You can simply use the command

*REC (property = "your property value")

Hope this helps.

[Former Member]

Hi

When I use the following code, I get the following error:

"Invalid Dimension ORG.OWNER in Lookup Rule" or "Invalid Dimension OWNER in Lookup Rule" for *REC (ORG.OWNER="UOB\ISYS-BPCSADM-B") and *REC (OWNER="UOB\ISYS-BPCSADM-B") variations respectively

I definitely have an ORG dimension member CHEM and property OWNER.

Is there a problem with my syntax?

=================================

//test updating dimension properties

*WHEN ORG="CHEM"

*REC (ORG.OWNER="UOB\ISYS-BPCSADM-B")

*ENDWHEN

*COMMIT

================================

Thanks

[Former Member]

Hi,

*REC is not recognizing the Owner property. You can try using the below syntax

#ORG.OWNER="UOB\ISYS-BPCSADM-B"

Hope this helps.