How can i load value from MySQL?

      How can i load value from MySQL?

      hi all

      happy new year!

      I have a problem with mysql to palo.

      How can i load value from mysql table to palo

      ex: mysql 'mypalo' table

      pattern_ID doc_ID transaction_id
      0 123 1
      0 123 2
      0 123 3
      0 123 4
      0 123 5
      0 123 6

      palo
      database: nes
      dimensions and global subsets: product
      cubes: sale\product

      i use 'Extract' and

      SQL-Query

      1. SELECT `pattern_ID`, `doc_ID`, `transaction_id`FROM `mypalo` WHERE `transaction_id` = 6


      it worked and get

      `pattern_ID` `doc_ID` `transaction_id`
      0 123 6

      how does i load `0` `123` and `6` as `value` to product?

      thanks
      best regards,

      /dr1234