[Mondrian] MDX issue : complex scenario for filtering

[Jônatas Wingeter Rodrigues]

Hi all,

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.

So,

I have a cube in 3 dimensions: Network element, Time and KPI (Measure). We
have been used MDX to make queries to this
cube using a MDX parser API (which uses Olap4j under the table). This parser
is a Fluent Interface responsible to facilitate
the query generation through a concise and simple API.

As well, I need to implement filtering, which includes: Filter by Element,
Measure and Time.
I've been blocked on Time issue. I can't understand completely the Time
filtering in MDX.

1) : operator.

When I try to run this query:
WITH MEMBER [Time].[Filter] AS
'Aggregate({[Time].[2006]:[Time].[2010]})'
The mondrian throws an exception of: object member not found (in this case,
the 2006 object).
I would like to know how to ignore this. I want to make filtering crossing
many times and not necessary all the time objects
shall be there. Ex: 2006 -> OK, 2007 -> Missing - 2008 -> OK, 2009 -> OK. If
I make the filtering between 2006 and 2009,
mondrian throws such error. What is the best way to avoid this? Try to
disable member validation or change the query?

2) Parallel period:

As I checked in documentation, the function parallel allows to gather member
that are cousin among them.
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)
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.
The hierarchy of Time permits to get down from Year to Hour: Year, Month,
Week, Day, Hour.

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.
I have tried aggregate, PeriodsDate, YTD, unsuccessfully.

I hope that some of you can help me on this challenger.

Since know, I thank you only to be patient on this long reading.

Regards,

Jônatas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100922/1e1ef75d/attachment.html