<div>TRY WITH Small cubes</div>
<div>se attached examples</div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 12/12/08, <b class="gmail_sendername">~rohit~</b> <<a href="mailto:mrtihor@yahoo.com">mrtihor@yahoo.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<br><br>I am new to this OLAP concepts and this is my first trial with mondrain, created a cube as follows,<br>
<br><Schema name="market"><br> <Cube name="sales" cache="true" enabled="true"><br> <Table name="t_monthly_data" schema="public"><br>
</Table><br> <Dimension type="StandardDimension" foreignKey="code_file" name="Code"><br> <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="All Codes" primaryKey="code" primaryKeyTable="t_outlet_master"><br>
<Table name="t_outlet_master" schema="public"><br> </Table><br> <Level name="Code" column="code" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"><br>
</Level><br> </Hierarchy><br> </Dimension><br> <Dimension type="StandardDimension" foreignKey="particular" name="Particular"><br>
<Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="All Particluar" primaryKey="Particular" primaryKeyTable="t_sku_master"><br> <Table name="t_sku_master" schema="public"><br>
</Table><br> <Level name="Particular" column="Particular" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"><br>
</Level><br> </Hierarchy><br> </Dimension><br> <Measure name="Value Of Sales" column="val_of_sales" datatype="Numeric" formatString="" aggregator="sum" formatter="#,###" visible="true"><br>
</Measure><br> </Cube><br></Schema><br><br>But when I try the following query,<br><br>Select [Value Of Sales] ON COLUMNS FROM sales, I get the following error ,<br><br>Mondrian Error:Failed to parse query 'Select [Value Of Sales] ON COLUMNS FROM sales'<br>
<br>Mondrian Error:Error while parsing MDX statement 'Select [Value Of Sales] ON COLUMNS FROM sales'<br><br>Mondrian Error:MDX object '[Value Of Sales]' not found in cube 'sales'<br><br>What am i doing wrong.<br>
<br>Thanks,<br>Rohit<br><br><br> Add more friends to your messenger and enjoy! Go to <a href="http://messenger.yahoo.com/invite/">http://messenger.yahoo.com/invite/</a><br><br><br>_______________________________________________<br>
Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br></blockquote>
</div><br>