cancel
Showing results for 
Search instead for 
Did you mean: 

Package to Automate script logic - Dynamic script

Former Member
0 Kudos

Hello,

I have created a package to automate my script logic using process chain.

In the package > under View Package > Advance added script to prompt Dimension allowing user to enter the values.

Can't we give custom dimension as a prompt? eg., B_ABAB

here is my script PROMPT(SELECTINPUT,,,,"%B_ABAB_DIM%") in the output it shows me %B_ABAB% and it throws an error when i try to view the values from that dimension.

However Category,Time and Currency dimensions in the prompt work fine.So i just wonder whether it is not allowed to give custom dimension in dynamic script.

Regards

Accepted Solutions (1)

Accepted Solutions (1)

esjewett
Active Contributor
0 Kudos

Hi,

You can use PROMPT(SELECTINPUT,,,,"B_ABAB"). The variable replacement only works for standard dimensions that are defined in the dynamic package constants section of the package editor. They are just replaced by the real names of the dimensions in your application. You can just hardcode a comma-separated list of dimension names rather than using the variables.

Ethan

Former Member
0 Kudos

Hi

As mentioned above by one of the experts

u can use %UD1_DIM%

Thanks

CSD

Former Member
0 Kudos

Ethan,

ausgezeichnet !!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can use %DIM% to list out all the dimensions in your application. Then the user cn selectively provide the members for the desired dimensions.

Hope this helps.

Former Member
0 Kudos

Nilanjan,

Well, that is how i am doing now.

However i do not want to expose all the dimension to the user who runs the package.

I want to give only one dimension (dim type user defined) to be visible to the user, allowing him to choose the value(s).

is it not possible?

Regards

Former Member
0 Kudos

Hi,

I am not very sure on this. But I think you can try out something.

1. Open the System_Constants.lgl for your application and add the statement

*FUNCTION USER1DIM = user defined dim

You can have multiple statements for different user defined dimensions

2. Open the System_Constants.lgt file in system library folder and add

*FUNCTION USER1DIM = %U1_DIM%

3. In the DM package, include %U1_DIM%

Hope this helps.

Former Member
0 Kudos

Hi,

Modify SYSTEM_CONSTANTS.LGF under file service UJFS and then upload again ?

or is there a other way to handle this ?

appreciate your help.