[Mondrian] Cube creation

Haridasan T haridasan.t at gmail.com
Fri Dec 12 23:37:30 EST 2008


This cube refers an oracle table
u need to crate a table in oracle

or change connection etc as per ur setup


On 12/13/08, Julian Hyde <jhyde at pentaho.com> wrote:
>
>
>
>   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
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20081213/81594a9d/attachment.html 


More information about the Mondrian mailing list