HB140 - Hyperion Smart View

1. 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.

True

False

HB140, Task 5

Explanation

HB140, Task 5

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

True

False

HB140, Task 1

Explanation

HB140, Task 1

3. To begin using Smart View, you must first open which Microsoft Office product?

Word

Excel

PowerPoint

Project

HB140, Task 1

Explanation

HB140, Task 1

4. In the Display tab, the Replacement option enables you to define labels for which of the following:

Missing Values

Missing Formulas

Missing Formatting

Missing Connections

HB140, Task 2

Explanation

HB140, Task 2

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?

Supress Rows > Zero

Mode > Navigate without Data

Hierarchy > Bottom level

Member Retention > Remove Unselected Groups

HB140, Task 2

Explanation

HB140, Task 2

6. A grid must have at least how many dimensions in the rows and columns for pivoting to be possible?

Only one in either the row or column

At least two in either the row or column

None The row or column may be blank

At least one in both the row and column

HB140, Task 3

Explanation

HB140, Task 3

7. If you want to be able to suppress repeated dimension members listed for each row, you must first do what?

Hide each row that contains the repeated dimension member

Select Repeated Members on the Ad-hoc tab in the Options dialog box

Delete each cell that contains the repeated dimension member

Select #NoData/Missing Laabel on the Display tab in the Options dialog box

HB140, Task 3

Explanation

HB140, Task 3

8. The Options dialog box contains which of the following options:

Ad-hoc

Display

Cell Styles

All of the above

HB140, Task 2

Explanation

HB140, Task 2

9. What "manager" is used to connect your Smart View data sources and manage your connections?

Data Source Manager

Connection Source Manager

Ad hoc Source Manager

Common Source Manager

HB140, Task 1

Explanation

HB140, Task 1

10. When you zoom-in on a dimension member, it is expanded according to the settings in which of the following dialog boxes?

Business Rules dialog box

Connections dialog box

Options dialog box

Formatting dialog box

HB140, Task 3

Explanation

HB140, Task 3

11. What do you use to change the POV once the Excel data points are copied into word or PowerPoint?

Options dialog box

POV Manager

Right-click menu

Query designer

HB140, Task 5

Explanation

HB140, Task 5

12. In order to use Smart Tags, the document must be connected to what?

A Point of View

A Data Source

A Workspace

A Worksheet

HB140, Task 4

Explanation

HB140, Task 4

13. 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:

Select: View > Visualize in Excel

Select: Link View > Visualize in Excel

Select: Hyperion > Link View > Visualize in Excel

Select: Options > Visualize in Excel

HB140, Task 5

Explanation

HB140, Task 5

14. By default, the Smart Tags feature is turned off. To turn Smart Tags on, which of the following steps needs to be taken?

Select: View > Smart Tags

Select: View > Options > Smart Tags

Select: Tools > AutoCorrect Options

None of the above