[Mondrian] Problem with dynamic roles extending MDXConnection

Luc Boudreau lucboudreau at gmail.com
Mon Jun 10 10:30:15 EDT 2013


Most of the time, when someone has that problem, it turns out that they had
forgotten to override one of the methods in Role or HierarchyAccess. I
would start by making sure that you got them all covered.

Good luck!

Luc


On Mon, Jun 10, 2013 at 10:26 AM, Xavier Gumara <xgumara at gmail.com> wrote:

> Luc, thank you for your time and help.
>
> I already asked the question on Pentaho's forums without any luck (
> http://forums.pentaho.com/showthread.php?142252-Custom-MDX-connection-to-dynamically-change-roles
> ).
>
> Answering your questions, the query is pretty simple:
>
> select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
>   NON EMPTY {[Markets].[All Markets]} ON ROWS
> from [SteelWheelsSales]
>
> and HierarchyAccess.getAccess() returns Access.CUSTOM when it gets called.
>
> What I am missing, I think, is where childrens of "All Markets" are being
> checked (since Access is CUSTOM and rollup policy is partial from the
> schema, I haven't change it). Currently the value returned by that query is
> 49.578 (only EMEA) but should be 4.923 (only Japan).
>
> Thank you,
> Xavier Gumara
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130610/cc159fd5/attachment.html 


More information about the Mondrian mailing list