How can I translate a natural language question to an MDX query? I am researching Natural Language Processing (NLP) to develop an NL Question Answering system. The answering part is already done. So processing the question remains, along with the questions regarding the algorithms.
The final product should allow the user to ask a question in NL. The question then gets translated to an Multidimensional Expressions (MDX) query, which generates a script regarding the dimensions of the cube.
How can I translate a natural language question to an MDX query?
The outcome of the question is in the form of a calculation. For example

How many declarations were done by employee 1?

or

Give me the quantities for Sales.
You can use a component library which can help you to implement Natural language query builder in your application( the question part ) called Open Natural Language Processing Package
 ,  so you can definitely develop a module, by using existing modules of OpenNLP such as entity extraction, chunking and parsing.

According to wikipedia source   ; it points out that as of 2001, Q&amp;A applications typically includes "a question classifier module which determines the type of question and the type of answer," so "a multiagent question and answering architecture has been proposed, where each domain [or variable] is represented by an agent which tries to answer questions, taking into account its specific knowledge."

But it still need some effort to build a NLgenerators inline with databases , for the answer query and also is the link to help you on how you can work with Compositional Semantic Parsing on Semi-Structured Tables

Hope this can give you some insight.