[Mondrian] Cube creation
~rohit~
mrtihor at yahoo.com
Fri Dec 12 10:22:16 EST 2008
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/
More information about the Mondrian
mailing list