<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Julian,<div><br></div><div>I just saw your recent commit in lagunitas about scenarios and I have 2 questions:<div><br></div><div>1) do we still have to manually define a scenario dimension / hierarchy (I see we have to have 1 hierarchy called "Scenario" in the code) in the schema? </div><div>In the old schema format we added something like:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>Dimension name='Scenario' foreignKey='time_id'<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>Hierarchy primaryKey='time_id' hasAll='true'<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>InlineTable alias='_dummy'<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>ColumnDefs<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>ColumnDef name='foo' type='Numeric'<span style="color: #c80000">/></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"></</span>ColumnDefs<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>Rows<span style="color: #c80000">/></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"></</span>InlineTable<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"><</span>Level name='Scenario' column='foo'<span style="color: #c80000">/></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"></</span>Hierarchy<span style="color: #c80000">></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Menlo; "><span style="color: #c80000"></</span>Dimension<span style="color: #c80000">></span></div></div><div><span style="color: #c80000"><br></span></div><div><font class="Apple-style-span" color="#c80000"><span class="Apple-style-span" style="color: rgb(0, 0, 0); ">I remember you talked about improved hanger dimension support in Mondrian 4?</span></font></div></div><div><font class="Apple-style-span" color="#c80000"><span class="Apple-style-span" style="color: rgb(0, 0, 0); ">It would be great if this were a property on the cube instead of introducing such a dummy dimension.</span></font></div><div><Cube scenarioEnabled="true"> and the rest would be automatic. Makes it easier for people to try it.</div><div><br></div><div>Also this hanger dimension seems to cause some troubles on the drill through (thats why we enable only either drillthrough or scenarios) because of the generated SQL</div><div><br></div><div><br></div><div>2) Whats your plan on improvements? We would be happy to work on this together and at least expose it nicely in saiku.</div><div>I think it would be easy to persist scenarios in our query files as well, by saving the cell's tuples and new values so it can be "applied" again.</div><div>Its a great feature and people seem to like it so we should take this to the next level and make it a real feature!</div><div><br></div><div><br></div><div>-Paul</div><div><br></div></body></html>