[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