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.
Create a Dictionary
Add elements to it
Create a dictionary parameter in Excel
Create a dimension parameter with a script, in this case the scenario dimension
Used script in parameter
result := this.lowest.select(“LEFT($Scenario.code,4)”,“=”,YR);
In form add the dimension parameter and the created dictionary parameter
Want to know more?
Are you curious about the possibilities of CCH Tagetik and Finext? Have a look at our CCH Tagetik page here.
If you have any questions, don’t hesitate to let us know. You can find all our CCH Tagetik specialists here.