Sample Data Files

About the sample data files

This topic contains two sample data files, one that loads information into Express database and metadata objects, and one that loads financial data into a financial data item. Both files have fixed-length fields.

FIle to load information into Express database and metadata objects

In this example, the data file loads values into the Express database and metadata objects associated with the Organization dimension. The Oracle Express Administrator Database Browser displays information for the Express dimension objects and for the Express variable that stores the Actual financial data item.

Note: These are the objects that you drag from the Database Browser window to the Express Object column in the Import Text Dialog box when you create the data loader program for this sample data file.

Dimension name and description

The following is the name and description of the dimension into which dimension values will be loaded.

Dimension value name variable

The following is the dimension value name variable into which dimension value names will be loaded.

Row label variable

The following is the row label variable into which dimension value row labels will be loaded.

Column label variable

The following is the column label variable into which dimension value column labels will be loaded.

Self-relation

The following is the self-relation into which the parent and child relationships between values of the Org dimension, which create the structure of a hierarchy, will be loaded.

One-to-many relation

The following is the name and description of the relation into which the one-to-many relationships between values of the Org dimension and another Financial Analyzer dimension, which create the structure of an attribute, will be loaded.

Sample data file

The following is the sample data file.

Dimension Value	Dimension Value Name	Dimension Value Row Label	Dimension Value Column Label	Hierarchy Relation	Attribute Relation
C01100	01100-Resource Rollup	Resource Rollup	Resource Rollup	C01PT	NA
C01110	01110-Facilities Resources	Facilities Resources	Facilities	C01100	GANDA
C01120	01120-Machine Resources	Machine Resources	Machine	C01100	GANDA
C01130	01130-Comp and Comm Resources	Comp and Comm Resources	Comp & Comm	C01400	GANDA
C01400	01400-Sales Rollup	Sales Rollup	Sales Rollup	C01PT	NA

File to load financial data into a financial data item

In this example, the data file references the values in the Express database associated with the Organization, Line, Product, and Time dimensions. It then loads financial data into a financial data item called Actuals.

Note: These are the objects that you drag from the Database Browser window to the Express Object column in the Import Text dialog box when you create the data loader program for this sample data file.

The Oracle Express Administrator Database Browser displays information for the Express dimension objects and for the Express variable that stores the Actuals financial data item.

Object name and description: Organization dimension

The following is the object name and description of the Organization dimension, which is referenced when data is loaded into the Actuals financial data item.

Object name and description: Line dimension

The following is the object name and description of the Line dimension, which is referenced when data is loaded into the Actuals financial data item.

Object name and description: Product dimension

The following is the object name and description of the Product dimension, which is referenced when data is loaded into the Actuals financial data item.

Object name and description: Time dimension

The following is the object name and description of the Time dimension, which is referenced when data is loaded into the Actuals financial data item.

Object name and description: Actuals variable

The following is the object name and description of the Actuals variable, into which financial data for the Actuals financial data item will be loaded.

Sample data file

The following is the sample data file.

Organization Dimension Values	Line Dimension Values	Product Dimension Values	Time Dimension Values	Actuals Data Values
C01100	A6100	PPT	JAN00	2207272.65
C01100	A6100	PPT	FEB00	2382589.36
C01100	A6100	PPT	JAN00	502889.92
C01100	A6100	PPT	FEB00	542832.88