+ "{[Measures].[Unit Sales]} ON columns,\n"
+ "{[Customers].[All Customers], [Customers].[Name].Members} ON rows\n"
+ "from [Sales]\n"
+ "where ([Store].[All Stores].[USA].[CA].[San Francisco].[Store 14], [Time].[1997].[Q1].[1])");
Level[] levels = smr.getHierarchy().getLevels();
Level nameLevel = levels[levels.length - 1];
// evaluator for [All Customers], [Store 14], [1/1/1997]
Evaluator context = getEvaluator(r, new int[] {0, 0});
// make sure that [Customers].[Name].Members IS in cache