[Mondrian] Presentation and doubt

Julian Hyde jhyde at pentaho.com
Fri Apr 17 15:39:11 EDT 2009


 

Diego Dimunzio  wrote: 

Julian,

Yes, you are right that post was based in your blog, It was the first link I
found today when was looking for an post about it.
Btw. I have some questions.
1-  Does someone have tried to use a member reader?
 According with the documentation you have to implement
"mondrian.rolap.MemberSource
<http://mondrian.pentaho.org/api/mondrian/rolap/MemberSource.html> " but
this interface use "mondrian.rolap.MemberCache" which is not a public
interface then you can't implement the method setCache (MemberCache cache) 
We discussed custom MemberReaders on the list on 2009/4/7. I couldn't find
the message in the archive, so I have attached the message. 


2-  I am trying to do something that I not sure if it's possible
I have a dimension which comes from the fact table and I added selection
criteria to filter out the result.  
There are some issues with table filters. One is
<http://jira.pentaho.com/browse/MONDRIAN-495>
http://jira.pentaho.com/browse/MONDRIAN-495, but you are probably seeing
another. (One change 5 years ago,
<http://p4webhost.eigenbase.org:8080/@md=d&c=6PU@2752?ac=10>
http://p4webhost.eigenbase.org:8080/@md=d&c=6PU@2752?ac=10, added 3 features
and didn't add tests or documentation for any of them. Since this feature is
not tested I am not confident that it works.) 
<Dimension name="Dname">
<Hierarchy hasAll="true" allMemberName="All Dname">
<Table name="Dtable">
     <SQL dialect="mysql"> Dtable .classification_name = 'Primary'</SQL>
</Table>
<Level name="Primary D" column="dname"/>
</Hierarchy>
</Dimension>
It works properly, Then I would like to have a measure like this
<Measure name="Actual" aggregator="sum" >
<MeasureExpression>
      <SQL dialect="mysql">case when Dtable.type=0  
Then Dtable.amount/CustomSqlfunction(Dtable.currencycode)
 else 0 end
      </SQL>
</MeasureExpression>
</Measure>
 
The measure works for all dimensions members due Mondrian add the dimension
filter in the query it makes, but in the total (the first hierarchy)
mondrian only use the raw measure without that filter, so the grand total is
wrong.
Do you know if there a way to make it work? 
 
Sounds like another issue with filters. I suggest you turn on SQL tracing
and find out which SQL statement against Dtable is being generated without
the WHERE clause. Post the results to this list. From the tracing we should
be able to figure out which mondrian code is generating the SQL statement
without including the filter.
 
Julian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/b78a0a58/attachment.html 
-------------- next part --------------
An embedded message was scrubbed...
From: "Julian Hyde" <jhyde at pentaho.com>
Subject: RE: Custom MemberReader?
Date: Tue, 7 Apr 2009 23:15:18 -0700
Size: 14443
Url: http://lists.pentaho.org/pipermail/mondrian/attachments/20090417/b78a0a58/attachment.mht 


More information about the Mondrian mailing list