The SortDataModelTopics script enables documents to be updated so the topics in any data models are displayed in EPM Workspace in a user-defined order or alphabetically.
When an Interactive Reporting document is opened in EPM Workspace and a query is visible, a list of topics is displayed in the catalog pane under Tables. The topics are displayed in the order in which they were added to the Interactive Reporting document, which makes locating topics difficult if there are many in the list.
The SortDataModelTopics script enables the user to specify the order in which the topics are displayed in these lists, using three parameters.
There are two ways to specify the sort order:
Use the first parameter to select a file containing a list of topic names, in the order preferred by the user.
Use the second parameter (true or false) to specify whether topics that are not included in the sorted file should be ordered alphabetically.
Topics that are not mentioned in the sorted file are placed after topics that are mentioned, and are ordered according to the second parameter. Therefore, if you provide an empty file and the second parameter is true, all topics will be ordered alphabetically, making it easy to locate a topic in the list.
Note: | The empty file should contain a blank line. |
The third parameter enables selection from a set of files to be updated, through a multi-file picker.
A version is added for each successfully updated file. Therefore, double-clicking a file in EPM Workspace displays the updated content.
This process is described in these topics: