Hoe to ad user defime dimension to dynamic script of data package

[Former Member]

The following script will generate the screen to allow the user to choose account and entity dimension for the data package.

PROMPT(SELECTINPUT,,%ACCOUNT_DIM%,%ENTITY_DIM%)

I have a user define dimension COSTCENTER, how could I make the COSTCENTER display in the selection screen as well?

[Shrikant_Jadhav · Accepted solution]

Hi Jian

Try this

PROMPT(SELECTINPUT,,%ACCOUNT_DIM%,%ENTITY_DIM%,COSTCENTER)

Shrikant

[Former Member · Accepted solution]

Thanks, it works, another question is how to assign another  default value instead of "All"?

[Shrikant_Jadhav · Accepted solution]

Hi ,

Can you explain you requirement  in more detail

Shrikant

[Former Member · Accepted solution]

As you can see from the screen shot:

The default value for all the dimensions is "All" , is there anyway we can make the default value to ve a specific value in stead of "All''?

[former_member186338 · Accepted solution]

Hi Jian,

There is no way to hardcode the default values for SELECTIPUT prompt.

But:

- Next time user will run the package the previous selection will be default

- You can default to context member with some extra settings in SELECTINPUT

- You can use COMBOBOX with default value

...

Vadim

[Former Member]

This message was moderated.