Importing Data from a File
At this point in the example, you have entered and stored some data in the Current Year Budget cube for the United States, in January. The next exercise will populate the remaining detail Regions members by importing January data contained within a sample text file included with the PowerOLAP® application. This file, Qsdata.txt, is located in the C:\Program Files (x86)\PowerOLAP\Examples subdirectory (assuming that the C drive is where your Program Files directory is located) created during the installation process.
[Note that importing text data, along with entering data via a Slice or an Excel worksheet are two methods to bring data into PowerOLAP®. Another method is to dynamically integrate Meta and Fact Data from a relational database, via OLAP Exchange®.]
1. With the QS Database opened, go to Data tab, then in the Import control group select the and then Fact Data icon or Import Data command.
The Import Data dialog box is displayed.
2. Click Browse to select the file to import and select the QSdata.txt file from the … \PowerOLAP\Examples subdirectory.
3. Click Open. You are returned to the Import Data dialog box.
4. Select a delimeter. In this case, keep Tab as the selected Delimiter.
5. Click OK.
6. Click on the Months Dimension. The message box below appears.
7. Click Yes to confirm that you want to continue.
8. Leave Set option as the Fact Data import method select.
9. Click OK to begin the import process.
You will receive the following prompt indicating that the import was successful:
10. Click OK. You are returned to the Accounts by Months slice.
11. From the PowerOLAP ribbon go to Slice tab then in the Slice control group click on the Open Slice command to access the Open Slice dialog box.
12. Select the appropriate cube from the dropdown (i.e., Current Year Budget).
13. Select the Regions by Accounts slice and click OK.
Alternatively, you may simply double click on the appropriate saved slice.
14. Click on the File icon and select Save Database command to save changes you made both to data and to Slice views.
15. Close the Regions by Accounts slice, leaving open the Accounts by Months slice.