[Mondrian] Cube creation

[Julian Hyde]

 But when I try the following query,

Select [Value Of Sales] ON COLUMNS FROM sales, I get the following error ,

Mondrian Error:Failed to parse query 'Select [Value Of Sales] ON COLUMNS
FROM sales'

Mondrian Error:Error while parsing MDX statement 'Select [Value Of Sales] ON
COLUMNS FROM sales'

Mondrian Error:MDX object '[Value Of Sales]' not found in cube 'sales' 

The problem seems to be with your MDX, not your schema. You should have
written
 
Select [Measures].[Value Of Sales] ON COLUMNS FROM sales

If you are an MDX newbie, take the time to learn the language. It isn't as
much like SQL as it looks.
 
Julian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20081212/e375bc02/attachment.html