Welcome to Sai Akshara School
==============================================================
1.What is HFM?
Ans:
Oracle Hyperion Financial Management is a financial consolidation tool..
2. What
is Consolidation?
Ans.
Consolidation
is aggregating the Base level entities amounts with the Parent level entities
amounts..
3. How
many standard dimensions are there in HFM?
Ans. There are
8 standard dimensions in HFM.
4. How many
Custom dimensions are there in HFM?
Ans: Here you
need to answer as per your HFM version.
Ex: 9 version
to 11.1.2.1 version only we having 4 custom dimension. After that versions are
like (11.1.2.2 and 11.1.2.3) having 100 custom dimensions.
Note: Custom
dimensions names are not standard. Those are changed to project to project.
5. Can you
please Explain 8 standard dimensions?
Ans: Those 8
Standard dimensions are like
1. Entity
2. Account
3. Value
4. Scenario
5. Year
6. Period
7. View
8. ICP
6. What
is HFM ARCHITECTURE?
Ans: 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.
7. What
are HFM services you need to start?
Ans:
1. Hyperion
Foundation Shared Services - Web Application
2. HFM- DME
Listener
3. Hyperion
Web Service Manager
4. Hyperion
Workspace- Agent Application
5. Hyperion
Workspace- Web Application
8.
Services dependency means?
Ans: Hyperion
is dependent on services. Means services are to be started in a specified
sequence only.
9. How
many Environments do you having in your Project?
Ans: We
having 3 environments .Those are
1.
Development Environment
2. QA
Environment
3.
Production Environment
10. What
is application profile; can we change application profile at any point of time?
Ans. An
application profile contains language, calendar, frequency, and period
information for an Application. No, application profile once created
cannot be changed.
11.
What are the dimensions will be covered while creating Application Profile
Ans:
Year, Period, View.
For more Hyperion Information kindly visit @ http://h4hfm.blogspot.in/
12. How many Account
types in HFM?
Ans: We
have 10 Account types in HFM.
13. Explain
those Account types in account
dimension?
Ans: There are
10 account types -
1.
Asset
2.
Liability
3.
Revenue
4.
Expense
5.
Balance
6.
Balance recurring
7.
Flow
8.
Dynamic
9.
Group label
10. Currency Rate
14.
What is COA?
Ans: COA
is nothing but chart of accounts, whatever the members we will define under the
account dimension will be called sometimes chart of accounts (COA)
15.
What is the difference between switch sign for and switch type for and in which
dimension it exists?
Ans: 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
16.
What does a balance sheet contain?
Ans: In
financial accounting, a balance sheet is a summary of the financial balances
of a company. Assets, liabilities and ownership equity are listed as of a
specific date, such as the end of its financial year.
17.
What does an income statement contain rough outline?
Ans: It indicates
how the revenue (money received from the sale of products and
services before expenses are taken out) is transformed into the net
income (the result after all revenues and expenses have been accounted
for. It displays the revenues recognized for a specific period, and the cost
and expenses charged against these revenues, including write-offs (e.g.,
depreciation and amortization of various assets) and taxes. The purpose of the
income statement is to show managers and investors whether the company made or
lost money during the period being reported.
18.
Give me some report names that you have created in project?
Ans: You
can say Actual book, budget book, forecast book etc.,
19. Can
in use any other rates other than avg- rate and EOM (Ending of Month) - rate in
translation in HFM?
Ans: Consultant
is not the one who decides to take either avg-rate of EOM rate; client will
decide it time to time.
20. What
is good will?
Ans: Goodwill
in financial statements arises when a company is purchased for more than the
fair value of the identify 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
21. What
are the combinations to enter exchange rates?
Ans: From
customer 1 and custome
r 2, there is a system defined member list called currency. So, in customer 1, we are going to have source currency and in customer 2, we have destination currency.
r 2, there is a system defined member list called currency. So, in customer 1, we are going to have source currency and in customer 2, we have destination currency.
22. I don’t want an account to get translated, what account type should be used?
Ans: There is
no relation between account type and translation.
23. Child entities have data, but there is no data in parent entity? What could be the reason?
Ans: Parent
account type is ‘Group Label’
24.
What is ICP?
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.
25. How
do you create ICP member in HFM?
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 create 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.
Note:
You can
modify only the description and security class for ICP members. All other
attributes are predefined and cannot be modified
26. How
to setup ICP? Y means what? N means what? R means what?
Ans: In
account/entity dimension, we have an attribute list as IsICP.
Y- Yes
N- No
R-
(Restricted) Yes AND the entity cannot use itself as ICP.
27. Explain ICP Members
Ans: ICP Top
ICP None
ICP Entity
28. Explain ICP Process?
Ans: 1. Match
2. Un Match
3. Post
4. Un Post
5. Reason Code
29.
What is Tolerance amount?
Ans: Tolerance
amount is small discrepancies in the amounts in Intercompany Transactions.
30. How do
you eliminate intercompany transactions?
Ans: Intercompany
transactions are eliminated through plug account.
Steps:
1. Create
plug account in account dimension
2. Tick the
check box called IS ICP in account dimension
3. Tick the
check box called IS ICP in Entity dimension
4. Load the
ICP rule file.
5. Then
automatically the difference between the Intercompany transactions will be
transferred to plug account
For more Hyperion Information kindly visit @ http://h4hfm.blogspot.in/
31. How
many plug accounts we can create?
Ans: In
HFM, we can create number of plug accounts, but based on requirement we will
create the plug accounts for elimination process.
32. You
are not able to load ICP transactions. What is the Reason?
Ans: 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.
33. What
is mean value dimension?
Ans: The Value
dimension represents the types of values stored in your application, and
can include the input currency, parent currency, adjustments,
and consolidation detail such as proportion, Elimination, and contribution
detail.
34.
EXPLAIN about Entity Curr adj member in HFM?
Ans: 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 calculate and
posting journals.
35. How
many types of adjustments we can post.
Ans: In
HFM we have:
1. Entity
Currency Adjs
2. Parent
Currency Adjs
3. Parent
Adjs
4. Contribution
Adjs
36. How
will you perform Currency Translations?
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.
37. Where
is the translation done?
Ans:
Translations can be done in data grid, data forms and at process management
level.
38.
What is triangulation?
Ans: 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 you
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.
39. How
do you enable Rules to customize consolidation?
Ans: Application
Settings -> consolidation Rules -> Y
40.
What is node security?
Ans: Application
Settings ->
By giving
node security we can restrict user for seeing the value dimension members.
IF you
set node security as parent only the members of the value dimension from
<Entity Currency>up to and including <Parent Curr Total> are
visible.
If you
set node security as Entity, all members of the value dimension would be
visible
41.
What is the use of Organization by Period?
Ans: Application
Settings -> If any New Entity or
Entities exists in the future at that point that newly added entities will be going to participated in the
Consolidation or not.
IF Organization by Period options select as
“Y” those will be participated in the Consolidation process.
IF Organization by Period options select as
“N” those will be not participated in the Consolidation process.
42.
What is the use of Icp Entity aggregation weight?
Ans: If
we Put 1 it going to participating 100% in the consolidation process.
If we Put
0.5 it going to participating 50% in the consolidation process
43.
Explain about member attributes?
Ans: Member
attributes are differed from dimension to dimension; every dimension member
will be having importance to their respective areas.
44.
What is alternative hierarchy?
Ans: 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.
45. How
do you create members in HFM?
Ans:
Using manage metadata, we create child or sibling
46.
What is purpose of Journal?
Ans:
Journals are generally used to adjust the data.
47.
What is Adjustment?
Ans: Adjustment
is to correct the data. It is done by Journals at value dimension member Entity
currency Adjs and Parent curr Adjs.
48. How
many journals types are available in the HFM?
Ans: We
having 2 types of journals .Those are
1. Regular
2. Auto
Reversing
49.
What is a Recurring Journal?
Ans: Some
Journals we use repeatedly. So, for that purpose, we will create
recurring templates. By using the recurring templates, we will create recurring
Journals.
50.
What is an Auto Reversing Journal?
Ans: If
we create a journal as Auto Reversing Journal, the journal will post in the
next period by reversing the Debit and Credit.
Welcome to Hemantha Reddy Charitable Trust
=======================================================================
Welcome to Hemantha Reddy Charitable Trust If you are satisfied with this answers please donated some amount.Which is very helpful and allowed us to help the needy people in the society.
==============================================================
51. How
many journal Templates are available in the HFM?
Ans: We
having 2 types of journal Templates .Those are
1.
Standard
2.
Recurring
52. How
many Journals Balance Types are available in the HFM?
Ans: 1. Balanced
2. Unbalanced
3. Balanced by Entity
53
Difference between them?
Ans: 1. Balanced: All
the Debits and Credits will be balanced
2. Unbalanced: Debits
and Credits will not be balanced
3. Balanced by
entity: Debits and Credits for particular entity will be balanced
54.
Explain Journal Review Process?
Ans: 1. Create
Journal
2. Submit the Journal
3. Receive Approval or Reject
4. Post Journal
55.
Sometimes, we cannot post a Journal. What will be the Reason?
Ans: 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.
56. Some
we can’t able to create journals for an entity what option do u check?
Ans: Allow
Adjs in entity dimension
57. What
is Line ITEM detail in HFM? How to enter it?
Ans: Line Item
detail is additional information to the data. It is entered in the data file.
58. Can I display line item details in any report?
Ans: No
59. What are the differences between data grid and data form?
Ans: (a.) POV
is not restricted in data grids & POV is restricted in data forms.
(b.) We can print the form in data
form but we don’t have it in data grid.
(c.) We can export
the data form to the excel file and import file and we can bring back the changes
to the DB. This is called offline working on data forms.
60. Explain
Methods of Data Loading?
Ans: Merge
Replace
Accumulate
61.
What are different ways of running consolidation in HFM?
Ans: 1. Manual consolidation by using grids.
2. Consolidation using task automation
3. Custom consolidation
by using rules.
62. How
do you know whether the consolidation has been done for a
Particular
entity or not in a particular month?
Ans: If
you select a data grid for that particular entity, change the display options
to calculation status there if you found CN or CN ND it means
that that entity needs consolidation.
63. How
do Different Cell Colors indicate in HFM? (Ask any specific color)?
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
For more Hyperion Information kindly visit @ http://h4hfm.blogspot.in/
64.
What is the difference between consolidate, consolidate all and consolidate all
with the data?
Ans:
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.
65.
What are the types of consolidation and methods of consolidation?
Ans:
Types:
1. Legal
Consolidation
2.
Geographical Consolidation
3.
Consolidation by entity
Methods:
1.
Consolidate
2.
Consolidate all
3.
Consolidate all with data
66. How
can you cancel consolidation?
Ans: HFM
Web client -> Administration -> running Tasks -> click on the Red
button
67. HOW
do you create members list in HFM?
Ans: Member
list we can write with the function called list and we will save with extension
.lst, once you uploaded the member list you can select the member in a
particular POV working with different areas like journals, ICP etc., we can
also create our own custom member list for different purposes.
68.
Where is HFM data available?
Ans: 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.
69. How
do you load the data into HFM?
Ans: 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.
70. How do you achieve closing process in HFM?
Ans: We are
going to handle through process management.
71. How
will you perform Review Process?
Ans: To
perform Review process, we should have the “Review Supervisor” Security
authority. In Explore Data Module, we will perform Process Management.
72. How
do you achieve closing process in HFM?
Ans:
Load Data
Calculate
Data
Adjust
Data
Translate
Data
Approve
Data
Publish
Lock data
73.
What is data lock?
Ans: A
user-controlled mechanism that prevents changes to data according to specified
criteria, such as period or scenario
74. How
do you lock the data?
Ans: Select
Lock/Unlock IC Entities and Select Scenario, period year and click lock
75. How
many level of security in HFM?
Ans:
1 User
authentication
2 Task
securities
3 Document
securities (Data grids and forms, journals, reports)
4 Data
security
76. How
many plug accounts we can create?
Ans: In
HFM, we can create number of plug accounts, but based on requirement we will
create the plug accounts for elimination process.
77. How
many Access Levels for Security Classes in HFM
Ans:
1 All
2
Metadata
3 Read
4 Promote
5 None
78.
What are the types of the reports used in your project? What does each report
contain in brief?
Ans: 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.
79. We
should not give the security for the below 3Dimensions what are those Ans:
1. Year
2. Period
3. View
80. What
is Hyperion Life Cycle management (LCM)?
Ans: Lifecycle
management is a component of Shared Services that provides a mechanism of
moving artifacts – for example copying of web data entry forms from one
application to another.
In prior
versions (prior to 11 versions) items required extracting and loading. The
ability to use Lifecycle Management is controlled via a unique role for which
the user must be provisioned
81.
Explain about member attributes?
Ans: Member
attributes are differed from dimension to dimension; every dimension member
will be having importance to their respective areas.
82. How
can enable Metadata Security Filtering?
Ans: 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)
83. HOW
do you create members list in HFM?
Ans: Member
list we can write with the function called list and we will save with extension
.lst, once you uploaded the member list you can select the member in a
particular POV working with different areas like journals, ICP etc., we can
also create our own custom member list for different purposes.
84.
What are the rules used for? How many rules an application can have?
Ans: Rules
are one of the areas which make HFM application more flexible with the custom
procedures or consolidation etc.
We have 8
subroutines in rules, and under each subroutine there will number of functions
which makes rules simplify,
Calculation
Translation
Consolidation
Allocation
Input
Icp
No Input
Dynamic
85.
What are custom top members?
Ans: The
Custom top member for the account
The
specified member, including all descendants, is valid for the account
86.
WHAT is the node security if we put the yes or no in the node?
Security
what will happen? (In entity scenario)
Ans: We
can choose a parent or an entity for node security, if you select either
of one.
Then you
will be able to see the value dimension members which upper to parent Curr adj,
normally up to parent curr adj we can able to see without node security.
87.
What is data audit in HFM?
Ans: 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.
88. What
is minority interest in HFM?
Ans: Relates
to ownership management, it will arrive by the formula
PMIN =
PCON-POWN
Percent
of minority interest is equal to Percent of consolidation minus percent
ownership.
89. How
to get prior year retained earnings?
Ans: By
using rules we can achieve it.
90.
Explain some rules you have used in your project?
Ans: Can
say consolidation, calculation, ICP etc.
91.
What is the minimum to role to be given to a user to access HFM?
Ans: Default
92.
Where do you give roles to users?
Ans: In
shared services under the provisions.
93. Can
we load data in multiple currencies per entity?
Ans: You
cannot load multiple currencies to one entity, because in attributes you can
give only one currency in Def. Currency
94. At
what rate accounts will get translated and how you tell (or
Define)
in the system?
Ans:
Step1: we have to define the currencies in metadata under the
“Currencies”
Here what
are the currencies you will define it will be automatically stored under Custom
1 and Custom 2 under Currencies system generated member.
Here the
currencies will have a relationship with value dimension
After you
load metadata, Financial Management automatically creates three Value dimension
members for each currency in your application: Currency Name, Currency Name
Adjs, and Currency Name Total, where Currency Name is the currency label. For
example, for a currency of USD, Financial Management creates the following
Value dimension members: USD, USD Adjs, and USD Total.
Step 2: In entity dimension attributes we have to give the default
currency for that particular entity.
By giving
this whenever you select the “entity currency” in value dimension whatever the
currency we have given the default currency it will execute that.
For
example if you are looking for a form or report of the country US as we all
know the currency for US is USD, here we can see the report in two ways in
value dimension, either you have to select the currency “USD” or you have to
select the “entity currency” when you select the “entity currency” it will take
the default currency from the entity (in this case we will give the default
currency from entity as USD”) in both cases the result will be same. So here
whenever you don’t know the entity currency the value dimension member “entity
currency” will help us to see the report in the local currency.
Step 3: Application setting with regards to currency
Default
Currency: this means the ultimate parent currency in which we will
generate the final reports.
Default
Rate for Balance Accounts: For Balance sheet accounts we have to mention the
default rate whether it’s closing rate or average rate (we need to create an
account for average and closing rates)
Default
Rate for Flow Accounts: For flow accounts (i.e., Income statement) we have to
mention the default rate whether it’s closing rate or average rate (we need to
create an account for average and closing rates)
Use PVA
for Balance Accounts: Normally we will not select this for balance sheet
accounts, because we will use closing rate for balance sheet accounts
Use PVA
for Flow Accounts: When you are using Average rate for Flow accounts, in normal
practice we will select this option for Flow accounts (i.e. Income statement)
Step 4: Once we finish these steps we will enter the currency
exchange rates by using flat file or web form.
Normally
People from client side will do this activity by entering in web form or data
file.
For more Hyperion Information kindly visit @ http://h4hfm.blogspot.in/
95.
What is the combination to enter exchange rates?
Ans: You
can take the base currency in custom 1 and translated currency in custom 2 and
you can give the exchange rates.
96.
What is Custom aggregation weight?
Ans: In
Node attribute if you put 1 means it will be participating 100% consolidation
process and if put 0.5 means it will be participating 50% consolidation
process.
97.
Child entities have data but there is no data in parent entity what
Could
be the reason?
Ans: Probably
consolidation may not happen at that particular point of time.
98. In which dimension we see the Zero view adjustments
and Zero view Non adjustments attributes?
Ans: Scenario.
99. What is line item detail in HFM how to enter
it?
Ans: If
you select “Use line items” attribute in account dimension for a particular
account you can do this.
For
example in admin expenses you have different departments like sales, purchases,
HR. you can enter 3 line items in account admin expense in grid.
100.
What is the Functions of Smart view?
Ans :
1. Get
value
2. Set
value
3. Get
text
4. Set
text
5. Hs
currency
6. Hs
label
7. Hs
description
8. Hs
group
101. What
is meant by validation rule and how to set?
Ans:
Validation rules define the validation rule group. The rule table comprises of
Display Value, Description, Rule Name, Rule Text, Type, Category, Seq and Rule
Logic.
Validation
Rule Group-It contains a set of administrator defined rules that perform checks
and balances against the target system.
102.
Have you used data forms give me some example?
Ans: For
data entry in to the HFM every client should use data forms in some way.
Example
for this Balance sheet, Income statement.
103.
How do you take back up of a HFM application?
Ans: Normal
practice is copy application, back up of security, meta-data, data etc.
104.
The data is exported to smart view in excel but the cells are showing zeros
what could be the reason?
Ans: This
is because of the Zero view adjustments and Zero view non-adjustments in
scenario dimension meta-data attributes.
105.
What are the system messages??? Tell me some error messages?
Ans: You
can retrieve, view, print, and delete system messages for Financial Management.
You can retrieve system messages by date, server name, and application name.
System messages remain in the log until you delete them. The system messages
module is available only in the Web user interface
If a user
doesn't have a proper access for a particular entity if he is repeating the
same action, then an error will come in system messages "you don’t have
proper rights to perform this action".
106.
What is the Error code 502? Or 400 something?
Ans: A
502 error is Internal Server error. Your web server will return that HTTP
Response when the program running terminates abnormally/returns an unhandled
exception.
A 404
error (probably it may be 400 errors) is a file not found error that occurs
when the Web Server receives a HTTP GET request for a file that does not exist
on the server in the path specified. Usually occurs when a web.
107.
WHAT is Statutory Hierarchy?
Ans: Statutory
hierarchy means which fits for Legal requirement to submit the accounts of a
company.
108.
WHAT is Managerial Hierarchy?
Ans: Managerial
hierarchy is for higher management it will gives you in-depth analysis for
different areas.
109.
RESPONSIBILITIES of Migration?
Ans: The
main thing you need to do after performing the migration is we have to check
all the functionality in the application like, loading, extracting data,
journals etc., like this we need to prepare a checklist and have to confirm
every function is working perfectly.
110.
What is the Account dimension attributes?
Ans:
Member
Description
(English)
Account
type
Is
Calculated
Is
Consolidated
Is Icp
Plug
Account
Custom 1
Top Member
Custom 2
Top Member
Custom 3
Top Member
Custom 4
Top Member
Num
Decimal places
Use line
items
Enable
Custom 1 aggregation weight
Enable
Custom 2 aggregation weight
Enable
Custom 3 aggregation weight
Enable
Custom 4 aggregation weight
User
defined 1
User
defined 2
User
defined 3
Security
class
Icp Top
member
Enable
data auditing
Default
parent
112.
What is the Entity dimension attributes?
Ans:
Member
Description
(English)
Default
currency
Allow
adjustments
Is Icp
Allow
adjustments for children
Security
class
User
defined 1
User
defined 2
User
defined 3
Holding
Company
Security
as partner
Default
parent
113.
What is the Scenario dimension attributes?
Ans:
Member
Description
(English)
Default
Freq
Default
View Periodic
Zero view
for Non adjustments
Zero view
for adjustments
Consolidated
YTD
User
defined 1
User
defined 2
User
defined 3
Security
class
Enable
data auditing
Support
process management
Maximum
review level 10
Use line
items
Default
Freq for Icp transactions
Default
parent
114.
What is the Custom dimension attributes?
Ans:
Member
Description
(English)
Switch
sign for flow
Switch
Type for flow
User
defined 1
User
defined 2
User
defined 3
Security
class
Submission
groups
Default
parent
115.
What is the Currency dimension attributes?
Ans:
Currency
Description
Scale
Translation
operator D, M
(%,*)
Display
in ICT
116.
Which Ticketing tool is used in your support project?
Ans: Remedy,
Lotus, Service now (Please tell anyone)
117.
Differences between Data Form and Data Grid?
Ans:
Data Form
|
Data Grid
|
1. It
is end user purpose/client
|
1.It is
a Group user purpose
|
2.we
can Import and Export
|
2. We
can't Import and Export
|
3.We
can restrict the POV
|
3.We
can't restrict the POV
|
4.We
can select the Excel (Smart View)
|
4. No
selection for Data Grid.
|
5. We
can link one form to another form.
|
5.Linking
option is not available
|
6.Transalation
is not possible
|
6.Transalation
is possible
|
7.Calculations
not possible
|
7.Calculations
are possible
|
8.We
can done Scripting here
|
8. Not
Scripting option here.
|
Welcome to Hemantha Reddy Charitable Trust
=======================================================================
Welcome to Hemantha Reddy Charitable Trust If you are satisfied with this answers please donated some amount.Which is very helpful and allowed us to help the needy people in the society.
==============================================================
For more Hyperion and support Kind of Issues please visit @ http://h4hfm.blogspot.in/----------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
For more Hyperion Information and support Kind of Issues and some other Hyperion related Issues Please visit @ http://h4hfm.blogspot.com/----------------------------------------------------------------------------------------------------------------------------------------------
About consolidation process in
HFM?
What are the
dimensions in HFM?
Total we have 12 dimensions in HFM, 8 standard dimensions
and 4 custom dimensions up 11.1.121 Version
8 Standard dimensions
4 Custom dimensions names are not standard.
About the Value Dimension.?
In value dimension, there are two type of members one is
system defined which you find in brackets and another one is user defined, whenever
we define a currency the system will automatically creates 3 value dimensions
based on one particular currency enter by the user.
If you observe here USD, based on USD system will create
USD, USD adj, USD total. this is equal-ant to entity currency, entity currency
adj, entity currency total. entity currency adj for adjustments like journals
and entity currency total = entity currency - entity currency adj.
-----------------------------------------------------------------------------------------------------------------
For more Hyperion Information and support Kind of Issues and some other Hyperion related Issues Please visit @ http://h4hfm.blogspot.com/
----------------------------------------------------------------------------------------------------------------------------------------------
What is node security?
By giving node security we can restrict user for seeing the
value dimension members
IF you set node security as parent only the members of the
value dimension from <Entity Currency>up to and including <Parent Curr
Total> are visible.
If you set node security as Entity, all members of the value
dimension would be visible
How many dimensions are system
defined and how many dimensions are user defined and what are they?
At the time of application profile creation, based the data
enter by us...
If you observe in above screen if we check include Half
years, Include Quarters, Include months, the system will generate the period
dimension members as well as view dimension members like YTD,HYTD,QTD,MTD and
also 12 periods will be created automatically. And in the bottom based on the
staring year and number of years the system will create the Year dimension
members.
So 3 dimension members View, Period, Year will be created by
the system and remaining dimension members will be created by the consultants.
because of this reason you can not able to see these 3
dimensions under manage meta-data.
what is COA?
COA is nothing but
chart of accounts, what ever the members we will define under the account
dimension will be called some times chart of accounts (COA)
what is Hyperion Life Cycle
management(LCM)?
Lifecycle management
is a component of Shared Services that provides a mechanism of moving artifacts
– for example copying of web data entry forms from one application to another.
In prior versions (prior to 11 versions) items required
extracting and loading. The ability to use Lifecycle Management is controlled
via a unique role for which the user must be provisioned
Please see the below screen for you reference.
How do you retrieve data for
your project/applications?
Financial Management
retrieves data from the Financial Management database in blocks called sub
cubes.
See the below for your reference.
The mode of retrieving will be through data forms, data
grids or smart view.
In smart view we will use HS.Get function to retrieve the
data.
-----------------------------------------------------------------------------------------------------------------
For more Hyperion Information and support Kind of Issues and some other Hyperion related Issues Please visit @ http://h4hfm.blogspot.com/
----------------------------------------------------------------------------------------------------------------------------------------------
what are the combination to
enter exchange rates?
you can take the base currency in custom 1 and translated
currency in custom 2 and you can give the exchange rates.
see below for your
reference.
How do you achieve closing
process in HFM?
Load Data
Calculate Data
Adjust Data
Translate Data
Approve Data
Lock data
Run and Publish
-----------------------------------------------------------------------------------------------------------------------------------------------
For more Hyperion and support Kind of Issues please visit @ http://h4hfm.blogspot.in/
----------------------------------------------------------------------------------------------------------------------------------------------
How do Different Cell Colors
indicate in HFM? (Ask any specific color)?
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
Differences between Data Form
and Data Grid
Data
Form
|
Data
Grid
|
1. It is end user purpose/client
|
1.It is a Group user purpose
|
2.we can Import and Export
|
2. We can't Import and
Export
|
3.We can restrict the POV
|
3.We can't restrict the POV
|
4.We can select the Excel (Smart View)
|
4. No selection for Data Grid.
|
5. We can link one form to another form.
|
5.Linking option is not available
|
6.Transalation is not possible
|
6.Transalation is
possible
|
7.Calculations not possible
|
7.Calculations are possible
|
8.We can done Scripting here
|
8. Not Scripting option here.
|
Calculation Status in Process Management
For more Hyperion Information and support Kind of Issues and some other Hyperion related Issues Please visit @ http://h4hfm.blogspot.com/
 |
The Best Hyperion Training Centre |
Welcome to Hemantha Reddy Charitable Trust
=======================================================================
Welcome to Hemantha Reddy Charitable Trust If you are satisfied with this Information please donate some amount.Which is very helpful and allowed us to help the needy people in the society.
==============================================================
Super sir.
ReplyDeleteNICE POST.
ReplyDeleteOracle DBA online online training
Oracle Enterprise Manager online online training
Oracle Exadata online online training