[Mondrian] Cube creation

Haridasan T haridasan.t at gmail.com
Fri Dec 12 13:59:40 EST 2008


TRY WITH Small cubes
se  attached examples




On 12/12/08, ~rohit~ <mrtihor at yahoo.com> wrote:
>
> Hi,
>
> I am new to this OLAP concepts and this is my first trial with mondrain,
> created a cube as follows,
>
> <Schema name="market">
>        <Cube name="sales" cache="true" enabled="true">
>                <Table name="t_monthly_data" schema="public">
>                </Table>
>                <Dimension type="StandardDimension" foreignKey="code_file"
> name="Code">
>                        <Hierarchy name="New Hierarchy 0" hasAll="true"
> allMemberName="All Codes" primaryKey="code"
> primaryKeyTable="t_outlet_master">
>                                <Table name="t_outlet_master"
> schema="public">
>                                </Table>
>                                <Level name="Code" column="code"
> type="Numeric" uniqueMembers="true" levelType="Regular"
> hideMemberIf="Never">
>                                </Level>
>                        </Hierarchy>
>                </Dimension>
>                <Dimension type="StandardDimension" foreignKey="particular"
> name="Particular">
>                        <Hierarchy name="New Hierarchy 0" hasAll="true"
> allMemberName="All Particluar" primaryKey="Particular"
> primaryKeyTable="t_sku_master">
>                                <Table name="t_sku_master" schema="public">
>                                </Table>
>                                <Level name="Particular" column="Particular"
> type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
>                                </Level>
>                        </Hierarchy>
>                </Dimension>
>                <Measure name="Value Of Sales" column="val_of_sales"
> datatype="Numeric" formatString="" aggregator="sum" formatter="#,###"
> visible="true">
>                </Measure>
>        </Cube>
> </Schema>
>
> 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'
>
> What am i doing wrong.
>
> Thanks,
> Rohit
>
>
>      Add more friends to your messenger and enjoy! Go to
> http://messenger.yahoo.com/invite/
>
>
> _______________________________________________
> 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/a13bcb75/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Batch tracability.jsp
Type: application/octet-stream
Size: 825 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20081213/a13bcb75/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Batch tracability.xml
Type: text/xml
Size: 734 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20081213/a13bcb75/attachment.xml 


More information about the Mondrian mailing list