I use Business Analytic 5 , I create connection to MYSQL and create datasource choose from database table and I move from table form left to right and select fact table
Name:  Screen Shot 2556-12-20 at 2.17.26 PM.jpg
Views: 19
Size:  20.9 KB

and next it haven't column of the table that select to join what's the problem ?
Name:  Screen Shot 2556-12-20 at 2.25.06 PM.jpg
Views: 17
Size:  16.7 KB


PS .I use phpmyadmin to create database and assign primary key and relation with in phpmyadmin already

Name:  Screen Shot 2556-12-20 at 2.29.04 PM.jpg
Views: 17
Size:  46.8 KB