<br><font size=2 face="sans-serif">If someone has any info that could point
me to the right direction (where/what to look, link, book, documentation,
...), I would be happy to learn. Currently I just don't have enough MDX
knowledge to solve this problem</font>
<br>
<br><font size=2 face="sans-serif">thanks very much</font>
<br>
<br><font size=2 face="sans-serif">regards, dejan</font>
<br>
<br><font size=2 face="sans-serif">p.s. sorry for posting from the wrong
address for the second time, it was not my intention</font>
<br>
<br><tt><font size=2>mondrian-bounces@pentaho.org wrote on 02.12.2008 10:00:15:<br>
<br>
> <br>
> Hi, <br>
> <br>
> I have a question, I hopse someone can help. <br>
> <br>
> I have "financial statement" cube with hierarchical financial
<br>
> positions and firms on rows and time period on columns. The only <br>
> measure is a value for each financial position, each firm and each
<br>
> time period. <br>
> <br>
> My quartal data is cumulative so the correct value for a year is the<br>
> value from the last quartal for which the data exists in fact table
<br>
> (I have future periods in time dimension). I have managed to get the<br>
> the correct value for a year (the "closing balance") but
the problem<br>
> is I don't need it for each level, only for a year level. The other
<br>
> levels should sum the values of their children. <br>
> <br>
> So for example the value for all years (for which data exists in <br>
> fact table) should be sum of year values, but the value for a year
<br>
> should be a value from the last quartal. <br>
> <br>
> How can I do this in mondrian schema or just in MDX? <br>
> <br>
> thanks very much <br>
> <br>
> regards, dejan_______________________________________________<br>
> Mondrian mailing list<br>
> Mondrian@pentaho.org<br>
> http://lists.pentaho.org/mailman/listinfo/mondrian<br>
</font></tt>