Filter support?

Anurag
2014-04-08
2014-04-08
  • Anurag

    Anurag - 2014-04-08

    Hi,

    Is the following type of query supported -

    SELECT {[Store Sales]} ON COLUMNS,
    TopCount(Filter([Store].[Store Name].Members,
    [Store].CurrentMember.Properties("Store Type") = "Small Grocery"),
    10,
    [Store Sales]) ON ROWS
    FROM [Sales]

    Thanks

    Anurag

     
    • pstoellberger

      pstoellberger - 2014-04-08

      Yes, look at the query package.

      QueryAxis.filter(<string>) can do the filter, and QueryAxis.limit(LimitFunction.TopCount, 10, <measure>) the topcount

      I believe filter is executed before topcount when the MDX is generated

      -Paul

      On Apr 8, 2014, at 12:28 PM, Anurag avagarwal@users.sf.net wrote:

      Hi,

      Is the following type of query supported -

      SELECT {[Store Sales]} ON COLUMNS,
      TopCount(Filter([Store].[Store Name].Members,
      [Store].CurrentMember.Properties("Store Type") = "Small Grocery"),
      10,
      [Store Sales]) ON ROWS
      FROM [Sales]

      Thanks

      Anurag

      Filter support?

      Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/olap4j/discussion/577988/

      To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

       

Log in to post a comment.