[Mondrian] How to identify Dimensions of cube which are not selected in any axes yet

[Venkatesh U]

Hi,
  Could anyone suggest a good way to identify the Dimensions of cube which
are not selected in any axes yet.

i.e SELECT dim1 on columns,
     dim2 on rows
     from [CUBE1]
     where dim3

   Assume the cube has 5 dimensions, namely
   dim1,
   dim2,
   dim3,
   dim4,
   dim5

  After parsing the query, I would like to get the list of dimensions which
are not used in the query yet. So that I can get a list of dimensions which
can be presented in GUI and the selected value of those dimensions can be
added to the query. Thanks in Advance.


Thanks,
Venkatesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110103/16949dda/attachment.html