...
Write an SQL statement that will be used to retrieve data from the database. The SELECT part of the SQL statement determines the columns you will have to map in the next step.
Source column mapping
Once you have finished setting your parameters you will have to To conduct the Source column mapping.
Mapping the data to columns is similar to importing excel and CSV files. The differences here are that you need to name your own cube and dimensions, because they need to be created if your data does not fit any of the already existing cubes.
When you need to import several columns as the same dimension attributes then click Show options and specify the following options:
...
mapping please visit Data mapping.
When you are finished mapping your data press the Start Import button.
...