how to define user defined dimensions in script logic

[Former Member]

Hi Team,

i have created user defined dimension AN_PRODUCT and a property agent commission.

but getting an error ,when writing the script logic ,Invalid dimension AN_PRODUCT in the model.

*XDIM_MEMBERSET AN_ACCOUNT = TOP_PER_UNIT

*XDIM_MEMBERSET AN_CATEGORY = ACTUAL

*XDIM_MEMBERSET AN_ENTITY = USA

i need to define product dimension here..

*XDIM_ADDMEMBERSET {dimension} = {members set}

*XDIM_MEMBERSET AN_RPTCURRENCY = LC

*XDIM_MEMBERSET AN_TIME = 2005.JAN

could you please let me know which function to be used to add the user defined dimension in the logic.

thanks in advance for your quick answers.

Aditya

[anil_agrawal · Accepted solution]

Hi Aditya,

There is no need to add any specific function to the user defined dimension in the script logic.User defined dimension behave similar like other dimension in the script logic.Try to check you write proper spelling in your  logic script,another way try to add one test member in your user defined dimension reprocess the dimension after that write the script again if still the problem come let me know.

Thanks

Anil

[Former Member]

thanks Anil and Arjen for the inputs.

i added the user defined dimension to the model and now working fine in script logic.

Aditya

[Former Member]

Hi Aditya,

Did you add this dimension into your model? If you forgot, add it please.

If added, then I think the data cache in backend is not up-to-date. Try following suggestion:

1. Process this dimension again.

2. Go to the Edit screen of your model and change the description of it, then click save to process this model.

3. Go to backend SE38 and run: UJA_REFRESH_DIM_CACHE

Best Regards,

Arjen