Data Management Notes

· Describe how to set up a data entry schedule.

In the Data Entry module create a new schedule.
Give the schedule an id and description.
Select one or two account lists to display on the schedule.

· Describe the steps needed to change the schedule's options, including default schedule and describe where to change the default schedule.

Schedule options can be changed on the Schedule Attributes dialog box. Default schedule options are changed in the same ways as any other schedule. The default schedule cannot be deleted but its attributes can be changed and it can be rename which has the same effect.

· Describe the purpose of Show Formulas.

This option displays formulas in the Data Entry module.

· Identify the effect of changing the format options when loading and extracting data.

Load Data Options

Option	Effect
Accumulate	Adds the values in the load file to the values already in an application.
Replace	Clears all existing values for the periods in the load file and then loads the values from the load file.
Merge	Clears existing values from the accounts and periods in the load file and then replaces them with the values in the load file.
Calculate Formulas	Runs chart methods when you load files.
Report Calculated Accounts	Tracks attempts to load data into calculated accounts.
Zero No Data	Converts missing data in the load file to zero values.
Load Error File	Sets the name of the .ERR report. The report name can be either the user ID of the person performing the data load or the name of the original load file, with an .ERR filename extension. The .ERR report contains data that could not be loaded. The ERROR.LOG file describes the errors that occurred during data load.

Extract Data Options

Option	Effect
Include Calculated	Includes calculated account values in extract file.
Include Global	Includes global account values in extract file.

Format Options

Option	Effect
Delimiter	Sets the character that separates data elements in a data files. Default is a comma(,).
Negative	Sets the character that indicates negative values. Can be any character except a period (.), a letter, or a number. If you use a left or right bracket negative values appear in brackets. Default is a minus sign (-).
Account	Sets the account conversion table for loading or extracting data.
Entity	Sets the entity conversion table for loading or extracting data.
Operation	Sets a mathematical operation to perform when loading or extracting data. Values are None, Multiply, Divide. Default is None.
By	Sets the value by which to multiply or divide values by when loading or extracting data.
Decimals	Sets the number of decimal places for extracting data. If you leave this box empty, the system uses the number of decimals in the chart of accounts. Valid values are Blank and 1 through 9. Default is Blank.
File Extension	Sets the file extension for load or extract files. Default is .DAT.
Scale	Sets scale for loading or extracting data. This overrides scales assigned to categories and entities. Valid values are None, 0 through 9. Default is None.
Suppress	Controls whether accounts with a value of zero or no data values are extracted.
Data View	Select a data view for the format. Valid Values Category, Periodic, Category-to-Date Default Category Note: If you select a View option other than the category default, your data can change permanently.
Error File Name	Controls whether the user ID or the name of the load file is the name of the .ERR file.
Extract Derived Values	Extracts derived data.
Require Checksum	Validates that the load file has not been changed since it was extracted.
Reset	Resets the options to their default settings.

· Given an ERROR.LOG exhibit resulting from loading data, identify what corrective steps need to be taken to clear the error.

This ERROR.LOG indicates that the file being loaded has changed since it was extracted.

(User: USER ) Data Load Execute on client.
(User: USER ) Selected Mode is Merge.
(User: USER ) Data Load Options = None.
(User: USER ) Selected Format is Default.
(User: USER ) Data Load Category Default Data View.
(User: USER ) Data Load: C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat started at 17:07:09 21/01/03.
(User: USER ) Loading data file C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat
(User: USER ) Data Load Category = actuals_current.
(User: USER ) Data Load Starting Period = 1, Ending Period = 1, Total Periods = 1.
(User: USER ) Error: Invalid Checksum
(User: USER ) File C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat Records Read : 1.
(User: USER ) File C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat Records Loaded : 0.
(User: USER ) Data Load: C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat completed at 17:07:09 21/01/03.
(User: USER ) Data Load Total Records Read : 1.
(User: USER ) Data Load Total Records Loaded : 0.
(User: USER ) Errors found during execution. Please check ERROR.LOG

This ERROR.LOG indicates that the file being loaded has records with errors.

(User: USER ) Data Load Execute on client.
(User: USER ) Selected Mode is Merge.
(User: USER ) Data Load Options =  None.
(User: USER ) Selected Format is Default.
(User: USER ) Data Load Category Default Data View.
(User: USER ) Data Load: C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat started at 17:20:39 21/01/03.
(User: USER ) Loading data file C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat
(User: USER ) Data Load Category = actuals_current.
(User: USER ) Data Load Starting Period = 1, Ending Period = 1, Total Periods = 1.
(User: USER ) Invalid Enterprise account sales2.
(User: USER ) File C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat Records Read   : 2.
(User: USER ) File C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat Records Loaded : 1.
(User: USER ) File C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat Error Records  : 1. Please check C:\Program Files\Hyperion Solutions\Databases\detail_all\Inbox\USER.ERR.
(User: USER ) Data Load: C:\Program Files\Hyperion Solutions\Databases\detail_all\Outbox\france.dat completed at 17:20:39 21/01/03.
(User: USER ) Data Load Total Records Read   : 2.
(User: USER ) Data Load Total Records Loaded : 1.
(User: USER ) Data Load Total Error Records  : 1.
(User: USER ) Errors found during execution. Please check ERROR.LOG and USER.ERR.

· Identify the file name and location that error files are written to when loading data.

The main error file, ERROR.LOG, is located in the application directory. The default location of the load error file, for example USER.ERR, is in the InBox directory.

· Given a list of tasks, identify those that are particular to only Data Entry or Database.

Data Entry Tasks

Calculate Formulas
Set Schedule Options

Database Tasks

Lock Data
Unlock Data
Lock Journal
Unlock Journal
Erase Data
Calculate Formulas
Set Database Options
Load Data
Extract Data
Extract Consolidation Detail
Clear Invalid Consolidation Detail
Run Dependant Consolidation Detail Report
Run Consolidation Detail Report
Run Entity Detail Report

· Describe how to restrict the Database view to lists of entities or accounts.

Create a list of the entities or accounts you want to work with.
Select View > Entity List or View > Account List in the Database module.

· Describe the default colors for input, calculated and consolidated data.

Data	Color
Input	White
Calculated CHART	Dark Green
Calculated DYNVIEWACCTS	Light Green
Consolidated	Yellow

· Describe what is available in Data Entry module.

In the Data Entry module you can:

Create new schedules
Edit existing schedules
Copy schedules
Delete schedules
Enter data in to one or more schedules
Calculate formulas
Add validated subaccounts

· Identify how to include DSM in the POV.

To store consolidation details in a category you must select the follow attributes:

Store Proportion and Elimination Detail (Application attribute)
Allow Proportion and Elimination Detail (Category attribute)
Store Contribution Detail (Entity attribute)

To view the consolidation detail in a category:

Select Edit > Point of View.
Select the Consolidation Detail tab
Select the consolidation detail you want to display
Click OK.

· Describe the pre-defined reports available.

Dependant Consolidation Detail Report - Can only be run for one account and normally for a parent entity.

1/23/03                                                                                                                          5:50 PM
                                                                                                                                        
                                                     Dependent Consolidation Detail                                                     
                                  Organization: main       Entity: top       Category: actuals_current                                  
                                                   Account: sales       PERIOD: Q1 03                                                   
                                     Scale: Default       Frequency: Quarterly       View: Periodic                                     
                                                                                                                                        
                                                                                                                                        
                                                                                                                                        
                                   Entity              Trans               Prop               Elim             ParAdj            Contrib
france                              1,000                625                625                                   100                725
uk                                  1,000              1,000              1,000                                   100              1,100
                                                                                                                                        
Total                                 N/A              1,625              1,625                                   200              1,825
                                                                 Page: 1

Consolidation Detail Report - Can be run for several accounts.

1/23/03                                                                                                                          5:44 PM
                                                                                                                                        
                                                      Consolidation Details Report                                                      
                                 Organization: main       Entity: france       Category: actuals_current                                
                                                     Parent: top       PERIOD: Q1 03                                                    
                                     Scale: Default       Frequency: Quarterly       View: Periodic                                     
                                                                                                                                        
                                                                                                                                        
                                                                                                                                        
                                   Entity              Trans               Prop               Elim             ParAdj            Contrib
sales                               1,000                625                625                                   100                725
costs                                -600               -375               -375                                                     -375
profit                                400                250                                                                            
                                                                 Page: 1

Entity Detail Report - Can only be run for one account.

1/23/03                                                                                                                                                        5:34 PM
                                                                                                                                                                      
                                                                         Entity Detail Report                                                                         
                                                       Organization: main       Entity: france       Parent: top                                                      
                                                  Account: sales       Category: actuals_current       PERIOD: Q1 03                                                  
                                                    Scale: Default       Frequency: Quarterly       View: Periodic                                                    
                                                                                                                                                                      
                                                                                                                                                                      
                                                                                                                                                                      
                                         Amount              Debit             Credit     Journal               Account                         Code                  
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Contribution                                725                                                                                                                       
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Parent Adjustment                           100                                                                                                                       
                                                               100                        parent_1              sales                                                 
                                               --------------------------------------                                                                                 
                                                               100                  0                                                                                 
Elimination                                                                                                                                                           
Proportional                                625                                                                                                                       
Translation                                 625                                                                                                                       
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
france                                    1,000                                                                                                                       
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
                                                                                Page: 1

· Identify the uses of the four modules available in LedgerLink.

Module	Use
Load to Hyperion Enterprise	Loads general ledger data into Hyperion Enterprise.
G/L Template Wizard	Creates templates which describe the external general files you what to load into Hyperion Enterprise.
Translation Builder	Creates mappings from external general ledger names and accounts to Hyperion Enterprise entities and accounts.
Translate & Load Profiles	Defines settings for loading external general ledger files into Hyperion Enterprise. The main settings are: General ledger file Enterprise load file G/L Template Wizard file Name translation table Account translation table Options such as scale and data view

· Identify where EOL might be seen when using the Template Wizard.

At the end of lines/records.

· Indicate constraints when using report formatted files. (e.g. header/footer length)

The headers, footers, and body must be the same size on all pages of the output file.

· Presented with an external entity or account list, identify if Translation builder can use these.

Entity list files are text files that contain a list of external entities. They have the following format:

ENTITY1,
ENTITY2,
ENTITY3,

Account list files are text files that contain a list of external accounts. They have the following format:

ACCOUNT1,
ACCOUNT2,
ACCOUNT3,

· Given an example of a scaling attribute, define the result.

Scale determines how Hyperion Enterprise loads data. If the scale is Thousands and you load the value 100, the system displays 100 but stores 100,000.

· Describe the lock and unlock concept.

You lock periods to prevent data changes and unlock periods if you want to make changes. Locked data can be consolidated which is useful if organisation structures change and parent entities need to be recalculated.