HFM cell line item details fact table

You can view the column names and data types for the Hyperion Financial Management (HFM) cell line item details fact table.

The data type is listed for SQL Server, DB2, and Oracle data targets.

The order of the DIMNAME1 - DIMNAMEn columns is determined by the Sort column value of the Column Selection window.

The HFM cell line item details fact table has the following columns with the following descriptions and data types:

DIMNAME1 - DIMNAMEn

DIMNAME1 - DIMNAMEn is the name of the columns 1 - n selected to be exported. If Use Member Names is selected, the column values are member names that correspond to the CHILD field of the respective dimension table. If Use Member ID Reference is selected, the column values are the IDs that correspond to the ID field of the respective dimension table.

varchar(255) or varchar2(255) or int or number

The data type depends on the setting for the Fact Table Member Values option. For more information, see Star schema options.

DATA

Contains the line item data. The precision of this field (x) is based on the Data Precision option of the Selection used to create the table.

numeric(14,x) or number(14,x)

DESCRIPTION

The description of the journal item.

varchar(80) or varchar2(80)

AUDITID

The AUDITID references a record in the fact audit table. This table has the same name as the fact table, plus a suffix of _AUDIT.

int or number