Generating a text file

Chapter 6 Working with PDMs

Generating a text file

The Generate Cube Data feature allows you to generate one text file for each selected cube and each selected data source. The name of the generated file is a concatenation of the name of the cube and the name of the data source.

Each file contains the following fields:

Field	Details
Dimension	Lists the attributes of the cube
Member	Lists the attribute values
Data fields	Contains the values stored in the fact measures

The generated text file must be easily loaded in the OLAP database. You can customize the format of the generated text files from the Generate Cube Data dialog box.

Generation option	Description
Header	When selected, includes the name of the attribute at the beginning of the generated text file
Extension	Extension of the generated text file, you can choose between .txt and .csv
Separator	Separator used between columns
Delimiter	String delimiter
Encoding	Encoding format to use for generation. You should select the encoding format that supports the language used in your model and the database encoding format
Character Case	Defines the character case in the generated text file
No Accent	When selected, disallows the use of accents

To generate cube data:

In the multidimensional diagram, select Tools→Generate Cube Data.

The Generate Cube Data dialog box appears.

Define a destination directory for the generated file in the Directory box.

Select the generation options in the Options tab.

Select the cubes and data sources for which you want to generate a file from the different tabbed tabs in the Selection tab.

Click OK.

The generated files are stored in the destination directory you have defined.