Product Not assigned in DM Error while triggering Data manager

[praveen_kumar334]

Hi Team,

I am getting below error while running the DM package.I know that the error is because of the Product and Report currency values are not assigned during the dynamic script logic. In the advanced tab, i have assigned all 5 dimension in the prompt line but in the output i am getting prompt only for category, entity and time. I am not sure why Product and Report currency values are not getting. Please advise.

Regards,

Praveen.

[former_member186338 · Accepted solution]

Sorry, but I see very strange advanced DM script!

PROMPT has to be on single line, not on 2 lines!

Also the correct line will be:

PROMPT(SELECT,,,,"%TIME_DIM%,%CATEGORY_DIM%,%ENTITY_DIM%,PRODUCT,%CURRENCY_DIM%")

%TIME_DIM%,%CATEGORY_DIM%,%ENTITY_DIM%,%CURRENCY_DIM% special id's for the specific dimension types.

There is no special id for user defined dimension PRODUCT - have to use name!

[former_member186338 · Accepted solution]

Read help about special constants like %CONST%:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.36/en-US/f9c5f6066faf1014878bae8cb...

[praveen_kumar334]

Hi Vadim,

Yes both %PRODUCT_DIM% and %RPTCURRENCY_DIM% are changed to PRODUCT and %CURRENCY_DIM% and it worked fine. Thanks for the help.

Regards,

Praveen

[praveen_kumar334]

Thanks Vadim. Issue has been fixed. I just corrected user defined dimension with name.

[former_member186338]

%RPTCURRENCY_DIM% is also incorrect! Has to be %CURRENCY_DIM% or simply RPTCURRENCY without % and _DIM%

[praveen_kumar334]

Hi Vadim,

I just placed in 2 lines to make sure all the dimension will be visible in the screenshot.

[former_member186338]

Instead of screenshot - why not to post text using CODE button...

I have added correct line to my answer