Archive for the ‘Uncategorized’ Category

After having traveled for the past almost two weeks, including a trip to Karlsruhe, Germany for the IT & Dev Connections conference, I was working my way down the list of unread emails. I came across an email from a partner, who was complaining about it being difficult to find a specific table in the timeXtender meta model once a project reaches a certain size. Apparently he did not know about the search function that has been in timeXtender for quite some time now. This made me realize that we probably haven’t been to good at telling about it, thus I will take this opportunity to explain how this small, basic and hard to live without function works.

In short, the search function can be used to search for a word or a sentense in the timeXtender meta model. This includes not only all standard objects and attributes within the model, such as field names or table names, but also the user defined documentation added to the meta model. The following example of a simple search should give you a pretty good idea about how to use this function to be even more productive with timeXtender.

A search example

In the following example, I will search the meta model for the word “customer”. I have selected the “Search in descriptions” option, which means that it will search both system attributes and user defined documentation. The search result will use the same icons as used in the tree views in timeXtender, thus it should be clear which found objects are tables, fields, dimensions etc.

Step 1 – Start the search dialog

 The search can be found on the Tools.Show Shortcuts menu option. This will show you that search can be accessed using the CTRL + F keyboard shortcut, which is how I am going to fire it up. The first time it will look like this


Step 2 – Search criteria

In this example I will search for a single word, ignoring case differences but including the descriptions added as documentation.


Step 3 – Search results

As you can see below, the search word was found in several objects including table name, field name, lookup field name, dimension and dimension level. It even found the cube “Sales”, that clearly does not have “customer” as part of the name. This was found because the description added to the cube (note the bold font), contains the search word.

To work with any object, either double-click it in the search results using the mouse or use the “Select in tree” button. This will select the object in the main dialog, without you having to scroll up and down the tree view.

Read Full Post »

%d bloggers like this: