[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: Re: [Mondrian] Mixing aggregate functions on different levels of
From: Dejan.Gambin () coin ! hr
Date: 2008-12-03 10:06:06
Message-ID: OFEF8C45CC.FB1F7DE5-ONC1257514.00375E9C-C1257514.00377DD2 () pula ! hr
[Download RAW message or body]
This is a multipart message in MIME format.
This is a multipart message in MIME format.
--=_alternative 00377DCFC1257514_=
Content-Type: text/plain; charset="US-ASCII"
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
thanks very much
regards, dejan
p.s. sorry for posting from the wrong address for the second time, it was
not my intention
mondrian-bounces@pentaho.org wrote on 02.12.2008 10:00:15:
>
> Hi,
>
> I have a question, I hopse someone can help.
>
> I have "financial statement" cube with hierarchical financial
> positions and firms on rows and time period on columns. The only
> measure is a value for each financial position, each firm and each
> time period.
>
> My quartal data is cumulative so the correct value for a year is the
> value from the last quartal for which the data exists in fact table
> (I have future periods in time dimension). I have managed to get the
> the correct value for a year (the "closing balance") but the problem
> is I don't need it for each level, only for a year level. The other
> levels should sum the values of their children.
>
> So for example the value for all years (for which data exists in
> fact table) should be sum of year values, but the value for a year
> should be a value from the last quartal.
>
> How can I do this in mondrian schema or just in MDX?
>
> thanks very much
>
> regards, dejan_______________________________________________
> Mondrian mailing list
> Mondrian@pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
--=_alternative 00377DCFC1257514_=
Content-Type: text/html; charset="US-ASCII"
<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>
--=_alternative 00377DCFC1257514_=--
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic