[Mondrian] Evaluating an axis expression to used dimension members

Luc Boudreau lucboudreau at gmail.com
Thu Aug 25 09:25:43 EDT 2011


Bart,

If you want to evaluate a complex axis expression, composed of many levels
and MDX functions, I don't know of any other way than to execute the query
outright.

However, if you want to evaluate the members of a single level, it is
possible to do it without executing an MDX query. If you are using olap4j,
you can obtain the list of members of a level by doing Level.getMembers() =>
List<Member>. There is another way using the Mondrian internal code, but I
wouldn't recommend going down that road, as we reserve the right to change
it at anytime, thus potentially breaking your application.

Does this help you achieving what you want?

Luc

On Thu, Aug 25, 2011 at 4:20 AM, Pappyn Bart <Bart.Pappyn at vandewiele.com>wrote:

>  Hi,****
>
> ** **
>
> I am looking for a way to evaluate an axis expression (QueryAxis), to a
> list of used members.****
>
> ** **
>
> For example DrilldownLevel({[Store].[All stores]}) should evaluate to a
> list of store members.****
>
> ** **
>
> This should be able to happen before running the query (and wasting too
> much time), since I am writing a mdx preprocessor.****
>
> ** **
>
> Thanks,****
>
> Bart****
>
> _______________________________________________
> 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/20110825/cdc36284/attachment-0001.html 


More information about the Mondrian mailing list