This is the second post of a series dedicated to Viney@rd features. Find the first here.

Viney@rd is not a mere reporting tool. While the ability to feed each single cell in a worksheet is very important, all the model building process made through MasterBook.xls has a very high value added. The key point is that no database knowledge is required and data can be saved within models directly by Excel.

To this respect, the user must not care too much about codes, Viney@rd can "ingest and metabolize" almost everything. In particular, you can have a dimension with both numerical and alphanumeric codes.

Albeit you can save everything into the repository, the nature of what you save influences the outcome of the filters that you place on the query. The filters with" <"and" >" signs may not work as expected. If you have mixed alpha and numbers like 001, 002,003, ToBeAssigned, InAssignement etc, there is no choice other than comparing alphabetically. If you compare alphabetically, the system does not know that numbers are numbers, so they will come before letters and 10 will be before 9. The best way to avoid this is padding the numbers with 0s, that is 001 instead of 1, 013 instead of 13 etc., a rather tedious work.

Nonetheless, Viney@rd is smart enough to recognize dimensions, or attributes, which are entirely numeric, and compare them accordingly.

So, the user must not worry about things like defining objects as numeric or alpha, or padding the numbers to sort or filter them correctly .