<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Haven't tried CsvDBTestCase yet, was hoping it was something I was doing wrong with inline tables. :) I'll give it a shot today.<div><br></div><div>Thanks,</div><div>Pat</div><div><br><div apple-content-edited="true">On 2012-03-21, at 8:24 PM, Julian Hyde wrote:</div><div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">There are a few places where an InlineTable cannot be used in place of a regular table. (Not that it shouldn't -- but it's never been implemented.) I can well believe that this is one of those.<div><br></div><div>Sorry! I know it would have made it easier to write the test. InlineTable support will be better in mondrian-4, by the way.<br><div><br></div><div>Did you try extending CsvDBTestCase? That allows you to create a table at the start of the test, and drop it at the end.<br><div><br></div><div>Julian</div><div> <br><div><div>On Mar 21, 2012, at 1:30 PM, Patrick Leckey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Julian,<div><br></div><div>I am working with TestContext.create() as you suggested, and am trying to accomplish this with an inline table (since I need data not in the FoodMart SQL). It looks promising, but I the test is failing with the following error:</div><div><br></div><div><pre style="white-space: pre-wrap; word-wrap: break-word; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(0, 0, 0); font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); ">Mondrian Error:Internal error: no table 'store_management' found in hierarchy [Store Managers.Manager]</pre><div><br></div></div><div>Which seems to be failing in HierarchyUsage.findJoinTable() (specifically the exception thrown at line 429). Are inline tables not able to be used this way?</div><div><br></div><div>I have defined the cube I am adding with TestContext.create() as follows:</div><div><br></div><div><div><Cube name="ClosureTest"></div><div><span class="Apple-tab-span" style="white-space:pre">        </span><InlineTable alias="store_management"></div><div><span class="Apple-tab-span" style="white-space:pre">                </span><ColumnDefs></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><ColumnDef name="store_id" type="Numeric"/></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><ColumnDef name="employee_id" type="Numeric"/></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><ColumnDef name="supervisor_id" type="Numeric"/></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><ColumnDef name="manager_rank" type="Numeric"/></div><div><span class="Apple-tab-span" style="white-space:pre">                </span></ColumnDefs></div><div><span class="Apple-tab-span" style="white-space:pre">                </span><Rows></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><Row></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="store_id">2</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="employee_id">29</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="supervisor_id">22</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="manager_rank">1</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span></Row></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><Row></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="store_id">3</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="employee_id">30</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="supervisor_id">22</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="manager_rank">2</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span></Row></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><Row></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="store_id">4</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="employee_id">15</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="supervisor_id">5</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="manager_rank">3</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span></Row></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span><Row></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="store_id">5</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="employee_id">12</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="supervisor_id">5</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                                </span><Value column="manager_rank">4</Value></div><div><span class="Apple-tab-span" style="white-space:pre">                        </span></Row></div><div><span class="Apple-tab-span" style="white-space:pre">                </span></Rows></div><div><span class="Apple-tab-span" style="white-space:pre">        </span></InlineTable></div><div><span class="Apple-tab-span" style="white-space:pre">        </span></div><div> <Dimension name="Store Managers" foreignKey="store_id"></div><div> <Hierarchy hasAll="true" allMemberName="All Managers"</div><div> primaryKey="store_id" primaryKeyTable="store_management"</div><div> name="Manager"></div><div> <Table name="employee"/></div><div> <Level name="Employee Id" type="Numeric" uniqueMembers="true"</div><div> column="employee_id" parentColumn="supervisor_id"</div><div> nameColumn="full_name" nullParentValue="0"></div><div> <Closure parentColumn="supervisor_id" childColumn="employee_id"></div><div> <Table name="employee_closure"/></div><div> </Closure></div><div> </Level></div><div> </Hierarchy></div><div> </Dimension></div><div> </div><div> <Measure name="Rank" column="manager_rank" aggregator="min" formatString="Standard"/></div><div></Cube></div></div><div><br></div></div>_______________________________________________<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></div></div></div></div>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote></div><br></div></body></html>