The Best BEA certifications -Visualexams ccna-dumps.com help you pass any IT exams

4h0-435 Free Demo Download

Certinside offers free demo for 4h0-435 184 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-435 Exam Pdf Demo

Download 4h0-435 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-435
Title : Hyperion Financial Management v3.51 Exam

1. Given the following information:
Account Fixed Assets with Account Attribute Asset and Top Custom 1 Member set to Flow
Custom 1 Hierarchy Switch Sign for Flow AggrWeight
Flow
BeginBalance N 1
Additions N 1
Disposals Y 1
EndingBalance N 0
Data
BeginBalance 10,000
Additions 2,000
Disposals 4,000
Ending Balance 12,000
What is the final result at the <Entity Currency> value for Account Fixed Assets and Custom1 set to Flow?
A. 8,000
B. 12,000
C. 16,000
D. 20,000
Answer: A

2. When a Consolidate All With Data is run, what best describes the result?
A. A consolidation is run for all descendants.
B. A consolidation is run for all descendants with data.
C. A calculation is run for all impacted descendants with data.
D. A consolidation is run for all impacted descendants with data.
Answer: B

3. You are adding an Entity member to a metadata file. Which attribute, in addition to the Member attribute, must the user add in order to load the metadata file?
A. Description
B. DefCurrency
C. Security Class
D. SecurityAsPartner
Answer: B

4. In which Value dimension element can the HS.Con function write data?
A. [Elimination]
B. [Contribution]
C. [Parent Total]
D. <Parent Currency>
Answer: A

5. Click the Exhibit button. You are consolidating WW China for the following POV:
Account Sales
ICPWW Brazil
Custom1 Product1
Custom2 [None]
Custom3 Wholesale
Custom4 Manual_Input
Which HS.Con statement is invalid?
A. HS.Con ("V#[Elimination]",-1,"SalesElim")
B. HS.Con ("V#[Elimination].A#SalesPlug",-1,"")
C. HS.Con ("V#[Elimination].E#WWKorea","","")
D. HS.Con ("V#[Elimination].I#WWBrazil",0.80,"")
E. HS.Con ("V#[Elimination].E#WWBolivia",0.80,"")
Answer: E

6. What can be extracted using Extended Analytics? (Choose two.)
A. data
B. metadata
C. incremental data
D. metadata changes
Answer: AB

7. Where can data be stored in the system?
A. a parent level in the Entity dimension
B. a parent level in the Account dimension
C. a parent level in the Custom1 dimension
D. the [Parent] element in the Value dimension
Answer: A

8. When creating an Intercompany Matching Report, which two dimensions appear when Add is selected for Account Entities or Account Partners? (Choose two.)
A. ICP
B. Entity
C. Value
D. Account
E. Custom (1..4)
Answer: DE

9. In a Web Data Entry Form script, what is the proper syntax for calling an Account list named IncomeStatement?
A. A{IncomeStatement}
B. A#{IncomeStatement}
C. A#.IncomeStatement
D. A#IncomeStatement
E. A[IncomeStatement]
Answer: A

10. A client wants to optimize the performance of user authentication in their environment. Most users are stored in the iPlanet LDAP server named earth. Within the css.properties file, which search order best meets their needs?
A. com.hyperion.css.searchorder =
?(ldap://earth:389/dc=users,dc=com(ntlm?earth(msad?(ldap://10.0.0.4:389/dc=users:dc=com
B. com.hyperion.css.searchorder =
?(ntlm?earth(msad?(ldap://earth:389/dc=users,dc=com(ldap://10.0.0.4:389/dc=users:dc=com
C. com.hyperion.css.searchorder =
?(ntlm?earth(msad?ldap://10.0.0.4:389/dc=users:dc=com(ldap://earth:389/dc=users,dc=com
D. com.hyperion.css.searchorder =
?(ntlm?earth(ldap://earth:389/dc=users,dc=com(msad?ldap://10.0.0.4:389/dc=users:dc=com
Answer: A

11. 0.0.4:389/dc=users:dc=com
B. com.hyperion.css.searchorder =
?(ntlm?earth(msad?(ldap://earth:389/dc=users,dc=com(ldap://10.0.0.4:389/dc=users:dc=com
C. com.hyperion.css.searchorder =
?(ntlm?earth(msad?ldap://10.0.0.4:389/dc=users:dc=com(ldap://earth:389/dc=users,dc=com
D. com.hyperion.css.searchorder =
?(ntlm?earth(ldap://earth:389/dc=users,dc=com(msad?ldap://10.0.0.4:389/dc=users:dc=com
Answer: A
9. You are adding an Entity member to a metadata file. Which attribute, in addition to the Member attribute, must the user add in order to load the metadata file?
A. Description
B. DefCurrency
C. Security Class
D. SecurityAsPartner
Answer: B
10. What are two types of member lists? (Choose two.)
A. system
B. optional
C. dynamic
D. end-user
Answer: AC

12. You are extracting information using Extended Analytics. Which list shows all the dimensions that allow for multiple members?
A. Scenario, Year, Period, Custom1, Custom2, Custom3, Custom4
B. Scenario, Year, Period, Entity, Account, Custom1, Custom2, Custom3, Custom4
C. Scenario, Year, Period, View, Entity, Account, Custom1, Custom2, Custom3, Custom4
D. Scenario, Year, Period, View, Entity, Value, Account, ICP, Custom1, Custom2, Custom3, Custom4
Answer: D

13. Where is a Hub Data integration group executed for an HFM Administrator?
A. the Hub Integration Console
B. the Manage Data web screen within HFM
C. the Hub Integration deployment executable
D. from a HAL deployment which calls the Hub integration
Answer: B

14. A user needs to create an integration that will allow a master application to overwrite a sub application’s values, but not the reverse. How is this accomplished?
A. Mark the source application as read only.
B. Define the source application as master.
C. Choose the override check box in the integration definition.
D. Define the destination application as slave to the source application.
Answer: C

15. Registering the Report server with Hub allows you to set up links to related content with which three products? (Choose three.)
A. Hyperion Central
B. Hyperion Analyzer
C. Hyperion Strategic Finance
D. Hyperion Application Builder
Answer: ABD

16. Which three permissions can End Users be assigned for Report Groups in Hyperion Analyzer? (Choose three.)
A. View
B. Read
C. Modify
D. Owner
E. Update
Answer: BDE

4H0-004 Free Demo Download

Certinside offers free demo for 4H0-004 104 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4H0-004 Exam Pdf Demo

Download 4H0-004 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-004
Title : HCP-Hyperion System 9 Financial Management 4.1

1. System Journal Reports require _____ to be generated and saved. (CHOOSE TWO)
A. Journal Filters
B. a report description
C. a Report Style Sheet
D. the columns that have been defined
Answer: CD

2. When using the HFM HAL adapter, which are Export Data Criteria options?
A. Scenario, Year, View, Entity, Accounts
B. Scenario, Year, Entity, Accounts, Value, ICP
C. Scenario, Year, Custom1, Custom2, Custom3, Custom4
D. Scenario, Year, Entity, Accounts, Custom1, Custom2, Custom3, Custom4
Answer: A

3. What are three available methods for the HFM HAL adapter? (CHOOSE THREE.)
A. Import Data
B. Import Journals
C. Export Journals
D. Open Application
E. Set Logon Information
Answer: ADE

4. Which formula retrieves the data for January sales in Smart View?
A. =HsGetCell("A#Sales.P#January.")
B. =HsGetValue("Account#Sales.Period#January.")
C. =HsGetCell("Account#Sales.Period#January.")
D. =HsGetValue("A#Sales.P#January.")
Answer: B

5. You are performing a data extract using the Extract Data module. From which three dimensions can you make multiple selections? (CHOOSE THREE.)
A. Value
B. Entity
C. Period
D. Account
E. Scenario
Answer: BCD

6. Extended Analytics uses which format for the extracted information?
A. ASCII File
B. Star Schema
C. Snow Flake Diagram
D. Comma Delimited File
Answer: B

7. In Smart View, Excel formulas that you add to data cells are automatically preserved in which of these actions? (CHOOSE THREE)
A. Using the Keep Only or Remove Only function.
B. Zooming in or zooming out.
C. Pivoting data from a row to a column.
D. Refreshing the Ad Hoc grid.
Answer: ABD

8. What types of documents can be selected as related content in Financial Reporting? (SELECT THREE)
A. An Interactive Reporting Report
B. Any web page
C. A Web Analysis Report
D. An HFM Web Form
E. A Planning form
Answer: ABC

9. To use Multiple data sources in Financial Reporting, the data sources:
A. Need to be defined on separate reports inside a book.
B. Can be on the same page, but segregated by grid.
C. Can be assigned by Row and Column.
D. Can be assigned to specific cells.
Answer: C

10. Which two must be selected to enable the Data Audit feature for selected accounts? (SELECT TWO)
A. DataAuditTrail in the ApplicationSettings
B. Data Auditing in the Data Audit Window
C. EnableDataAudit on the selected Accounts
D. Y for the EnableDataAudit property in the Scenario dimension
E. O for the EnableDataAudit property in the Scenario dimension
Answer: CE

11. When using the HFM HAL adapter, which are valid Import Data Method options?
A. Replace, Merge, Aggregate
B. Merge, Accumulate, Remove
C. Accumulate, Replace, Clear
D. Merge, Replace, Accumulate
Answer: D

12. SCENARIO: User A is created in Hyperion Reports and is assigned the role of Viewer. User A is then assigned to Group B which has the roles of Security Administrator and System Administrator. Which role(s) does User A have in Hyperion Reports?
A. Viewer only
B. Designer and Viewer only
C. System Administrator and Security Administrator only
D. System Administrator, Security Administrator, Designer, and Viewer
Answer: D

13. You are extracting information using Extended Analytics. Which list shows all the dimensions that allow for multiple members?
A. Scenario, Year, Period, Custom1, Custom2, Custom3, Custom4
B. Scenario, Year, Period, Entity, Account, Custom1, Custom2, Custom3, Custom4
C. Scenario, Year, Period, View, Entity, Account, Custom1, Custom2, Custom3, Custom4
D. Scenario, Year, Period, View, Entity, Value, Account, ICP, Custom1, Custom2, Custom3, Custom4
Answer: D

14. Which two statements are true about a User Point of View in Hyperion Analyzer Reports? (CHOOSE TWO)
A. A User Point of View cannot be deleted.
B. A User Point of View can be shared with other users.
C. Users can only superimpose a Point of View on reports using the same database connection
D. The User Point of View checkbox in Cube Navigator enables and disables the Point of View for the database query.
Answer: CD

15. What can be extracted using Extended Analytics? (CHOOSE TWO)
A. data
B. metadata
C. incremental data
D. metadata changes
Answer: AB

16. What are three roles in HFM security? (CHOOSE THREE)
A. Run Allocation
B. Delete Journals
C. Create Unbalanced Journals
D. Save System Report on Server
Answer: ACD

4h0-100 Free Demo Download

Certinside offers free demo for 4h0-100 52 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-100 Exam Pdf Demo

Download 4h0-100 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-100
Title : Hyperion seebase bridge certification exam

1. How can query retrieval of databases that contain Attribute dimensions be optimized? (Choose two.)
A. Order Attribute dimensions smallest to largest
B. Place Base dimensions before other Sparse dimensions
C. Place the most-queried Base dimension at the end of the Sparse dimensions
D. Place Attribute dimensions in the outline after all Dense and Sparse dimensions
Answer: BD

2. When would you select User-Defined Attribute (UDA) functionality, as opposed to Attribute dimension functionality? (Choose two.)
A. When providing crosstab reports
B. When providing filtering on Dense dimensions
C. When utilizing Attribute Calculations dimensions
D. When attributes need to be applied across multiple dimensions
Answer: BD

3. The BEGINARCHIVE and ENDARCHIVE commands are used to _____.
A. export only a partial area of a database
B. back up Essbase files while Essbase is still running
C. back up Essbase files after Essbase has been shut down
D. shut down Essbase and make a complete backup of the current database
Answer: B

4. Which two statements about Attribute dimensions are true? (Choose two.)
A. Attribute dimensions can contain hierarchies.
B. Attribute dimensions can be based on dense dimensions.
C. Attribute dimensions can be used by multiple Base dimensions.
D. Attribute dimensions are dynamically calculated at query time.
E. Attribute dimensions track historical changes to the associated base members.
Answer: AD

5. In which file is a record of all modifications made to the source outline saved?
A. .chg
B. .ddb
C. .ind
D. .mod
E. .par
Answer: A

6. What creates fragmentation in a database?
A. Renaming a member in the outline
B. Deleting a member from a Dense dimension
C. Deleting a member from a Sparse dimension
D. Deleting a shared member from a Dense dimension
Answer: C

7. Given the following:
Committed access
Pre-image disabled
Wait time equal to 0
What happens if a spreadsheet retrieval is attempted while a calculation is being performed?
A. The data are retrieved.
B. A Time Out message is displayed.
C. Precalculated data are retrieved.
D. The user waits a specified number of seconds.
Answer: B

8. Which type of member cannot have a User-Defined Attribute (UDA)?
A. Time
B. Shared
C. Account
D. Dynamic Calc
Answer: B

9. What does the Data File Cache contain?
A. Compressed data blocks
B. Uncompressed data blocks
C. The addresses of data blocks on the disk
D. A record of recently accessed data blocks
Answer: A

10. Which statement describes the @ATTRIBUTEVAL function?
A. It is used for NUMERIC and BOOLEAN Attribute types only.
B. It returns the numeric value associated with level-0 Attribute members.
C. It returns a list of all Base members that are associated with a specific Attribute member name.
D. It returns a list of all Attribute dimension members that are associated with a specific Base member name.
Answer: B

11. Given the following calculation script and a total of 32 data blocks, how many blocks will be calculated?
SET CLEARUPDATESTATUS ONLY
CALC ALL;
A. 0
B. 8
C. 16
D. 32
Answer: A

12. Which two statements are true when using Attribute dimension members in calculation functions? (Choose two.)
A. Attribute dimension members cannot be assigned calculated data.
B. The FIX command can contain Attribute dimension members only.
C. The CALC DIM command can be used to aggregate an Attribute dimension.
D. The FIX command can contain Attribute functions to derive Base dimension member lists.
Answer: AD

13. Given the following Essbase.cfg file, which command is used in a calculation script to create an Event log entry at 2% intervals?
CALCNOTICELOW 5
CALCNOTICEHIGH 50
CALCNOTICEDEFAULT 20
A. SET NOTICE 2;
B. SET NOTICE LOW;
C. SET NOTICE HIGH;
D. SET NOTICE DEFAULT;
Answer: C

14. Which option lists the cache settings from the highest priority to the lowest priority for optimal performance?
A. Index Page size, Data File Cache size, Index Cache size, Data Cache size
B. Data File Cache size, Index Cache size, Data Cache size, Index Page size
C. Data Cache size, Index Cache size, Data File Cache size, Index Page size
D. Index Cache size, Index Page size, Data File Cache size, Data Cache size
Answer: D

15. Which file should be deleted when repairing a corrupted partition?
A. *.db
B. *.dbb
C. *.ddb
D. *.par
Answer: C

16. Click the Exhibit button.
In the outline shown in the exhibit, Year and Measures are Dense dimensions. Data are loaded for every Month, Measure, Market, and Scenario.
After a CALC ALL is run, how many blocks are there?
A. 12
B. 18
C. 24
D. 30
Answer: A

4h0-533 Free Demo Download

Certinside offers free demo for 4h0-533 200 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-533 Exam Pdf Demo

Download 4h0-533 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-533
Title : Hyperion planning v.3.3.1

1. Which five tasks are performed when setting up a Hyperion Planning application? (Choose five.)
A. Setting up plan types
B. Creating the calendar
C. Setting up exchange rates
D. Defining the calendar range
E. Setting up multiple currencies
F. Defining base time period and weekly distribution.
Answer: ABDEF

2. What is the correct order Hyperion Planning will follow to generate a Web Form with Suppress Missing data enabled?
A. Hyperion Planning Web Application suppresses missing data;sends the query to Hyperion Essbase;checks Metadata security for the user; displays Web Form to Client
B. Checks Metadata Security for the User; sends the query to Hyperion Essbase; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
C. Sends the query to Hyperion Essbase; checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
D. Checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; sends the query to Hyperion Essbase; displays Web Form to Client
Answer: B

3. Which three options are supported authentication providers for CSS? (Choose three.)
A. NTLM
B. Microsoft Active Directory
C. Sun Open Net Environment (Sun ONE)
D. Novell NDS
E. BEA’s LDAP Provider
Answer: ABC

4. Which three are valid properties of Scenarios with the Hyperion Planning Web Dimension Editor? (Choose 3)
A. Access Rights
B. Time Periods
C. Data Storage
D. Exchange Rate Table
Answer: ABD

5. Supporting Detail can have which two properties? (Choose two.)
A. Detail cannot be deleted once created.
B. Data can be filled across a series of columns.
C. Detail can be retrieved in the Spreadsheet Add-in.
D. It can only be text information, no data can be input.
E. Data can be in hierarchical form and include aggregation of values.
Answer: BE

6. When refreshing the database in a multi-currency application, what can be selected to create a Currency Conversion Calc Script?
A. Currencies, Scenarios, Version Type, and Versions
B. Currencies, Scenarios, Years, and Exchange Rate Type
C. Currencies, Scenarios, Years, Version Type, and Versions
D. Currencies, Scenarios, Years, Exchange Rate Type, and Versions
Answer: A

7. After creating a new Hyperion Planning application, what are two steps that must be taken for it to appear as a valid Web application at the Web LogOn page? (Choose two.)
A. Restart the Essbase server
B. Run the HspSetupSupport utility
C. Restart the Web application server
D. Within Hyperion Planning, select Enable Web LogOn
Answer: BC

8. After the calendar is created through the application setup, which statement is true?
A. You can change the rollup structure.
B. You can change the base time periods.
C. You can change the weekly distribution setting.
D. You can reduce the number of years in the calendar.
Answer: A

9. When using the Hyperion Planning ADM driver within Hyperion Reports, which function is used to select Attribute members?
A. Property
B. Member
C. Relative Member
D. Range
Answer: A

10. What is the ideal data block size?
A. Between eight and 100 kilobytes
B. Between 101 and 250 kilobytes
C. Between 251 and 500 kilobytes
D. Greater than 500 kilobytes
Answer: A

11. Which two Hyperion Application Link Adapters can be used together to load data? (Choose two.)
A. Essbase Adapter
B. Flat File Adapter
C. Web Form Adapter
D. Hyperion Planning Adapter
Answer: AB

12. Which three statements are true about the Cut function in the Hyperion Planning Dimension Editor? (Choose three)
A. It is not available for root dimension members.
B. It remembers a cut member if the administrator expands, collapses, sorts, searches, or changes pages in a dimension hierarchy.
C. It remembers a cut member if the administrator adds a child or sibling member, edits or deletes a member, assigns access to a member or clicks the View link.
D. It remembers a cut member if the administrator adds or edits a dimension, navigates to a page other than the Dimensions tab, deletes a member, or logs off Hyperion Planning.
E. It allows for mulitple cut selections at the same level.
Answer: ABC

13. What three properties can be defined for User-defined custom dimensions? (Choose three.)
A. Name
B. Security
C. Data type
D. Source plan type
E. Custom attributes
Answer: ABE

14. Which three tasks can be performed by a Planner? (Choose three.)
A. Modify Web forms
B. Input, submit, and view data
C. View data through Hyperion Reports
D. Use Hyperion Planning Spreadsheet Add-in
E. Create and update rules in Hyperion Business Rules (HBR)
Answer: BCD

15. In a multi-currency application, a calc script was created using Hyperion Planning Desktop. The following selections were made: "USD", "CAD", Budget, "1st Draft" and "Bottom-Up." What will be converted after the Currency Conversion Calc Script is run?
A. Parent members
B. Level zero members
C. Forecast Scenario for the USD Currency
D. Saved Assumption account with Percentage Data Type
E. Saved Assumption account with Non-Currency Data Type
Answer: B

16. Which two statements about account level annotations are true? (Choose two.)
A. Account level annotations can have 1500 characters.
B. Only parent level members can have account level annotations.
C. To enable the account level annotations, the Web form design does not matter.
D. A specific option must be selected in the display options page to enable the account level annotations.
Answer: AD

4h0-028 Free Demo Download

Certinside offers free demo for 4h0-028 100 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-028 Exam Pdf Demo

Download 4h0-028 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-028
Title : Hyperion Certified Professional – System 9 Planning 4.1

1. Which element can be changed after the Hyperion Planning application has been created?
A. weekly distribution spread
B. default currency
C. number of years
D. number of plan types
E. starting fiscal year and month
Answer: C

2. When defining the base time period and weekly distribution methods, which statement is true?
A. If you select a Weekly distribution method, Hyperion Planning sets every account member to that distribution method.
B. The weekly distribution pattern options are available only if you select the base time period option 12 Months.
C. If you select the 4-4-5 pattern, Hyperion Planning treats the first month in a quarter as if it has four weeks, and the last two months in the quarter as if they have five weeks.
D. Hyperion Planning allows you to set up weekly distribution patterns, which determine how values are spread when the base time period is monthly.
E. Hyperion Planning automatically distributes the value over the base time periods that make up the summary time period.
Answer: E

3. During the initial application setup, two plan types were created. The administrator now wants to add a third plan type. How can this be accomplished?
A. After the application has been created, the number of plan types cannot be changed via the Planning Desktop.
B. Go to Manage Database and create a new plan type.
C. Go into Analytic Administration Services and create a new database for this application.
D. Walk through Setup Application again for the same application.
Answer: A

4. What is the danger in using the Create Blocks action?
A. Calculations on Sparse members will return the number missing.
B. It causes corruption in the database.
C. It overrides your data stored in these blocks.
D. The database potentially grows with unneeded blocks.
Answer: D

5. What option contributes to making an Enhanced Calc Script more flexible over a native Calc Script?
A. Run on save
B. @CALCMODE function
C. Run-time prompts
D. Can be run from the Planning web
Answer: C

6. Which three statements are true about using the formula Variable component in Hyperion Business Rules (HBR)? (CHOOSE THREE)
A. Can apply to multiple business rules
B. Can be derived from a calculation
C. Multiple variables can be used within a single business rule
D. Represents a single numeric value
Answer: BCD

7. Which three predefined types of base time periods can be established when creating the calendar? (CHOOSE THREE)
A. Weekly
B. Monthly
C. Quarterly
D. Yearly
E. Custom
Answer: BCE

8. Which two statements are true about assigning members to plan types? (CHOOSE TWO)
A. If User-defined custom dimension has been assigned to a plan type in the application, you cannot assign which members are valid in that plan type.
B. If the plan type is not assigned to a member, that member’s children will not have access to that plan type or its aggregation options.
C. If you have more than one plan type in an application, you cannot assign more than one plan type to an individual dimension member.
D. If you use a User-defined custom dimension, you can specify the source plan type for the members.
Answer: AB

9. Which two statements are true? (CHOOSE TWO)
A. You can assign only aggregation options to User-defined custom dimension members.
B. You can assign plan types and aggregation options to User-defined custom dimension members.
C. You can assign only aggregation options to Entity dimension members.
D. You can assign plan types and aggregation options to Entity dimension members.
Answer: AD

10. What action creates the HSP_Rates dimension?
A. Creating a new Exchange Rate table and refreshing the application
B. Setting up an application that supports multiple currencies
C. Creating a new currency and refreshing the application
D. Running a Currency Conversion CalcScript during a refresh
Answer: B

11. Plan Type 1 is specified as the source plan type for a member. This member is selected on a form associated with Plan Type 2. Which statement is true?
A. Assuming write access to the member, the user can enter data to the member on the form.
B. Assuming the planning unit is promoted to the user, the user can enter data to the member on the form.
C. The member is not displayed on the form.
D. The user will see the member displayed as read-only on the form.
Answer: D

12. A Hyperion Business Rule is launched from a Web form. What will Hyperion Planning utilize to provide a valid list of members for a run-time prompt?
A. Members defined on a Hyperion Planning web form
B. Hyperion Planning Metadata security
C. Hyperion Business Rules run-time prompt security
D. Hyperion Analytic Services Security Filters
Answer: B

13. When should you use multiple plan types?
A. When detailed revenue information must be separate from high-level P and L summary accounts
B. When multiple currencies must be kept in a separate database
C. When exchange rates must be kept in a separate database
D. When data cannot be shared across an organization
Answer: A

14. The Create Blocks component within Hyperion Business Rules (HBR) is used for the purpose of creating blocks for:
A. dense member combinations
B. sparse member combinations
C. dynamically calculated and stored member combinations
D. attribute member combinations
Answer: B

15. What are three aggregation options available within Hyperion Business Rules (HBR)? (CHOOSE THREE)
A. Calculate Database with Dynamic Calc and Store
B. Calculate Database Dynamically
C. Calculate Entire Database
D. Calculate Data with Two Pass Calculations
E. Calculate the Portion of the Database Specified Below
Answer: CDE

16. What must be done prior to using the Create Blocks action in a Hyperion Business Rule (HBR)?
A. Analytic Services database settings Create Blocks on Equation must be selected.
B. Analytic Services configuration file (essbase.cfg) must have the Create Blocks option turned on.
C. Data must be loaded to the blocks prior to running the Hyperion Business Rule.
D. Analytic Services Information must be validated for the potential number of blocks.
Answer: A

4h0-712 Free Demo Download

Certinside offers free demo for 4h0-712 129 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-712 Exam Pdf Demo

Download 4h0-712 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4h0-712
Title : Hyperion Essbase 7x Certifcation Exam

1. Depending on how you want to balance memory usage and data retrieval time, you can customize outline paging for aggregate storage outlines by using one or more settings in the essbase.cfg file.
Which three essbase.cfg settings are used for optimizing outline paging? (Choose three.)
A.CCTRACK
B.OPGCACHESIZE
C.AGTSVRCONNECTIONS
D.PRELOADALIASNAMESPACE
E.PRELOADMEMBERNAMESPACE
Answer: BDE

2. Click the Exhibit button.
Given the Data Prep Editor shown in the exhibit, what defines the field 1 header to build Markets dimension?
A.Gen2, Markets
B.Child0, Markets
C.Level0, Markets
D.Level1, Markets
Answer: C

3. What are three disadvantages of a transparent partition? (Choose three.)
A.old level 0 data
B.redundant storage
C.increased network load
D.higher degree of outline synchronization
E.slower query and calculation performance
Answer: CDE

4. You are using the CALC DIM command to calculate a sparse dimension.
Which SET CLEARUPDATESTATUS setting ensures that all blocks are tagged clean?
A.ON
B.OFF
C.ONLY
D.AFTER
Answer: D

5. Click the Exhibit button.
Given the Rules file shown in the exhibit, how many row(s) will be loaded?
A.1
B.2
C.3
D.4
Answer: B

6. The stored members in the Dense dimension Scenario are Actual and Budget. Database A has Actual and Budget data loaded for all products in all markets. Database B has only the Budget data loaded for all products in all markets.
Which statement about database B is true?
A.The index is half as large as database A.
B.It has half the number of blocks that exist in database A.
C.Block density is reduced by fifty percent from database A.
D.Fifty percent fewer blocks fit in the Data Cache as in database A.
Answer: C

7. What does aggregate storage partitioning support?
A.outline synchronization
B.block storage as the source
C.aggregate storage as the source
D.transparent partition as the target.
Answer: C

8. What is the default column delimiter in the Data Prep Editor?
A.tab
B.comma
C.white space
D.single quote
Answer: A

9. The Essbase.cfg setting DATAFILECACHESIZE can be used to _____.
A.alter Data File Cache size for existing databases
B.optimize calculation performance on large, flat dimensions
C.define the initial Data File Cache size for all newly created databases
D.manage Data File Cache sizes for specific applications and databases
Answer: C

10. When selecting the most optimal dimension in an aggregate storage database to tag as Accounts, you should choose a _____.
A.sparsely populated dimension with formulas
B.densely populated dimension with deep hierarchies
C.sparsely populated dimension with deep hierarchies
D.flat dimension (a dimension that does not have many levels)
Answer: D

11. Click the Exhibit button.
Given the Data Prep Editor shown in the exhibit, what defines the field 3 header to build Markets dimension?
A.UDA0, Markets
B.Level1, Markets
C.Parent0, Markets
D.Userattrib2, Markets
Answer: A

12. Which partition type(s) does aggregate storage partitioning support?
A.transparent partition only
B.replicated and linked partitions only
C.transparent and replicated partitions
D.transparent partitions and joined partitions
Answer: A

13. Which statement is true about the @ATTRIBUTEVAL function?
A.It is used for numeric and boolean Attribute types only.
B.It returns the numeric value associated with level-0 Attribute members.
C.It returns a list of all base members that are associated with a specific Attribute member name.
D.It returns a list of all Attribute dimension members that are associated with a specific base member name.
Answer: B

14. When loading data into an Essbase database that contains attribute dimensions, _____.
A.you can load data to members in attribute dimensions
B.each attribute dimension must be represented in the data load
C.attribute associations with base dimensions can be done after the data load
D.attribute associations with base dimensions are derived during the data load
Answer: C

15. Which caches are used by an aggregate storage database?
A.data cache
B.index cache
C.data file cache
D.aggregate storage cache
Answer: D

16. Which three statements about Substitution Variables are true? (Choose three.)
A.They are stored in the database page file.
B.They can be set as global server settings.
C.They are available for queries in a spreadsheet.
D.They can be set specifically for each application or database.
Answer: BCD

4h0-200 Free Demo Download

Certinside offers free demo for 4h0-200 148 Q & As with Expert Explanations). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.


Download 4h0-200 Exam Pdf Demo

Download 4h0-200 Exam iEngine Demo

　
　
Exam : Hyperion Solutions 4H0-200
Title : Hyperion Enterprise 5 Certification

1. Click the Exhibit button.
Given the ASCII System Load File in the exhibit, which entities are active for period six?
A. Spain
B. France
C. Holland
D. Belgium
E. Portugal
Answer: B

2. Click the Exhibit button.
Given the Organizational Structure and the Edit Name screens in the exhibits, which attributes are inherited by, and will be functional for, MICH.ADJ from the parent MICH? (Choose two.)
A. Scale
B. Journals
C. Currency
D. Chart Logic
E. Eliminations
F. Substructures
Answer: AC

3. In Enterprise, the organization structure’s top entity is CORP. There are two dependents for CORP; USREG and EUROPE. There are three dependents for USREG; MICH, OHIO and TEXAS. There are four dependents for EUROPE; HOLLAND, GERMANY, UK and IRELAND. All basic entities have the same substructure PADJ attached. The top entity for PADJ substructure is PADJ with ADJ and INP as dependents. You add three more dependents to the USREG with the PADJ substructure attached to each of them.
What is the total number of entities and subentities?
A. 13
B. 24
C. 27
D. 33
E. 43
Answer: D

4. What is necessary when setting up automatic intercompany eliminations?
A. Flag each parent entity as Elimination
B. Flag each parent, and all immediate dependents
C. Activate the INTERCO method for the current category
D. Flag the entities which will be valid for intercompany transactions.
E. Do not flag any entity, intercompany is managed via tables in the Account module
Answer: D

5. Click the Exhibit button. Given the Data Entry screens in the exhibits, CALIF and MICH are the only subsidiaries of USREG. After consolidation, what will be the value for GRSALES at USREG?
A. 15,008
B. 23,000
C. 15,800,000
D. 23,000,000
Answer: D

6. Click the Exhibit button.
Given the Organization Structure and the Edit Name screen in the exhibit, where would the intercompany elimination occur between entities UK and GRMN?
A. UK
B. CORP
C. EUROPE
D. CORPELIM
Answer: C

7. Click the Exhibit button. Which entity conversion tables shown in the exhibits can be used in BOTH database load and database extract? (Choose three.)
A. NASIA
B. NMICH
C. NCALIF
D. NCORP
E. NTRANS
F. N_TEXAS
G. NFRANCE
H. NGERMANY
Answer: AEG

8. Where can entity lists be used in Enterprise? (Choose three.)
A. Books
B. Reports
C. Journals
D. Database
E. Data Entry
F. Consolidation
Answer: ABD

9. In Enterprise, what appears in the file if you do a system extract with all options activated? (Choose three)
A. Journals
B. Report labels
C. Security class information
D. Logic/Formula statements
E. Database Load and Extract Formats
Answer: BCE

10. What happens if you activate the Account for Lock and do not have a value of zero in this account for a particular entity in the first period? (Choose two.)
A. You cannot put a journal lock on the entity.
B. You cannot lock the entity in the current period.
C. You cannot lock any following period for the entity.
D. You cannot consolidate the period following the one where the value in the account for lock is not zero.
Answer: BC

11. Click on the Exhibit button. Based on the Organization Structure in the exhibit, the value of GRSALES.AUTO for UK.INP is 200,000 BP and for UK.ADJ it is (?0,000) BP. The AVGRATE for British pounds is 2.000 (multiply) and the AVGRATE for USD is 1.000 (divide). What is the value of UK.TRNS in USD?
A. 95,000
B. 190,000
C. 380,000
D. 420,000
Answer: C

12. Click the Exhibit button.
What could cause the error message in the exhibit? (Choose two)
A. The application.INI file has the wrong App_Path= setting.
B. The application was deleted or moved to another location.
C. The HYPENT.INI file has the wrong AppPath= setting.
D. The HYPENT.INI file has the wrong UserPath= setting.
Answer: BC

13. Click the Exhibit button. Given the Organization Structure and the Edit Name screen in the exhibit, in Enterprise SE which is not a valid attribute for the name/entity EUROPE? (Choose one.)
A. Scale
B. Code
C. Journals
D. Eliminations
E. Intercompany
Answer: D

14. What is a correct currency method for Asset, Liability, and Balance?
A. Balance
B. Local Currency
C. Periodic Value
D. Value at Exchange Rate
Answer: D

15. Click the Exhibit button.
Given the Data Entry screen in the exhibit, the application currency is USD; the entered rate for currency ES (used for PORTUGAL) is divided and the currency for HQ is USD. All entities are in the same scale and all Consolidation Detail options are active.
What will be the result in the translated Consolidation Detail for consolidated and currency-converted account CASH (translated using EOMRATE) for HQ in period JAN 98?
A. 400
B. 2000
C. 10000
D. Nothing appears in the translated DSM.
Answer: A

16. Given the information from the Shares view of C shown below:
What is the maximum number of shares of C, owned by B, that can be entered?
A. 200
B. 300
C. 1000
D. any number
Answer: A