Hb140 - Hyperion Smart View

15 Questions | By Amorgan3 | Last updated: Mar 22, 2022 | Total Attempts: 40

Questions

Settings

Create your own Quiz

Please answer the following questions regarding Hyperion Smart View.

Questions and Answers

1.

True or False. Using Smart View allows you to view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint
- A.
  
  True
- B.
  
  False
2.

To begin using Smart View, you must first open which Microsoft Office product?
- A.
  
  Word
- B.
  
  Excel
- C.
  
  PowerPoint
- D.
  
  Project
3.

What "manager" is used to connect your Smart View data sources and manage your connections?
- A.
  
  Data Source Manager
- B.
  
  Connection Source Manager
- C.
  
  Ad hoc Source Manager
- D.
  
  Common Source Manager
4.

The Options dialog box contains which of the following options:
- A.
  
  Ad-hoc
- B.
  
  Display
- C.
  
  Cell Styles
- D.
  
  All of the above
5.

To quickly view the source data that is stored at the Base-level member of a dimension's hierarchy, which option in the ad-hoc tab would you choose?
- A.
  
  Supress Rows > Zero
- B.
  
  Mode > Navigate without Data
- C.
  
  Hierarchy > Bottom level
- D.
  
  Member Retention > Remove Unselected Groups
6.

In the Display tab, the Replacement option enables you to define labels for which of the following:
- A.
  
  Missing Values
- B.
  
  Missing Formulas
- C.
  
  Missing Formatting
- D.
  
  Missing Connections
7.

When you zoom-in on a dimension member, it is expanded according to the settings in which of the following dialog boxes?
- A.
  
  Business Rules dialog box
- B.
  
  Connections dialog box
- C.
  
  Options dialog box
- D.
  
  Formatting dialog box
8.

If you want to be able to double-click to zoom-in on a dimension member, you must first do what?
- A.
  
  Click the Zoom button
- B.
  
  Select Mouse Operation on the Ad-Hoc tab in the options dialog box
- C.
  
  Select Double-click from the View menu in the options dialog box
- D.
  
  Any of the above
9.

A grid must have at least how many dimensions in the rows and columns for pivoting to be possible?
- A.
  
  Only one in either the row or column
- B.
  
  At least two in either the row or column
- C.
  
  None The row or column may be blank
- D.
  
  At least one in both the row and column
10.

If you want to be able to suppress repeated dimension members listed for each row, you must first do what?
- A.
  
  Hide each row that contains the repeated dimension member
- B.
  
  Select Repeated Members on the Ad-hoc tab in the Options dialog box
- C.
  
  Delete each cell that contains the repeated dimension member
- D.
  
  Select #NoData/Missing Laabel on the Display tab in the Options dialog box
11.

By default, the Smart Tags feature is turned off. To turn Smart Tags on, which of the following steps needs to be taken?
- A.
  
  Select: View > Smart Tags
- B.
  
  Select: View > Options > Smart Tags
- C.
  
  Select: Tools > AutoCorrect Options
- D.
  
  None of the above
12.

In order to use Smart Tags, the document must be connected to what?
- A.
  
  A Point of View
- B.
  
  A Data Source
- C.
  
  A Workspace
- D.
  
  A Worksheet
13.

True or False. Smart View enables you to copy data points from Excel and paste them into Word or PowerPoint documents, creating linked views (dynamic data points) between applications.
- A.
  
  True
- B.
  
  False
14.

To retrieve the Excel queries for a data point that was copied into a Word or PowerPoint document, which of the following steps needs to be taken:
- A.
  
  Select: View > Visualize in Excel
- B.
  
  Select: Link View > Visualize in Excel
- C.
  
  Select: Hyperion > Link View > Visualize in Excel
- D.
  
  Select: Options > Visualize in Excel
15.

What do you use to change the POV once the Excel data points are copied into word or PowerPoint?
- A.
  
  Options dialog box
- B.
  
  POV Manager
- C.
  
  Right-click menu
- D.
  
  Query designer