CCH Tagetik: 3 tips & tricks for users – Dictionary for preselection other parameters

How to use a dictionary in a form to create a preselection for other parameters;

Working with CCH Tagetik with many of you, we found several tips ’n tricks for working with the application we would like to share with you. The purpose of this is to have an extra prompt to make a preselection for another prompt.

CCH Tagetik Dictionary

  1. Create a Dictionary

CCH Tagetik Dictionary 2

  1. Add elements to it

CCH Tagetik Dictionary 3

  1. Create a dictionary parameter in Excel

CCH Tagetik Dictionary 4

  1. Create a dimension parameter with a script, in this case the scenario dimension

CCH Tagetik Dictionary 5

  1. Used script in parameter

TGKML 1.0
YR:= @YEAR;
result := this.lowest.select(“LEFT($Scenario.code,4)”,“=”,YR);

  1. In form add the dimension parameter and the created dictionary parameter

CCH Tagetik Dictionary 6

 

Want to know more?

Are you curious about the possibilities of CCH Tagetik and Finext? Have a look at our CCH Tagetik page here.

Click here for another tip. Want to know how Tagetik is used for planning and budgeting? Watch our webinar here. 

If you have any questions, don’t hesitate to let us know. You can find all our CCH Tagetik specialists here.