Explore topic-wise InterviewSolutions in .

• Manual consolidation by using GRIDS.
• Consolidation using task AUTOMATION
• CUSTOM consolidation by using rules.

By USING RULES we can ACHIEVE it

By using rules we can achieve it

Relates to OWNERSHIP MANAGEMENT, it will arrived by the formula

PMIN = PCON-POWN

Percent of minority interst is EQUL to Percent of consolidation minus percent ownership.

Relates to ownership management, it will arrived by the formula

PMIN = PCON-POWN

Percent of minority interst is equl to Percent of consolidation minus percent ownership.

You can use the Data Audit feature to view data changes PERFORMED by users. You can filter the data changes by date RANGE, application server, user, and the dimension members of CELLS.

You can audit SCENARIO and Account members by setting the Enable Data Audit metadata attribute to Y for the scenarios and accounts to audit. To turn off auditing of Scenario and Account members, change the Enable Data Audit attribute to N.

You can use the Data Audit feature to view data changes performed by users. You can filter the data changes by date range, application server, user, and the dimension members of cells.

You can audit Scenario and Account members by setting the Enable Data Audit metadata attribute to Y for the scenarios and accounts to audit. To turn off auditing of Scenario and Account members, change the Enable Data Audit attribute to N.

• The CUSTOM top member for the ACCOUNT
• The SPECIFIED member, including all descendants, is VALID for the account

An APPLICATION profile contains LANGUAGE, calendar, frequency, and period INFORMATION for an application. You can USE a profile for more than one application. For each application that you create, you must specify an application profile.

You can not modify the application profile once it was created.

An application profile contains language, calendar, frequency, and period information for an application. You can use a profile for more than one application. For each application that you create, you must specify an application profile.

You can not modify the application profile once it was created.

Basically value dimension MEMBERS are inter-related with so many areas in HFM, but in brief talking about Entity Curr ADJ you can make any adjustments USING journals into this particular value dimension, here you can PERFORM caluclate and POSTING journals.

Basically value dimension members are inter-related with so many areas in HFM, but in brief talking about Entity Curr Adj you can make any adjustments using journals into this particular value dimension, here you can perform caluclate and posting journals.

Following are SYSTEM defined members for ICP dimension.

[ICP Top] SPECIFIES the top INTERCOMPANY member[ICP None] Specifies that no intercompany member is used
[ICP Entities] Specifies the entities that are designated for intercompany transactions

The System will automatically creates a ICP member when you select the IsICP attribute, see the below for your reference.

When you create an application, Intercompany PARTNER members are automatically created for the application. An ICP member is created for each Entity member for which the IsICP attribute is selected.

Following are system defined members for ICP dimension.

[ICP Top] Specifies the top intercompany member[ICP None] Specifies that no intercompany member is used
[ICP Entities] Specifies the entities that are designated for intercompany transactions

The System will automatically creates a ICP member when you select the IsICP attribute, see the below for your reference.

When you create an application, Intercompany Partner members are automatically created for the application. An ICP member is created for each Entity member for which the IsICP attribute is selected.

Data is STORED at the cells formed by the INTERSECTION of the members of the different dimension members in the SUB cube. All aggregations and calculations are performed on data in sub cubes retrieved into RAM on the application server. And I hope the data also be available in the database server.

Data is stored at the cells formed by the intersection of the members of the different dimension members in the sub cube. All aggregations and calculations are performed on data in sub cubes retrieved into RAM on the application server. And I hope the data also be available in the database server.

This setting specifies whether USERS of an APPLICATION see all dimension members or only those to which they have access. (MEANS we can see the metadata particular ENTITY only which we have RIGHT)

This setting specifies whether users of an application see all dimension members or only those to which they have access. (Means we can see the metadata particular entity only which we have right)

For different reporting PURPOSES we will create alternative hierarchies, in alternate hierarchy one member can be SHARED by more than one PARENT, but the DEFAULT parent will be only one.

For different reporting purposes we will create alternative hierarchies, in alternate hierarchy one member can be shared by more than one parent, but the default parent will be only one.

MEMBER ATTRIBUTES are differed from dimension to dimension; EVERY dimension member will be having importance to their RESPECTIVE areas.

Member attributes are differed from dimension to dimension; every dimension member will be having importance to their respective areas.

ENVIRONMENT LIKE DEVELOPMENT, TESTING , PRODUCTION.

Environment like Development, testing , production.

REPORTS are not specific it will be created as per CLIENT REQUIREMENTS

Example: Forecast book, Audit book in each book ALMOST balance sheet, INCOME statement, cash flow statements will be there.

Reports are not specific it will be created as per client requirements

Example: Forecast book, Audit book in each book almost balance sheet, income statement, cash flow statements will be there.

Goodwill in FINANCIAL statements arises when a company is purchased for more than the fair value of the identifi able NET ASSETS of the company. The difference between the purchase price and the sum of the fair value of the net assets is by definition the value of the "goodwill" of the purchased company. The ACQUIRING company must recognize goodwill as an asset in its financial statements and present it as a separate line item on the BALANCE sheet.

Goodwill in financial statements arises when a company is purchased for more than the fair value of the identifi able net assets of the company. The difference between the purchase price and the sum of the fair value of the net assets is by definition the value of the "goodwill" of the purchased company. The acquiring company must recognize goodwill as an asset in its financial statements and present it as a separate line item on the balance sheet.

1. All
2. METADATA
3. READ
4. PROMOTE
5. NONE

In HFM, we can create NUMBER of PLUG accounts, but BASED on requirement we will create the plug accounts for elimination process.

In HFM, we can create number of plug accounts, but based on requirement we will create the plug accounts for elimination process.

1. User authentication
2. TASK securities
3. Document securities (Data grids and FORMS, JOURNALS, REPORTS)
4. Data security

1. Create journal.
2. SUBMIT the journal.
3. RECEIVE APPROVAL or REJECT.
4. POST journal.

In HFM we have:

• ENTITY CURRENCY Adjs
• PARENT Currency Adjs
• Parent Adjs
• CONTRIBUTION Adjs

In HFM we have:

• Blue- Header cell
• Off White -An INPUT cell. You can manually enter or edit DATA.
• Light Yellow -Locked or derived cell
• Light Gray Text -No WRITE or Read access, or may be derived data
• Dark Yellow-Indicates one of these CONDITIONS:
• Cell data has been modified but has not been saved
• The input status is OK, but the status of the adjustment is not OK (CH, CN, or TR)
• Light Green -Allows allocations and derived data
• Dark Green -Read-only
• Orange -Invalid POV (Point of View) intersection

We have 10 ACCOUNT types in HFM.

Note : Please REFER Account DIMENSION in Metadata.

We have 10 Account types in HFM.

Note : Please refer Account dimension in Metadata.

Hyperion FINANCIAL Management is designed to operate as a multi tier system.

Client tier: The client tier contains the user interface and the ability to COMMUNICATE with the application tier. You can display data and metadata, enter data, and maintain metadata in this tier.

Web tier: The Web server tier contains the Web server. You can access the Web-enabled portions of Hyperion Financial Management in this tier. The Hyperion Financial Management Web client contains all FUNCTIONALITY available in the Windows client with the exception of security ADMINISTRATION.

Middle tier: The middle tier contains the domain intelligence and connections to the relational DATABASE.

Database tier: The data tier contains the relational database and all Hyperion Financial Management data and metadata.

Hyperion Financial Management is designed to operate as a multi tier system.

Client tier: The client tier contains the user interface and the ability to communicate with the application tier. You can display data and metadata, enter data, and maintain metadata in this tier.

Web tier: The Web server tier contains the Web server. You can access the Web-enabled portions of Hyperion Financial Management in this tier. The Hyperion Financial Management Web client contains all functionality available in the Windows client with the exception of security administration.

Middle tier: The middle tier contains the domain intelligence and connections to the relational database.

Database tier: The data tier contains the relational database and all Hyperion Financial Management data and metadata.

HFM DIRECTLY cannot take the data from ERP packages. So the data should be downloaded from ERP and loaded into Upstream tool LIKE FDM and ODI ETC. Then it should be mapped with HFM. And then load that into HFM.

HFM directly cannot take the data from ERP packages. So the data should be downloaded from ERP and loaded into Upstream tool like FDM and ODI etc. Then it should be mapped with HFM. And then load that into HFM.

HYPERION is dependent on services. MEANS services are to be STARTED in a SPECIFIED SEQUENCE. only

Hyperion is dependent on services. Means services are to be started in a specified sequence. only

A means of converting BALANCES from one currency to another via a third common currency. In Europe, this is the euro for member countries. For example, to convert from French franc to Italian lira, the common currency is defined as European euro. Therefore, in order to convert balances from French franc to Italian lira, balances are CONVERTED from French franc to European euro

Triangulation means doing translation from source currency to any currency other than destination currency.

Example:

If u have USD, EURO & YEN our source currency is USD & destination currency is YEN if u WANT to translate from USD to EURO, system will translate FIRST from USD to YEN & then YEN to EURO in reverse manner.

A means of converting balances from one currency to another via a third common currency. In Europe, this is the euro for member countries. For example, to convert from French franc to Italian lira, the common currency is defined as European euro. Therefore, in order to convert balances from French franc to Italian lira, balances are converted from French franc to European euro

Triangulation means doing translation from source currency to any currency other than destination currency.

Example:

If u have USD, EURO & YEN our source currency is USD & destination currency is YEN if u want to translate from USD to EURO, system will translate first from USD to YEN & then YEN to EURO in reverse manner.

Intercompany transactions are eliminated through PLUG ACCOUNT.

Steps:

• Create plug account in account dimension
• Tick the CHECK box called IS ICP in account dimension
• Tick the check box called IS ICP in ENTITY dimension
• Load the ICP rule file.
• Then automatically the difference between the Intercompany transactions will be transferred to plug account

Intercompany transactions are eliminated through plug account.

Steps:

Select Lock/Unlock IC Entities and Select Scenario, PERIOD YEAR and CLICK lock

Select Lock/Unlock IC Entities and Select Scenario, period year and click lock

A user-controlled mechanism that prevents CHANGES to data according to SPECIFIED CRITERIA, such as period or SCENARIO

A user-controlled mechanism that prevents changes to data according to specified criteria, such as period or scenario

• You cannot LOAD multiple CURRENCIES to ONE entity, because in attributes you can GIVE only one currency in Def Currency.

You cannot load multiple currencies to one entity, because in attributes you can give only one currency in Def Currency.

• BALANCED
• UN Balanced
• Balanced by ENTITY

As DIMENSION MEMBERS are added and deleted, the dynamic MEMBER list AUTOMATICALLY reflects the CHANGES by reapplying the user-defined criteria.

As dimension members are added and deleted, the dynamic member list automatically reflects the changes by reapplying the user-defined criteria.

It EXISTS in custom dimension

Switch SIGN for: It is TICKED to CHANGE

• ASSET to LIABILITY
• LIABILITY to ASSET
• EXPENSE to REVENUE
• REVENUE to EXPENSE

Switch type for: It is ticked to change

• ASSET to EXPENSE
• EXPENSE to ASSET
• LIABILITY to REVENUE
• REVENUE to LIABILITY
• BALANCE to FLOW
• FLOW to BALANCE

It exists in custom dimension

Switch sign for: It is ticked to change

Switch type for: It is ticked to change

Types:

1. Legal CONSOLIDATION
2. GEOGRAPHICAL Consolidation
3. Consolidation by entity

METHODS:

1. CONSOLIDATE
2. Consolidate all
3. Consolidate all with data

Types:

Methods:

TOLERANCE AMOUNT is small DISCREPANCIES in the amounts in INTERCOMPANY TRANSACTIONS.

Tolerance amount is small discrepancies in the amounts in Intercompany Transactions.

LCM means Life cycle management which is in SHARED SERVICES.

It is USED to migrate CONFIGURATION and artifacts. (NOTE: we cannot migrate data with LCM)

LCM means Life cycle management which is in shared services.

It is used to migrate configuration and artifacts. (Note: we cannot migrate data with LCM)

CAUSE: IC Period is not opened.

Expand Tasks and select IC Transaction Tasks. Select MANAGE IC Periods. From the SCENARIO drop-down list, select a scenario for the period. From the Year drop-down list, select a year for the period. Select the check box NEXT to each period that you want to open.

Cause: IC Period is not opened.

Expand Tasks and select IC Transaction Tasks. Select Manage IC Periods. From the Scenario drop-down list, select a scenario for the period. From the Year drop-down list, select a year for the period. Select the check box next to each period that you want to open.

The Intercompany PARTNERSHIP Dimension provides an EFFICIENT way to identify , report, and reconcile intercompany account differences. With the ability to view DETAIL transaction at any time, you can reconcile intercompany account differences frequently and thus minimize their IMPACT on the CLOSING cycle.

The Intercompany Partnership Dimension provides an efficient way to identify , report, and reconcile intercompany account differences. With the ability to view detail transaction at any time, you can reconcile intercompany account differences frequently and thus minimize their impact on the closing cycle.

HFM Web client -> ADMINISTRATION -> running TASKS -> click on the RED BUTTON

HFM Web client -> Administration -> running Tasks -> click on the Red button

Consolidate: only ENTITIES that require logic or consolidation are updated by the system.

Consolidate All with DATA: option 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.

Consolidate: only entities that require logic or consolidation are updated by the system.

Consolidate All with Data: option 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.

Adjustment is to CORRECT the data. It is DONE by Journals at VALUE dimension MEMBER ENTITY currency Adjs and Parent curr Adjs.

Adjustment is to correct the data. It is done by Journals at value dimension member Entity currency Adjs and Parent curr Adjs.

APPLICATION SETTINGS -> CONSOLIDATION RULES -> Y

Application Settings -> consolidation Rules -> Y

We migrate APPLICATION with copy application utility. Another way of migrating application is traditional way that is EXTRACT all REQUIRED files from DEVELOPMENT and load same files in production.

We migrate application with copy application utility. Another way of migrating application is traditional way that is extract all required files from development and load same files in production.

CONSOLIDATION is AGGREGATING the Base level ENTITIES AMOUNTS with the PARENT level entities amounts.

Consolidation is aggregating the Base level entities amounts with the Parent level entities amounts.

In Entity Dimension, we should CHECK the “allow adjustment “PROPERTY. And the period in which we created the journal should be kept open. And we should have the SECURITY AUTHORITY to create journals.

In Entity Dimension, we should check the “allow adjustment “property. And the period in which we created the journal should be kept open. And we should have the security authority to create journals.

To perform Review PROCESS, we should have the “Review SUPERVISOR” SECURITY AUTHORITY. In Explore Data Module, we will perform Process Management.

To perform Review process, we should have the “Review Supervisor” Security authority. In Explore Data Module, we will perform Process Management.

First we have to create/define all the currencies in the Meta DATA Item CALLED currencies. Then we have to perform currency translations in Explore data MODULE by using custom dimensions and value DIMENSION.

First we have to create/define all the currencies in the Meta Data Item called currencies. Then we have to perform currency translations in Explore data module by using custom dimensions and value dimension.

If we CREATE a journal as Auto Reversing Journal, the journal will POST in the NEXT PERIOD by reversing the DEBIT and Credit.

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

Some JOURNALS we use repeatedly. So, for that PURPOSE, we will CREATE RECURRING TEMPLATES. By using the recurring templates, we will create recurring Journals..

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