hfm documentation 9

14
HFM DOCCUMENTATION System 9 supports these features. It is web based application that delivers global collection, loading, extracting, financial consolidation, reporting and analysis in one highly scalable solution. Features of HFM:- * Powerful multidimensional analysis identifies and reports new sources of profitability and Cash flow at corporate, cost center, product, brand, customer and channel levels. * Flexible "what if" scenario management features dynamically consolidates and reports all financial budgets, forecast and plans. * High volume, preformatted repots deliver timely, accurate financial information for internal management and external regulatory. * Customizable and extensible application solves your issues quickly and cost effectively, Using industry standard tools. * Architected for the web so users can easily and securely access global financial information from any location, using standard web browser. Dimensions:- Data in HFM stored across these dimensions. Dimensions are parameters or pointers to an amount. There are 12 dimensions. 1)Scenario 2)Entity 3)Account 4)Period 5)Year 6)Value 7)View 8)Intercompany 9)Custom1 10)Custom2 11)Custom3 12)Custom4. Scenario:- It represents set of data such as Budget, actual or forecast. Entity:- It represents the Organizational structure of a company.

Upload: anilpavanraj

Post on 07-Aug-2015

92 views

Category:

Documents


6 download

TRANSCRIPT

Page 1: Hfm Documentation 9

HFM DOCCUMENTATION

System 9 supports these features. It is web based application that delivers global collection, loading, extracting, financial consolidation, reporting and analysis in one highly scalable solution.

Features of HFM:-

* Powerful multidimensional analysis identifies and reports new sources of profitability and Cash flow at corporate, cost center, product, brand, customer and channel levels.

* Flexible "what if" scenario management features dynamically consolidates and reports all financial budgets, forecast and plans.

* High volume, preformatted repots deliver timely, accurate financial information for internal management and external regulatory.

* Customizable and extensible application solves your issues quickly and cost effectively, Using industry standard tools.

* Architected for the web so users can easily and securely access global financial information from any location, using standard web browser.

Dimensions:-

Data in HFM stored across these dimensions. Dimensions are parameters or pointers to an amount. There are 12 dimensions.

1)Scenario 2)Entity 3)Account 4)Period 5)Year 6)Value 7)View 8)Intercompany 9)Custom1 10)Custom2 11)Custom3 12)Custom4.

Scenario:-

It represents set of data such as Budget, actual or forecast.

Entity:-

It represents the Organizational structure of a company.

Page 2: Hfm Documentation 9

Account:-

It represents hierarchy of natural accounts.

Period:-

It represents time periods such as quarters and months.

Year:-

It represents calender year for data.

Value:-

It represents different types of values stored in application.

View:-

It represents various modes of calender intelligence.

Intercompany:-

It represents all intercompany balances that exits for account b/w two organizations.

Custom Dimensions:-

Four custom dimensions are available for analysis of detailed data.(ex-custom1,custom2..)

Consolidation:-

Aggregating the data from child account in an entity to parent account.

Consolidation Types and Methods:-

Types:

1. Legal Consolidation

2. Geographical Consolidation

Page 3: Hfm Documentation 9

3. Consolidation by entity

Methods:

1. Consolidate

2. Consolidate all

3. Consolidate all with data

Consolidate:-

Only entities that require logic or consolidation are updated by the system.

Consolidate All with Data:-

It is available for any parent entity regardless of its status.NODATA are skipped.

Consolidate All:-

Any Parent entity regardless of its status.NODATA are also consolidated.

HFM Architecture:-

* End User: End Users connect via a web browser or microsoft office.

* Web Layer: The web layer provides the web content to end users.

* Application Layer: It performs all application settings processing for HFM.

*Database Layer: The data base layer stores the data, metadata, web components etc.

Note: By using URL we connect the client layer to application layer.

By using IIS we connect Browser client to application layer.

-->How to access Windows client?

Select start > programs > Oracle EPM system > Financial management > Financial management

Page 4: Hfm Documentation 9

-->How to access workspace client?

Select start > programs > Oracle EPM systems > Workspace > Workspace URL

-->How to access shared services?

Select start > programs > Oracle EPM system > Foundation services > Shared services consol

Application Administration:-

* Define Application Profile

* Creating Application

* Managing Application Security

* Managing Metadata

* Load data, data forms, member lists, rules, and journals to the application.

Define Application Profile:

It defines the Years, periods and views available in the application.

In Windows client select define application profile.

Process:

Select profile > Enter languages > define calender > Edit frequencies >

Edit periods > Save profile

Page 5: Hfm Documentation 9

Create Application:-

Through web enter into workspace.

Process: Navigate > tasks > consolidation administration > create application

Through windows client select create application.

Page 6: Hfm Documentation 9

Assign Security:-

Before assigning security we register the application.

Register:

In workspace we register the existed application.

Process: Navigate > administrator > classic application administrator > consolidation administration > register application

After the registration of application we assign users, roles and security in shared services.

Users:

Process: user directories > Navigate directory > user

Assigning Role:

Process: Application group > default application group > assign acess control

5 types of assign access controls is there.They are:

1) None: No access - User does not see that item exists.

2) Metadata: Sees that the dimension member exists but cannot view/edit data.

Page 7: Hfm Documentation 9

3) Promote: View data for dimension member and promote/reject in process control.

4) Read: View data for the dimension member but not promote/reject in process control.

5) All: Modify the item and promote/reject in process control.

Security:-

Process: select users and groups > select classes > assign access > security report.

Creating Metadata:-

In windows client select manage metadata.

This section focuses on building the entities, accounts, custom dimensions, scenarios, currencies and application settings.

Page 8: Hfm Documentation 9

Accounts:

It defines account type.

Mandatory Attributes: account type, security class, default parent.

Currencies:

It defines currency type.

Mandatory Attributes: currency, scale, translation operation.

Entity:

It defines the location of transaction.

Mandatory Attributes: define currency, default parent.

Scenario:

It defines data type.

Mandatory Attributes: default frequency, default view, security class, support process management, default frequency for IC transaction, default parent, zero view for non adjustment, zero view for adjustment.

Custom-1:

It defines the customers.

Mandatory Attributes: security class, default parent.

Custom-2:

It defines products.

Mandatory Attributes: security class, default parent.

Custom-3 and Custom-4:

If we have any other data we use these two customs.

Page 9: Hfm Documentation 9

Application Settings:

Application settings are not a hierarchy – not even presented as such – but rather they control. How the application works and enable some of the functionality.

Mandatory Attributes: default currency, default rate for balance accounts, default rate for flow accounts, ICP Entities agg weight, default value for active, validation account, consolidation rules, noad security, max cell text size, max doc attachments, max number doc attachments.

Consolidation Method:

Consolidation methods are used to provide settings for various types of consolidation that Address various ownership requirements.

Mandatory Attributes: consol method, to percent control comp, to percent control, percent consol.

Load Metadata:-

Load the data. If any errors are there those errors are shown in log file.Then we modify the errors and reload that data.

In windows client select load metadata.

In workspace first open the application for load metadata, extract metadata, data forms, data grids etc.

Application opening process:

Select Navigate > Application > consolidation > select application

Load metadata process:

Select tasks > load tasks > load metadata

Page 10: Hfm Documentation 9

Extract Metadata:-

It typically extracts all metadata options into a single file, make the changes and then do replace loads.

In workspace select tasks > extract tasks > extract metadata

Explore Metadata:-

After loading metadata we can see all the data in explore data and also enter the values regarding point of view selection.

In windows client select Explore data.

Page 11: Hfm Documentation 9

Database Management:-

In this any modification is required for data we have to modify in this. If you want copy the data from one scenario to other scenario and clear data also done in this database management.

Page 12: Hfm Documentation 9

Member list:-

It is used to see the data and modify the data. It is done in explore data. Member list is available for all dimensions.

There are 2 types of member lists.

1) System define member list

2) User define member list

User define member list

|

-------------------------

| |

Static member Dynamic member

List list

System define member list is a default option.

Member list is created by administrator. It has two subroutines.

1) Enum member list.

2) Enum member inlist.

Enum member list: It is used to create the member list.

Enum member inlist: It is used to add (or) delete a member in existed list.

Journals:-

If any modification required in accounts, that modification was done with posting journals.

In workspace we do journals.

Process:

Select tasks > Journal tasks > process journals

Page 13: Hfm Documentation 9

Recurring Journal:-

Some Journals we use repeatedly. So, for that purpose, we will create recurring templates. By using the recurring templates, we will create recurring Journals.

Auto Reserving Journal:-

If we create a journal as Auto Reversing Journal, the journal will post in the next period by reversing the Debit and Credit.

Data forms and Data grids:-

It is used to consolidation (or) reporting the data by security in HFM.

In workspace select tasks > data tasks > data forms (or) data grids

(OR)

Administrator > manage documents > data forms (or) data grids

Data forms have so many advantages than data grids.

Page 14: Hfm Documentation 9

Data Forms Data Grids

1) Point view is available. 1) Point view is available.

2) Import & Export to ex format 2) Import & Export to ex format

is possible. is not possible.

3) Print format is possible. 3) Print format is not possible.

4) Add (or) delete changes is 4) Add (or) delete changes is

possible. Not possible.

Process Control:-

Once a user loads data (or its loaded for them) and intercompany balances have been reconciled and adjustments have been made, the data is ready for consolidation into the company’s numbers.

Process: tasks > consolidation administration > data tasks > process control. In process control we can follow these steps.

With the status now all good, we can promote. Below uses the toolbar to find Promote.

Start > submit > approve > publish.