Oracle Hyperion Smart View 11.1.2 for Essbase

In this course, you learn how to use Smart View, a common Microsoft Office add-in (Excel, Word and PowerPoint), to query, analyze, and share data stored in Essbase databases. You connect to data sources and create ad hoc queries and free-form grids. You use smart slices and Report Designer to create customizable reports with interactive components. Finally, you import Workspace documents into Microsoft Office.Learn To:Query and analyze data stored in EssbaseCreate ad hoc queries, free-form grids, and advanced reportsWork with Smart Slices and Report DesignerEmbed dynamic data points into Microsoft Office documentsImport Workspace content into Excel, Word, and PowerPointFormat Reports by Using FunctionsA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

• Introduction to Smart View
• Creating Ad Hoc Analysis Reports
• Setting Smart View Options and Managing POVs
• Creating Advanced Reports
• Working with Smart Slices and Report Designer
• Embedding Dynamic Data Points
• Importing Workspace Documents into Microsoft Office
• Applying Advanced Formatting to Grids

Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?


Vraag informatie aan

Gedetailleerde onderwerpenlijst

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Hyperion Smart View 11.1.2 for Essbase behandeld zullen worden:

• Introduction to Smart View
• Oracle′s Enterprise Performance Management System
• Essbase Overview
• Smart View Overview
• Smart View High-level Architecture
• Installing Smart View Client
• Smart View Excel Interface
• Data Source Providers
• Working with Smart View Panel
• Creating Ad Hoc Analysis Reports
• Creating Ad Hoc Grids
• Creating Member Selections
• Associating Data Sources with Worksheets
• Creating Free-form Grids
• Setting Smart View Options and Managing POVs
• Setting Smart View Options
• Displaying Aliases for Member Names
• Setting, Saving, and Sharing POVs
• Creating Advanced Reports
• Working with Query Designer
• Executing MDX Queries
• Retrieving Data for DTS Members
• Retrieving Data for Attribute Dimensions
• Working with Excel Formulas
• Creating Formatted Reports
• Creating Asymmetric Reports
• Working with Smart Slices and Report Designer
• Creating Smart Slices
• Setting Smart Slice Preferences
• Creating Customizable Reports with Interactive Components
• Embedding Dynamic Data Points
• Embedding Dynamic Data into Word and PowerPoint
• Changing the POV for Dynamic Data Points
• Importing Workspace Documents into Microsoft Office
• Integrating Workspace Documents with Microsoft Office
• Importing Financial Reporting and Web Analysis Documents
• Editing and Refreshing Documents
• Applying Advanced Formatting to Grids
• Formatting Grids as Tables
• Applying Conditional Formatting
• Grouping and Validating Data

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.