Sometimes you are asked to display a quota target or some other non-aggregated number in a table. A member of the Dimensions community passed on a strategy that uses the Rot function to place a number in a table.
There are a few tools that you should always be using to help you with your Dimensions work this article is about the tool “WinDMSRun”. WinDMSRun helps you quickly export data via dms scripts withought having to write any code. The WinDMSRun tool comes with the Dimensions development library and if you have this installed you can find it in the following directory.
Recently we wrote and article on “How can I get the text for a category” and a comment was raised that it was not perhaps the best way and the fastest way to write that particular routine. The comments where well founded and raised an important topic in our minds as to how things should be written and the effect on performance that a badly written function could have on your script. This article takes the script and does some analysis to see just how slow it is.
In the scripting for mrInterview you can use the object IOM. This is a collection of all the properties of the current interview. Amongst the list of properties belonging to IOM there is a collection named “Banners”. In the routing of your intervew script (i.e. your MDD-file!) you can add elements to this collection. By doing this you just add a new banner to your interview screen. This banner will need to have a name and a text like:
There are a few tools that you should always be using to help you with your Dimensions work this article is about the tool “MDM Explorer”. MDMExplorer helps you look in detail at Metadata Documents ( MDD ). It will show you all the collections and properties of an MDD file and allow you to change some of the values stored in it. The MDM Explorer tool comes with the Dimensions development library and if you have this installed you can find it in the following directory.
to setup text to be displayed to the respondent after the interview has completed or when it has stopped. These can also be used to setup a redirect.
You can use a REFRESH meta tag as the text to force a redirect. For example, the following would redirect to this blog when the interview completes.
IOM.Texts.EndOfInterview = "<meta http-equiv='REFRESH' content='0; URL=https://www.SmarterDatacolection.com' />"
Setup different texts for
to redirect respondents differently based on the interview. For example, you might redirect respondents that failed quota to another survey or redirect respondents who answered a particular question to a particular page.
If you need to include an ampersand in your URL, then use the
construct for getting the & past the HTML validator in the HTML player. If you forget and use just &, you will see the HTML for the URL on your end page, rather than being redirected.ode
There are a few tools that you should always be using to help you with your Dimensions work this article is about the tool “DMQuery”. We can use DMQuery to look at data and see what information particular respondents have recorded, but it should also be noted that we can use DMQuery to edit data , get counts and even market research style table results.
When you write mrStudio scripts you will frequently need to create connection strings. To help you achieve this , and to help you not to have to remember all the properties that you may want to use , there is a database connection string builder tool inside of mrStudio to walk you through the process of building a string and getting you the correct connection information.
No mater what you do with dimensions you will almost definitely come across the “Datalink Properties Wizard”, this article shows you how to use it. In this article we are going to connect to the museum database that comes with the Dimensions Development Library. It can be found in the following directory.
You have your mrInterview system setup, but you are unsure if the SQL database is accessible to you. The first thing to do would be to talk to your IT guys and see what they have to say, if they say you should be able to connect then the quickest way for you to double check is to try and make the SQL connection. Ask them to provide you with the SQL login details ( name of server, user login and password ) and once you have this, you are ready to go.