How to best calculate n-level aggregation data based on (n-1)-level data (Oracle)
Sorry to refer to the question asked elsewhere, but since this seems a good fit to place it as well it would be cool to have some feedback on this from some experts
Thanks
PS: for convenience I'll post the current text in here:
In this answer (with all executable simplified and documented sample code + helpful comments)
http://stackoverflow.com/a/21939521/1915920
I did a kind of a trick there to calculate the last two rows of the following table:
<span class="pln">DESCR SUM <br/></span><span class="com">---------------------------------- ----------</span><span class="pln"><br/>money available </span><span class="kwd">in</span><span class="pln"> </span><span class="lit">2013</span><span class="pln"> </span><span class="lit">33233235.3</span><span class="pln"><br/>money spent </span><span class="kwd">in</span><span class="pln"> </span><span class="lit">2013</span><span class="pln"> </span><span class="lit">4253235.3</span><span class="pln"><br/>money bound </span><span class="kwd">to</span><span class="pln"> contracts </span><span class="kwd">in</span><span class="pln"> </span><span class="lit">2013</span><span class="pln"> </span><span class="lit">34333500</span><span class="pln"><br/>money spent </span><span class="lit">2013</span><span class="pln"> </span><span class="kwd">in</span><span class="pln"> </span><span class="pun">%</span><span class="pln"> </span><span class="kwd">of</span><span class="pln"> available </span><span class="lit">12</span><span class="pln"><br/>money bound </span><span class="lit">2013</span><span class="pln"> </span><span class="kwd">in</span><span class="pln"> </span><span class="pun">%</span><span class="pln"> </span><span class="kwd">of</span><span class="pln"> available </span><span class="lit">103</span>