Interview Questions.

Question 1. What Is A Recurring Journal?

Answer :

Some Journals we use time and again.  So, for that cause, we are able to create habitual templates. By the use of the ordinary templates, we are able to create ordinary Journals..

Question 2. What Is An Auto Reversing Journal?

Answer :

If we create a magazine as Auto Reversing Journal, the journal will post within the subsequent period with the aid of reversing the Debit and Credit.

Computer Technical Support Interview Questions
Question three. How Will You Perform Currency Translations?

Answer :

First we should create/outline all the currencies inside the Meta Data Item known as currencies. Then we need to carry out currency translations in Explore records module by using the use of custom dimensions and cost measurement.

Question four. How Will You Perform Review Process?

Answer :

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

Qlik View Tutorial
Question 5. Sometimes, We Cannot Post A Journal. What Will Be The Reason?

Answer :

In Entity Dimension, we have to take a look at the “allow adjustment “belongings.  And the length wherein we created the magazine need to be kept open. And we must have the security authority to create journals.

Qlik View Interview Questions
Question 6. What Is Consolidation?

Answer :

Consolidation is aggregating the Base level entities quantities with the Parent stage entities quantities.

Question 7. How Do We Migrate Application From Server To Server?

Answer :

We migrate utility with reproduction utility software. Another way of migrating software is traditional manner this is extract all required files from development and load same documents in manufacturing.

MongoDB Tutorial Oracle Data Integrator (ODI) Interview Questions
Question 8. How Do You Enable Rules To Customize Consolidation?

Answer :

Application Settings -> consolidation Rules -> Y

Question 9. What Is Translation?

Answer :

It is Currency translation takes place when a discern entity's default currency is different from a baby entity's default foreign money. Runs when you pick Translate or Consolidate.

IBM BPM Interview Questions
Question 10. What Is Adjustment?

Answer :

Adjustment is to correct the information. It is executed by using Journals at cost dimension member Entity foreign money Adjs and Parent curr Adjs.

Sales Forecasting Tutorial
Question eleven. What Is The Difference Between Consolidate, Consolidate All And Consolidate All With The Data?

Answer :

Consolidate: handiest entities that require good judgment or consolidation are up to date via the device.

Consolidate All with Data: option is available for any parent entity irrespective of its reputation. NODATA are skipped.

Consolidate all: any Parent entity no matter its fame. NODATA are also consolidated.

Oracle DBA Troubleshooting Interview Questions
Question 12. How Can You Cancel Consolidation?

Answer :

HFM Web patron -> Administration -> strolling Tasks -> click on at the Red button

Computer Technical Support Interview Questions
Question thirteen. What Is Icp?

Answer :

The Intercompany Partnership Dimension gives an green manner to become aware of , file, and reconcile intercompany account variations. With the capacity to view detail transaction at any time, you can reconcile intercompany account differences often and thus reduce their impact at the ultimate cycle.

Question 14. You Are Not Able To Load Icp Transactions. What Is The Reason?

Answer :

Cause: IC Period is not opened.

Expand Tasks and choose IC Transaction Tasks. Select Manage IC Periods. From the Scenario drop-down list, pick out a situation for the duration. From the Year drop-down listing, choose a yr for the duration. Select the take a look at container next to each period that you need to open.

Question 15. What Is Lcm Utility?

Answer :

LCM approach Life cycle control which is in shared services.

It is used emigrate configuration and artifacts. (Note: we can't migrate facts with LCM)

MongoDB Interview Questions
Question 16. What Is Tolerance Amount?

Answer :

Tolerance quantity is small discrepancies inside the quantities in Intercompany Transactions.

Question 17. What Are The Types Of Consolidation And Methods Of Consolidation?

Answer :

Types:

Legal Consolidation
Geographical Consolidation
Consolidation by way of entity
Methods:

Consolidate
Consolidate all
Consolidate all with data
Oracle Hyperion Planning Interview Questions
Question 18. What Is The Difference Between Switch Sign For And Switch Type For And In Which Dimension It Exists?

Answer :

It exists in custom dimension

Switch signal for: It is ticked to change

ASSET to LIABILITY
LIABILITY to ASSET
EXPENSE to REVENUE
REVENUE to EXPENSE
Switch kind for: It is ticked to exchange

ASSET to EXPENSE
EXPENSE to ASSET
LIABILITY to REVENUE
REVENUE to LIABILITY
BALANCE to FLOW
FLOW to BALANCE
Qlik View Interview Questions
Question 19. What Is Dynamic Member List?

Answer :

As size individuals are delivered and deleted, the dynamic member listing routinely reflects the changes by means of reapplying the person-described criteria.

Question 20. What Are The Balance Types Of Journals?

Answer :

Balanced
Un Balanced
Balanced through entity
Qlik Sense Interview Questions
Question 21. Can We Load Data In Multiple Currencies Per Entity?

Answer :

You can't load multiple currencies to one entity, due to the fact in attributes you may provide simplest one forex in Def Currency.

Question 22. What Is Data Lock?

Answer :

A consumer-controlled mechanism that prevents adjustments to data consistent with precise criteria, along with period or state of affairs

Question 23. How Do You Lock The Data?

Answer :

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

Sales Forecasting Interview Questions
Question 24. How Do You Eliminate Intercompany Transactions?

Answer :

Intercompany transactions are removed through plug account.

Steps:

Create plug account in account measurement
Tick the test box referred to as IS ICP in account size
Tick the check box called IS ICP in Entity size
Load the ICP rule report.
Then routinely the distinction between the Intercompany transactions can be transferred to plug account
Oracle Data Integrator (ODI) Interview Questions
Question 25. What Is Triangulation?

Answer :

A way of changing balances from one forex to some other via a 3rd not unusual forex. In Europe, that is the euro for member international locations. For example, to transform from French franc to Italian lira, the common forex is described as European euro. Therefore, with the intention to convert balances from French franc to Italian lira, balances are transformed from French franc to European euro

Triangulation manner doing translation from supply forex to any currency aside from vacation spot foreign money.

Example:

If u have USD, EURO & YEN our source foreign money is USD & vacation spot currency is YEN if u need to translate from USD to EURO, machine will translate first from USD to YEN & then YEN to EURO in opposite way.

Question 26. Services Dependency Means?

Answer :

Hyperion is dependent on services. Means services are to be commenced in a special sequence. Simplest

Question 27. How Do You Load The Data Into Hfm?

Answer :

HFM directly can not take the statistics from ERP programs. So the facts need to be downloaded from ERP and loaded into Upstream device like FDM and ODI and many others. Then it ought to be mapped with HFM. And then load that into HFM.

IBM BPM Interview Questions
Question 28. What Is Hfm Architecture?

Answer :

Hyperion Financial Management is designed to perform as a multi tier device.

Client tier: The consumer tier contains the person interface and the capability to talk with the software tier. You can show information and metadata, enter records, and keep metadata in this tier.

Web tier: The Web server tier incorporates the Web server. You can get entry to the Web-enabled portions of Hyperion Financial Management on this tier. The Hyperion Financial Management Web purchaser consists of all functionality available in the Windows purchaser excluding protection administration.

Middle tier: The center tier incorporates the area intelligence and connections to the relational database.

Database tier: The information tier consists of the relational database and all Hyperion Financial Management statistics and metadata.

Question 29. How Many Account Types In Hfm?

Answer :

We have 10 Account kinds in HFM.

Note : Please refer Account size in Metadata.

Question 30. How Do Different Cell Colors Indicate In Hfm? (ask Any Specific Color)?

Answer :

Blue- Header mobile
Off White -An enter cell. You can manually input or edit facts.
Light Yellow -Locked or derived cellular
Light Gray Text -No write or Read get admission to, or may be derived records
Dark Yellow-Indicates this sort of situations:
Cell records has been modified however has no longer been stored
The enter popularity is OK, however the fame of the adjustment isn't always OK (CH, CN, or TR)
Light Green -Allows allocations and derived facts
Dark Green -Read-simplest
Orange -Invalid POV (Point of View) intersection
Question 31. How Many Types Of Adjustments We Can Post.?

Answer :

In HFM we've got:

Entity Currency Adjs
Parent Currency Adjs
Parent Adjs
Contribution Adjs
Question 32. Journal Review Process?

Answer :

Create magazine.
Submit the magazine.
Receive approval or Reject.
Post magazine.
Question 33. How Many Level Of Security In Hfm?

Answer :

User authentication
Task securities
Document securities (Data grids and forms, journals, reviews)
Data safety
Oracle DBA Troubleshooting Interview Questions
Question 34. How Many Plug Accounts We Can Create?

Answer :

In HFM, we will create range of plug bills, but primarily based on requirement we are able to create the plug bills for elimination technique.

Question 35. How Many Access Levels For Security Classes In Hfm

Answer :

All
Metadata
Read
Promote
None
Question 36. What Is Good Will ?

Answer :

Goodwill in economic statements arises when a organization is bought for greater than the honest value of the identifi capable  internet assets of the enterprise. The distinction among the acquisition price and the sum of the truthful value of the net property is by means of definition the fee of the "goodwill" of the purchased agency. The obtaining business enterprise must understand goodwill as an asset in its economic statements and present it as a separate line item on the balance sheet.

MongoDB Interview Questions
Question 37. What Are The Types Of The Reports Used In Your Project. What Does Each Report Contain In Brief?

Answer :

Reports are not specific it will be created as per patron necessities

Example: Forecast ebook, Audit e-book in every e book almost balance sheet, earnings assertion, coins float statements may be there.

Question 38. How Many Instances Have You Used In Your Project?

Answer :

Environment like Development, trying out , production.

Question 39. Explain About Member Attributes?

Answer :

Member attributes are differed from size to dimension; each size member will be having significance to their respective areas.

Question 40. What Is Alternative Hierarchy?

Answer :

For exceptional reporting purposes we will create opportunity hierarchies, in trade hierarchy one member may be shared by multiple determine, however the default figure can be simplest one.

Oracle Hyperion Planning Interview Questions
Question forty one. Enable Metadata Security Filtering?

Answer :

This setting specifies whether users of an software see all dimension contributors or most effective those to which they have get entry to. (Means we are able to see the metadata particular entity best which we've proper)

Question forty two. Where Is Hfm Data Available?

Answer :

Data is saved at the cells formed by way of the intersection of the individuals of the unique measurement contributors in the sub cube. All aggregations and calculations are achieved on records in sub cubes retrieved into RAM at the utility server. And I wish the statistics also be available in the database server.

Qlik Sense Interview Questions
Question forty three. How Do You Create Icp Member In Hfm?

Answer :

Following are device described participants for ICP measurement.

[ICP Top] Specifies the pinnacle 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 whilst you select the IsICP characteristic, see the under in your reference.

When you create an utility, Intercompany Partner participants are routinely created for the application. An ICP member is created for every Entity member for which the IsICP characteristic is selected.

Question 44. Explain About Entity Curr Adj Member In Hfm?

Answer :

Basically fee measurement participants are inter-associated with so many regions in HFM, however in brief speaking approximately Entity Curr Adj you may make any adjustments using journals into this precise fee dimension, right here you can carry out caluclate and posting journals.

Question 45. What Is Application Profile, Can We Change Application Profile At Any Point Of Time?

Answer :

An utility profile contains language, calendar, frequency, and period data for an application. You can use a profile for multiple application. For each application that you create, you should specify an utility profile.

You can't adjust the application profile as soon as it was created.

Question 46. What Are Custom Top Members?

Answer :

The Custom top member for the account
The distinctive member, which includes all descendants, is legitimate for the account
Question 47. What Is Data Audit In Hfm?

Answer :

You can use the Data Audit characteristic to view records adjustments carried out through users. You can filter out the information modifications via date variety, utility server, user, and the dimension individuals of cells.

You can audit Scenario and Account participants through placing the Enable Data Audit metadata attribute to Y for the scenarios and money owed to audit. To turn off auditing of Scenario and Account participants, trade the Enable Data Audit attribute to N.

Question 48. What Is Minority Interest In Hfm?

Answer :

Relates to ownership management, it'll arrived with the aid of the formulation

PMIN = PCON-POWN

Percent of minority interst is equl to Percent of consolidation minus percentage possession.

Question forty nine. How To Get Prior Year Retained Earnings?

Answer :

By the use of regulations we can acquire it

Question 50. What Are Different Ways Of Running Consolidation In Hfm?

Answer :

Manual consolidation by the usage of grids.
Consolidation using mission automation
Custom consolidation through the use of rules.