[Mondrian] Cube creation

~rohit~ mrtihor at yahoo.com
Fri Dec 12 10:22:16 EST 2008


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">
		<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">
				<Level name="Code" column="code" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
		<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">
				<Level name="Particular" column="Particular" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
		<Measure name="Value Of Sales" column="val_of_sales" datatype="Numeric" formatString="" aggregator="sum" formatter="#,###" visible="true">

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.


      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

More information about the Mondrian mailing list