Jedox 5.0.4 (5.1.4) - dfilter condition - where is my error?

      Jedox 5.0.4 (5.1.4) - dfilter condition - where is my error?

      Hello. I am using Jedox (Palo) 5.0.4 from sourceforge.

      I have a wrong behavior with /dimension/dfilter REST api query. I want to get subset of products and filter it by product category, years, months (subcube).

      condition=<>0, >0, <0, >0or<0, >0and<10000 - it works great

      condition=<4000, <=4000, >=0, <=0, ==0, >=0and<10000 - it works wrong, when I am using one of this conditions server ignores my subcube and returns all products that exists in db (I want to get only products from one ProductCategory, this condition is defined in subcube), why?

      This is example of my php code:

      Source Code

      1. palo_subset($connection, $databaseName, 'Products', 1, NULL,
      2. palo_dfilter(palo_subcube($coordinates), array("<", "4000"))
      3. );


      This code returns all exists elements from Products dimension and ignores subcube (where I set ProductCategory coordinate).

      Please help me.

      Post was edited 4 times, last by “palophp” ().

      I tested this condition in Jedox 5.1.4 also, condition=<4000 returns all elements from Products dimension and ignores subcube (where I set ProductCategory coordinate).

      Community, please help me, where is my error? How can I get products filtered by subcube and where sum <4000? This condition is not working, I cannot understand why.

      Post was edited 2 times, last by “palophp” ().