Accenture
Tell me something about ur selfIts common question you have to tell about yourself but need to be very confident.
Current Project
You can tell any of our clients but need to be careful about company and projects, before you speak prepare thoroughly about your projectProcedure of Loading Data
In windows
Need to prepare flat file
and then select load data In windows tool,
then select saved file with “.dat” extension file and then press “load”
in workspace open application
in tasks open data tasks then select load data then select desired .dat file from saved path through browse
Attributes of Scenario Dimension Member
description (English) default freq
default view
Zero view for nonadj zero view for adj consolidate YTD user defined 1 user defined 2 user defined 3
supports process management security class
maximum review level uses line items
enable data audit def freq for IC trans Default Parent
Tasks of HFM
Patented financial consolidation and reporting features Complete audit trails, workflow and validations
“Smart Dimensionality”
Flexible "what if" scenario management features Powerful, reporting and analysis tools
Full integration with ERP and other transaction systems Easy to customize and extend
Web-architected
Bugs got while loading metadata No consolidation method section No Currencies section in load
No App Settings section in load file
Error: Member name has invalid characters, is too long, or is empty
Error: No child specified for parent/child pair
Error: No top-level members specified in hierarchy
Error: A (non-comment) line was found before any section headers
Difference Between Merge and Replace Merge
If a dimension member exists in the load file and in the application database, then the member in the database is
replaced with the member from the load file. If the database has other dimension members that are not referenced in the load file, the members in the database are unchanged. For example, a database contains entities CT, MA, and CA. You use the merge method to load a metadata file containing new information for CA only. In the database, CA is updated with the new
information and MA and CT remain in the database and remain unchanged.
Replace
All dimension members in the application database are deleted and the
members from the load file will be taken in the database.
How do we prepare web forms?
Navigation Administration Manage documents Data forms New folder New
By selecting options in the data form tab we can create desired data form.
what are the custom dimensions that you are working on in the present project?
This should be based on the company your doing project
according to the nature of the company’s business we have to select custom dimensions.
Ex: Car manufacturing company Customers should be:
1) dealers 2) Government 3) private company 4) vasant cabs….etc.., Products should be 1) iron 2) tyres 3) leather
4) technology for security 5) glass…etc.,
IBM
Process Management in HFM
Every month HFM admin will do 4 activities 1) open periods
Navigation Tasks
IC transactions
Select desire period and click on open period 2) start the process
Navigation: Tasks
Data tasks
Process control
Select scenario and year and period and then press ok 3) fill the exchange rate
Fill exchange rates, opening and closing rates 4) fill ownership data
Navigation: Tasks
Data tasks
Ownership man agent Select desired fields and then press save button consolidation rule
Identifies the rule that is executed during the consolidation of the node of the hierarchy. This rule can contain customer
specific formulas appropriate for the correct consolidation of parent balances. Elimination processing can be controlled within these rules.
Exchange rates
Exchange rates are nothing but opening and closing rates that can be decided by the management which rate has to be taken for the calculation purpose. If some organizations using avg method that can be used through rule file to calculate.
Security Class
After you define users and groups and security classes, you can specify the level of access each
user and group have to each security class in the application and set up e-mail alerts.
Note: You must select users and classes for the application before you can access the Assign
Access Level User and Group Tasks
None No access to elements assigned to the security class.
Metadata View a specified member in a list but cannot view or modify data for the member.
Read View data for elements assigned to the security class but cannot promote or reject.
Promote View data for elements assigned to the security class and can promote or reject.
All Modify data for elements assigned to the security class and can promote and reject.
You can use the Pivot Table feature to toggle between two views for assigning access. For example,
if you have users and groups on rows and security classes on columns and click Pivot Table,
users and groups will be on columns and security classes on rows.
Note: A user assigned to the Application Administrator role for an application has access to all
information in the application.
ä To assign user access to security classes: 1 Select cell for which to assign access rights. 160 Financial Management User Provisioning
Tip: Use the Shift and Ctrl keys to select multiple cells. Select a column or row by clicking in the
column or row header.
2 From Access Rights, select the access level to assign. 3 Click Set to apply the level to the selected cells.
4 Optional: To add an e-mail alert, select cells in the table and click Add Alert.
Types of review Levels
A Process Management review status indicator that represents the process unit level. Review levels include the following: Not Started,
First Pass,
Review Level 1, Review Level 2 ... Upto Review Level 10, Submitted,
Approved, and Published. .
why we use IS CALCULATE in CUSTOM1, CUSTOM2, CUSTOM3 and CUSTOM4?
IS CALCULATE : Specifies whether the base-level Custom account is calculated. If a base-level Custom account is
Custom account is to be calculated and N if the Custom account is not to be calculated.
So to roll up the base level entities total into group level, we use is consolidate in Y mode for group level and N for base level entities to enter data in base level enmities
Process of loading Journal Entries
Before process journals we have to ensure below steps 1) Allow adjustments are enable
2) open journal periods
3) ensure all balances transferred to required a/cs to be filled 4) create
5) submit as per levels 6) post Journals
Navigation to create journal: Tasks
Journals tasks
Process journals
About Translation
Translation rules run when users run translations. You can use Translation rules to perform calculations related to
non-standard translations. The Translate() routine is executed when you translate or consolidate data.
For example, if the application is using the default Closing Rate to translate Assets and LIABILITY accounts and Average Rate to translate REVENUE and EXPENSE accounts, you may want to use a different translation rate to calculate the translation
difference related to Net REVENUE.
Financial Management executes Translation rules in these cases:
● When a user runs a currency translation by right-clicking in the Explore Data module and selecting Translate or Force Translate from the menu that is displayed. This is useful for performing translations as you enter data.
● When a user performs a consolidation and a parent entity’s default currency is different from a child entity’s default currency.
What is POV? Point of View
● A Background POV for the form specifies the initial members for dimensions. Use the Member text boxes to specify the Background POV members. Members specified in the
Member text boxes are added to the BackgroundPOV keyword, which is described in
● A Selectable POV for the form consists of the dimensions for which users can select members. You use the Selectable text boxes to specify the member lists from which users can select members. Members specified in the Selectable text boxes are added to the SelectablePOVList keyword. For information on the keyword and the syntax used for
member lists, You can specify a Background or Selectable POV for a dimension in two ways:
● Type a member label or the syntax for a member list in the applicable text box.
● Click for the applicable text box to select members and member lists with the Member Selector.
These rules apply to using the POV tab:
● If Member and Selectable are blank and the dimension is not used in a row or column, the system uses the member from the User POV for the initial value for the dimension.
● If you specify values in a Background and Selectable POV for a dimension, and the member for the Background POV is not in the member list for the Selectable POV, the system uses the first member in the member list of the Selectable POV as the Background POV member.
Smart View
Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed
specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products
• Ability to integrate EPM & BI data directly from the data source into Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook
• Full ad-hoc and free form analysis capabilities for Hyperion Financial Management, Hyperion Essbase, Hyperion
Planning and Oracle Business Intelligence Enterprise Edition
• Data access from Relational or Multi-Dimensional sources
• An alternative, Office-based interface for leveraging Hyperion Planning, Hyperion Financial Management, and Hyperion Workforce Planning data entry forms
• Ability to create data perspectives for end users called Smart Slices
• Ability to execute Hyperion reporting jobs from within Office applications
• Ability to dynamically refresh Hyperion data across Office documents with a single click
• Ability to perform selective, multi-page import of
documents residing in a Workspace repository into Office documents, including reports created in Financial
Reporting, Interactive Reporting, SQR and Web Analysis.
• Point of View (POV) search for efficient, context-based searching
• Support for highly formatted grids in Microsoft Excel
• Support for Hyperion Essbase Visual Explorer (included in the Smart View plug-in) delivering one-click visualizations, bi-directional communication, and linked data views
• Report Creation in Excel, Word and PowerPoint using EPM and BI data
• Comprehensive VBA toolkit for developing custom Office-based analytic interfaces
How to logon into application
open workspace through internet explorer and then open with employee id and password then open application through navigation and then use ur permitted application
How to create app profile and application creation
To create application you need to create application profile with .per extension then we need to create application with desired name
Navigation to define application
Click ok define application in windows mode Then define languages
Set time periods Then set frequencies
Save the .per file and then create application by using .per file Create application
Click on create application then fill the necessary steps Server name
Application label
Application description Application server Local storage folder
User management project
financial management web server URL for security administration
What r the dimensions we have 1) year 2) scenario 3) view 4) period 5) account 6) entity 7) ICP 8) custom1 9) custom2 10) custom3 11) custom4 12) Value
Explain about icp dimension
Intercompany transactions are managed across the
Intercompany Partner (ICP) dimension. The ICP dimension
represents a container for all intercompany balances that exist for an account.
ICP is a reserved dimension used in combination with the Account dimension and custom dimensions to track and eliminate intercompany transaction details. To set up an application for intercompany transactions, you must perform the following actions:
●Indicate the accounts that perform intercompany transactions
and indicate a plug account for each intercompany account (IsICP and PlugAcct attributes in account metadata)
●Indicate the entities that perform intercompany transactions
(IsICP attribute in entity metadata)
When you create intercompany transactions, each group must have at least one intercompany account and one plug account. You designate an account as intercompany by selecting the IsICP attribute for the account in Metadata Manager. When an account is designated as intercompany and intercompany transactions are entered, eliminating or reversing entries are
generated in the [Elimination] value dimension member through the consolidation process. A plug account is an account that, when eliminations are completed, stores the difference
between two intercompany accounts. A plug account can be set up as an ICP account. For a plug account to be detailed by ICP, set the IsICP attribute to Y or R so that the system writes
eliminations to the corresponding ICP member. If you do not want a plug account to be detailed by ICP, set the IsICP attribute to N so that the system writes eliminations to [ICP None]. During consolidation, transactions between valid
intercompany entities are eliminated. For more information on entity metadata, Following are the system-generated ICP elements.
Table 19 System-Generated ICP Elements ICP Element Description
[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
What is ur application name Barcly
Explain about web entry forms
You create data forms for users who need to enter specific data. You can create data forms in
two ways:
● Writing a script in a text file
● Using the Form Builder integrated script editing tool
When you create a data form, you are customizing the data that is displayed. Data forms use the WDF file extension.
Note: To load, extract, and delete Web forms, you must be assigned to the Manage Data Entry Forms role.
What are diff between web entry form and data grid
1) In web grid we can consolidate the data, where in web form we can’t consolidate the data
2) web grid is for group users where web form is for end users 3) In web forms we can create through scripts also
4) In web grid we can use members lists and rows and columns selection is very easy just select and send where in web form we have click and open and select the rows
5) In web form we can import and export web from from excel where in web grid we can’t import and export
What is consolidation
consolidation means consolidation of the values of base entities amount into group level. When we press consolidate, all
amounts will rolled up into group entities which we given as hierarchies
What is diff between consolidation and consolidation all with data
When we click on Consolidate all the amounts will be
consolidated as per the hierarchies given but it takes lot of time to calculate. To reduce the time we have to use consolidate with data, it consolidates only given values at present. It reduces the load on the server
Diff between merge, replace and accumulate
merge A data load option that clears existing values from the accounts specified in the data load file and then replaces them with the values in the data load file. Unlike the Replace option, the Merge option clears only the values from the accounts specified in the load file.
replace A data load option that clears the existing values from all accounts for the periods specified in the data load file, and then loads the values from the data load file. If an account is not specified in the load file, its values for the specified periods are cleared during the load.
If we delete one account then should we select merge or replace Yes we can select any of that option based on accounts
available merge and replace will taken into consideration Have u any exp with reporting
Yes I have worked with simple and medium reports Tell me the navigation to meta data loading
Open application then select Tasks
Load tasks
Load metadata
Then click on browse to select desired metadata file Do u use both desk top and work space for creating the application
Yes, we are working on desktop so we can create application either desktop or workspace.
3. What is HFM architecture?
Hyperion Financial Management is designed to operate as a multitier 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.
Conclusion: Hyperion HFM uses more current and robust technology that allow for widespread deployment through increased scalability.
Can we migrate data from essbase to HFM? Yes we can migrate data from essbase
What is cluster?
Cluster is a load balancer of the applications.
is a group of linked computers, working together closely thus in many respects forming a single computer. The components of a cluster are commonly, but not always, connected to each other through fast local area networks. Clusters are usually deployed to improve performance and/or availability over that of a single
computer, while typically being much more cost-effective than single computers of comparable speed or availabilityis a group of linked computers, working together closely thus in many respects forming a single computer. The components of a
cluster are commonly, but not always, connected to each other through fast local area networks. Clusters are usually deployed to improve performance and/or availability over that of a single computer, while typically being much more cost-effective than single computers of comparable speed or availability
what are default dimensions? View Account Entity Period Icp Scenario Year value
What are 8 rules we used in rules? 1) Calculation 2) translation 3) allocation 4) consolidation 5) no Input 6) Input 7) Ic transactions 8) Dynamic
Rajani need to answer these questions
Which version of hfm using both desk top and workspace What r the roles in ur project
How to move the app from development server to production server
What is process of transferring data through FDQM? Process Exporting the data?
LCM & CSS?
when we update from one version to other version, will the rules update?
when we post a journal and again delete that account from Meta data then does journal works
How will you convenceclient that HFM is useful for them and how is it useful for them when compared to ESSBASE
we try to load data, it is not loading, no security issues what might be the problem?
Implementation Phases? Interface Tables
