Hb140 - Hyperion Smart View

15 Questions | Total Attempts: 40

SettingsSettingsSettings
Smart Quizzes & Trivia

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

Back to Top Back to top