4 Replies Latest reply on Mar 14, 2008 1:32 PM by JChanowitz

    OLAP Data Grid

    JChanowitz
      Hi,

      I'm building a multidimensional cube that has multiple measures, and am trying to figure out how to provide my users with the ability to "slice and dice" by running multiple queries against the same cube. I may be getting greedy in terms of what the olap api can do, but do have the folllowing questions:

      1) Is it possible in the same query to both filter on members in non-displayed dimensions and use a non-default measure in the cells? I can do one or the other in the same query using the slicer axis, but not both.

      2) If I'm using a MAX or MIN aggegratror, is it possible to easily determine the tuple that populate a cell, or do I have to go back to my flat data and find the answer there?

      Any help would be greatly appreciated!