Recommending Multidimensional Queries.

Interactive analysis of datacube, in which a user navigates a cube by launching a sequence of queries is often tedious since the user may have no idea of what the forthcoming query should be in his current analysis. To better support this process we propose in this paper to apply a Collaborative Work approach that leverages former explorations of the cube to recommend OLAP queries. The system that we have developed adapts Approximate String Matching, a technique popular in Information Retrieval, to match the current analysis with the former explorations and help suggesting a query to the user. Our approach has been implemented with the open source Mondrian OLAP server to recommend MDX queries and we have carried out some preliminary experiments that show its efficiency for generating effective query recommendations.

• Type: Conference
• Year: 2009
• Where: DAWAK
• Authors: Arnaud Giacometti, Elsa Negre, Patrick Marcel
• Keywords: Computer Science, DAWAK 2009, MDX Queries, Mondrian OLAP Server, OLAP Queries