Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4696

The result is wrong when using multiple dimension with in filter which including multiple filter value

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • v3.1.0, v3.0.1
    • None
    • None

    Description

      I have a cube with 17 dimensions, when I query from the cube using multiple dimension with in filter which including multiple filter value, the result is not correct. 

      But if i query the cube first, then filter outside the result in another query, the result is correct.

      Or if i add trim on the dimension when query the cube directly, the result is correct too.

      Till now, I do not find other cube have this question. I do not know why?

      I attach the snapshot of the query and result.

      Thank you!

      Attachments

        1. wrong.png
          57 kB
          fengwenduo
        2. correct01.png
          79 kB
          fengwenduo
        3. correct02.png
          69 kB
          fengwenduo
        4. orders_cube.json
          6 kB
          fengwenduo
        5. orders_model.json
          1 kB
          fengwenduo
        6. query_from_cube.sql
          0.7 kB
          fengwenduo
        7. test_data.sql
          9.22 MB
          fengwenduo
        8. order_cube_desc.json
          8 kB
          fengwenduo
        9. image-2020-08-31-15-56-22-255.png
          111 kB
          Zhichao Zhang

        Activity

          People

            Unassigned Unassigned
            fengwenduo fengwenduo
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: