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

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • 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.

      The 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.

      The post was edited 2 times, last by palophp ().