User defined Dimension Prompt in Data Manager Package

[Former Member]

Hi All,

I want to use User defined dimension prompt in CPMB/Allocation process chain. I was try to it many way after read several notes in SCN but it will not not shown in my package,is there any limitation for user defined  dimension prompt use in allocation package?

Thanks

Mayur

[former_member225135 · Accepted solution]

Hi,

For User Defined dimension, you have to use dimension name in Prompt.

PROMPT(SELECTINPUT,,,,"DIMENSIONNAME")

This worked fine for me:

Regards,

Rahul

[Former Member · Accepted solution]

Hi rahul/Vadim,

Sorry for late reply is there any way I can use more than one user defined dimension in DM prompt.

Regards

Mayur

[former_member186338 · Accepted solution]

Yes, you can use as many user defined dimensions as you want, just comma separate the least or dimension names...

[Former Member]

In Modify package-->advanced-->prompt

for standard dimensions syntax is "%DIMENSIONNAME_DIM%"

For user defined dimensions syntax is "DIMENSIONNAME"

[former_member186338]

Hi, Ravi!

Actually the syntax is:

For  standard dimensions you can use both:

%STANDARDDIMTYPE_DIM% where STANDARDDIMTYPE is TIME, CATEGORY, ENTITY...

or

%REALDIMNAME%

for user defined only:

%REALDIMNAME%

Vadim

[jrg_finster3]

Hi Vadim,

I don't understand the idea to repeat the previous answers!

Just for points???

Jörg

[former_member186338]

Because the previous answer is not 100% correct And if you read my answer you will see the difference. Looking on the posts in the forum I can see that a lot of people really thinks that %STANDARDDIMTYPE_DIM% is the only way to select standard dimensions!

[Former Member]

Hi vadim,

Wrong syntax(%REALDIMNAME%) for 'user defined dimensions',not working.

[Former Member]

Apart from %STANDARDDIMTYPE_DIM%,...What is alternative solution ?

[former_member186338]

Hi Ravi,

You are 100% right, my typing mistake! No %!

Just "REALDIMNAME"

Vadim

[Former Member]

Thank you

[former_member186338]

By the way, in my projects I always prefer to use realdimnames for both standard and user defined dimensions - looks more readable

[Former Member]

Anyway syntax is same for all !!