Hi Jeff<br><br>Thanks!<br><br>I will talk with the cube designer to check this question. BTW, if I keep Time dimension including Hour, Do I couldn't generate those queries for hour, crossing all levels of Time? Or Does it implicates in technical limitation?<br>
<br>The big problem I'm having is about the first one: filter elements by Time period. I read the documentation about slicer and I'm<br>not sure how to solve it yet.<br><br>Any help is welcome.<br><br>Regards,<br>
<br>Jônatas<br><br><div class="gmail_quote">2010/9/23 <span dir="ltr"><<a href="mailto:jeff.s.wright@thomsonreuters.com">jeff.s.wright@thomsonreuters.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I meant a separate dimension for Hour (time of day). That should
allow you to filter all records from 2-3h AM or 5h-7h PM.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">--jeff</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>] <b>On Behalf
Of </b>Jônatas Wingeter Rodrigues<br>
<b>Sent:</b> Wednesday, September 22, 2010 5:44 PM<br>
<b>To:</b> Mondrian developer mailing list<br>
<b>Subject:</b> Re: [Mondrian] MDX issue : complex scenario for filtering</span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Hi Jeff<br>
<br>
Thank you for the answer.<br>
<br>
1)<br>
I have already tested the property to try to ignore invalid members, but it
didn't work for non existing object.<br>
<br>
2)<br>
What exactly do you meant in separate dimensions for day? Today, <b>Day</b> is
a Level in the Hiearchy <b>Time</b>. <br>
<br>
I wait your feedback and the others.<br>
<br>
Thanks!<br>
<br>
Jonatas</p>
<div>
<p class="MsoNormal">2010/9/22 <<a href="mailto:jeff.s.wright@thomsonreuters.com" target="_blank">jeff.s.wright@thomsonreuters.com</a>></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">1) Look at property
mondrian.rolap.ignoreInvalidMembersDuringQuery and see if that helps</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">2) Consider modeling time of day as a
separate dim rather part of the time dimension</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">--jeff</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-color: -moz-use-text-color;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>
[mailto:<a href="mailto:mondrian-bounces@pentaho.org" target="_blank">mondrian-bounces@pentaho.org</a>]
<b>On Behalf Of </b>Jônatas Wingeter Rodrigues<br>
<b>Sent:</b> Wednesday, September 22, 2010 4:04 PM<br>
<b>To:</b> <a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br>
<b>Subject:</b> [Mondrian] MDX issue : complex scenario for filtering</span></p>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Hi all,<br>
<br>
I'm new here and I'm starting with a complex scenario. Of course, I hope to
help guys here instead to be just a listener.<br>
<br>
So,<br>
<br>
I have a cube in 3 dimensions: Network element, Time and KPI (Measure). We have
been used MDX to make queries to this<br>
cube using a MDX parser API (which uses Olap4j under the table). This parser is
a Fluent Interface responsible to facilitate<br>
the query generation through a concise and simple API.<br>
<br>
As well, I need to implement filtering, which includes: Filter by Element,
Measure and Time.<br>
I've been blocked on Time issue. I can't understand completely the Time
filtering in MDX.<br>
<br>
1) : operator.<br>
<br>
When I try to run this query:<br>
WITH MEMBER [Time].[Filter] AS<br>
'Aggregate({[Time].[2006]:[Time].[2010]})'<br>
The mondrian throws an exception of: object member not found (in this case, the
2006 object).<br>
I would like to know how to ignore this. I want to make filtering crossing many
times and not necessary all the time objects<br>
shall be there. Ex: 2006 -> OK, 2007 -> Missing - 2008 -> OK, 2009
-> OK. If I make the filtering between 2006 and 2009,<br>
mondrian throws such error. What is the best way to avoid this? Try to disable
member validation or change the query?<br>
<br>
2) Parallel period:<br>
<br>
As I checked in documentation, the function parallel allows to gather member
that are cousin among them.<br>
I would like to make a filter on a set of elements in my cube, just by
selecting some hours of day (Ex: 2-3h AM, 5h-7h PM)<br>
crossing the entire Time members, which means: get the network elements whose
have records in such hours, in all days, between a start and end date.<br>
The hierarchy of Time permits to get down from Year to Hour: Year, Month, Week,
Day, Hour.<br>
<br>
These 2 things are my big problems. I have been facing these things during
these last 2 weeks, and I didn't figure out a good solution.<br>
I have tried aggregate, PeriodsDate, YTD, unsuccessfully.<br>
<br>
I hope that some of you can help me on this challenger.<br>
<br>
Since know, I thank you only to be patient on this long reading.<br>
<br>
Regards,<br>
<br>
Jônatas</p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
<br>_______________________________________________<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" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>