Szkolenia Oracle

Cel szkolenia szkolenie zdalne - dlearning

kod: OAD-ELS-OSVforOforE | wersja: 12c

In this course, you learn how to use Oracle Smart View 11.1.2.5, a common Microsoft Office(Excel, Word and PowerPoint) add-in to query, analyze, and share data stored in Essbase databases. In this course you learn how to connect to data sources and create ad-hoc queries and free-form grids.

Learn To: 

  • Query and analyze data stored in Essbase.
  • Create advanced reports.
  • Set Smart View options.
  • Create reports using Smart Query, Query Designer, and functions.
  • Embed dynamic data points into Microsoft Office documents.
  • Create reports with smart slices.

Benefits to You: 

By enrolling in this course, you'll develop the skills to use Smart Query and Query Designer to create customizable reports with interactive components. You'll get a chance to work with expert Oracle University instructors who can show you how to format reports by using functions.

Objectives:

  • Explain the multidimensional analysis and database outline hierarchy
  • Create ad hoc queries and advanced reports in Smart View
  • Set Smart View Options
  • Use Smart Query and Query Designer
  • Embed dynamic data points into Microsoft Office documents
  • Create reports with smart slices

Plan szkolenia Rozwiń listę

  1. Introduction to Smart View
    • Multi-Dimensional Analysis Overview
    • Smart View Architecture
    • Smart View Excel User Interface
    • Connecting to Data Sources
  2. Creating Ad Hoc Analysis Reports
    • Creating Ad Hoc Grids
    • Performing Ad Hoc Operations in Multiple Cells
    • Creating Member Selections
    • Associating Data Sources with Worksheets
    • Creating Multiple Grids on One Worksheet
    • Creating Free-form Grids
    • Working with the Essbase Ribbon
    • Working with Document Contents Pane
  3. Setting Smart View Options
    • Setting Global and Sheet-Level Options
    • Setting Data Navigation and Retrieval Options
    • Setting Number and Cell Formatting Options
    • Setting Administrative Options
    • Displaying Aliases for Member Names
  4. Creating Advanced Reports
    • Creating Queries using Query Designer
    • Creating a Smart Query
    • Creating Reports using Functions
    • Executing MDX Queries
    • Retrieving Data for DTS Members
    • Retrieving Data for Attribute Dimensions
    • Working with Excel Formulas
    • Replacing Data with Numeric Zeroes or Text
  5. Working with Smart Slices
  6. Creating Reports with Smart Slices
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Poziom trudności
Czas trwania 1 dzień
Certyfikat

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.

Prowadzący

Autoryzowany wykładowca Oracle.

Pozostałe szkolenia Oracle | Application Development

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.






* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.

CENA SZKOLENIA OD 4050 PLN NETTO

Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle