cancel
Showing results for 
Search instead for 
Did you mean: 

Query not show all variable in selection screen

Former Member
0 Kudos

Hi All,

We have report requirement to create query with selection Key Date, Target Currency and Exchange Rate Type. To fulfill this requirement we have created Currency Translation Type ZCTT1 with following properties:

1. Exchange Rate tab : We have selected "Ex. Rate Type from Var." = ZRTYPE_00 ( Exchange rate variable with user input)

2. Currency tab : We have selected "Target Currency from Variable" = ZCURRNY_00 ( Currency Variable with user input)

3. Time Ref. tab : We have selected "Time Reference from Variable" = ZKEYDATE_00 (Key Date Variable with user input)

We have added this Currency Translation Type in CKF Conversions properties:

Conversion Type = ZCTT1 ( Currency Translation Type created above).

Target Currency = ZCURRENY_00 (Target Currency Variable)

After CKF creation we added this in query and in query variable sequence it show Target Currency, Key date and Exchange Rate Type variable. But when we run query in RSRT it will not show Target Currency and Exchange Rate Type in selection screen.

Please Suggest if any one have any idea. Please find the screen shot.

Thanks,

Girish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Refer below screenshot. Click on one of the marked buttons to get all selection variables with Input Ready option.

Answers (1)

Answers (1)

former_member186696
Active Contributor
0 Kudos

Hello Anjana

The only thing that come to my mind is how these two variables are setup.
Each variable has a property called "Processing by".

Check if this property is setup as "Manual input/Default value".

Let us know if this is not the case.

Bets Regards
Edward

Former Member
0 Kudos

Hi Edward,

Both variable are "Manual input/Default value". Then also it's not show in selection screen.

Thanks,

Girish

cornelia_lezoch
Active Contributor
0 Kudos

Hi Anjana,

is there already a personalzation set for the user ID you are using?

regards

Cornelia