Back Message to Tutor Inquiry to Uplatz Download Course Content Course URL PAY NOW

About Syllabus Certification Career Path Jobs Demo Videos FAQ

Job Meter = High

Oracle Smart View for Office 11.1.2 for Essbase

30 Hours

Online 1:1 Instructor-led Training

GBP 2000

Oracle Smart View for Office 11.1.2 for Essbase course and certification

4.9 ( 32 reviews )

318 Learners

About this Course

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.

--------------------------------------------------------
Course Objective

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

--------------------------------------------------------
Target Audience

Developer
End User

--------------------------------------------------------

Oracle Smart View for Office 11.1.2 for Essbase

Course Details & Curriculum

Introduction to Smart View

Multi-Dimensional Analysis Overview
Smart View Architecture
Smart View Excel User Interface
Connecting to Data Sources

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

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

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

Working with Smart Slices

Creating Reports with Smart Slices

--------------------------------------------------------

Message to Tutor Inquiry to Uplatz PAY NOW

PAY NOW Back

FEATURES

INSTALMENT OPTION AVAILABLE
LIFETIME ACCESS TO RECORDINGS OF SESSIONS
UPLATZ TRAINING HUB ACCESS
REAL-TIME PROJECTS & ASSIGNMENTS
RESUME & INTERVIEW PREPARATION SERVICES
CERTIFICATE & BADGE OF COURSE COMPLETION

FEATURES

INSTANT COURSE ACCESS PROVIDED
LIFETIME ACCESS TO VIDEOS
STUDY MATERIAL, EBOOKS, NOTES, ASSIGNMENTS
LEARN ANYTIME, ANYWHERE, ANY DEVICE
CERTIFICATE & BADGE OF COURSE COMPLETION

Send Inquiry Download Course Content Copy Course URL

Uplatz

1191 Courses offered

15 Events organized

London, UK

View Profile

Related Courses

Introduction to Cloud Security Architecture Introduction to Oracle Policy Automation Java EE 7: Front-end Web Application Development Java SE 11: Programming Complete Java SE: Programming I Oracle Commerce: Administering Your Content Environment Rel 11.1 Oracle Commerce: Creating Dynamic Pages with Experience Manager Rel 11.2 Oracle Commerce: Customizing the Business Control Center Rel 11.1 Oracle Database 18c: Managing Multitenant Architecture Oracle Database: Administration Workshop Oracle Essbase 11.1.2 Bootcamp (11.1.2.4) Oracle Essbase 11.1.2 for System Administrators Oracle Policy Modeling Essentials Rel 10.4 R12.x Oracle Payroll Fundamentals: Configuration (US) 3D Interaction Design in Virtual Reality 3D Models for Virtual Reality Accounts Adobe Illustrator Advanced Adobe InDesign - Advanced Advanced Architecting on AWS Advanced Certified ScrumMaster™ Advanced Developing on AWS Advanced Junos Security Agile for Development and Operations Teams Agile Project Management Agile Testing AI Fundamentals AIX Fundamentals AIX System Administration - Part II Apps, Websites and the User Experience Architecting on AWS ArcSight Distributed Security Solutions Architecture ArcSight ESM 7.x Administrator and Analyst ArcSight ESM 7.x Advanced Analyst ArcSight Logger 6.x Administration and Operations Asset Manager 9.x Modules Asset Manager 9.x Tailoring Augmented Reality, Virtual Reality, and Mixed Reality: Opportunities and Issues Teach-Out Aurelia Framework Avaya Aura® Contact Center Support Avaya Contact Center Select Implementation and Support AWS Architect Training AWS Business Essentials AWS Certified Advanced Networking (Specialty) Training AWS Certified Cloud Practitioner Training AWS Certified Data Analytics (Specialty) Training AWS Certified Database (Specialty) Training AWS Certified Developer Associate Training AWS Certified DevOps Engineer (Professional) Training AWS Certified Machine Learning (Specialty) Training AWS Certified Security (Specialty) Training AWS certified solutions architect AWS Certified Solutions Architect (Associate) Training AWS Certified Solutions Architect (Professional) Training AWS certified solutions architect associate AWS Certified Solutions Architect Professional AWS certified sysOps AWS Certified SysOps Administrator (Associate) Training AWS Certified Sysops Administrator - Associate (Systems Operations on AWS) AWS Developer Training AWS intro essentials AWS Introduction Essentials AWS Solution Architect AWS System Operations Training AWS Technical Essentials AWS Technical Essentials Training Azure - Deploying Virtual Machines BCS Foundation in Systems Development Big Data on AWS Bootstrap Building Cisco Service Provider Next-Generation Networks, Part 1 Building Interactive 3D Characters and Social VR CCNA Bootcamp Version 3.0 Certified Digital Transformation Practitioner Cisco Digital Network Architecture Implementation Essentials Cisco Digital Network Architecture Implementation Essentials Cisco Optical Technology Intermediate Cisco SDA Design Essential Cisco SDA Essentials Cisco Stealthwatch for Network Operations Cisco Stealthwatch Solution Overview Workshop Cisco Stealthwatch Tuning Citrix ADC 12.x Advanced Concepts - Management and Optimization Citrix ADC 12.x Advanced Concepts - Secure Web Applications Citrix ADC 12.x Advanced Concepts - Security, Management and Optimization Citrix ADC 12.x Essentials Citrix ADC 12.x Essentials and Traffic Management Citrix Gateway 12.x Citrix ShareFile Enterprise Essentials Computer Fundamentals: Introduction to the A+ Exam Computer Fundamentals: Security Configuring & Monitoring NetApp E-Series Storage Systems Configuring ACI in the Cisco Nexus Data Center Configuring and Deploying an Oracle ATG Web Commerce Site Rel 10.2 Configuring Windows 10 Devices: Configure Networking CREO Cyber Risks Insurance – Intermediate Cyber Risks Insurance – Introduction Data Breach Response Management Training Data Protection (GDPR) Foundation Certificate Data Protection (GDPR) Practitioner Certificate Data Protection Training Course Deep Learning on AWS Deploying Advanced Cisco Wireless LANs Deploying Cisco Unified Contact Center Enterprise Software Designing Cisco Enterprise Networks Designing Cisco Enterprise Wireless Network Designing Cisco Wireless Enterprise Networks Developing on AWS DevOps Engineering on AWS Digital Media Production Level 2 (Intermediate) DNA center and SD Access Implementation Docker For Enterprise Developers Docker for Enterprise Operations Docker Fundamentals Docker Kubernetes Service Docker Troubleshooting & Support European Data Protection (CIPP/E) Foundation in Systems Development Fundamentals of OpenStack Technology Fusion Applications R8: Provision Identity Management Fusion Applications: Extend Applications with ADF GDPR Awareness eLearning GDPR Training Course Graphics Design - Level 1 (Award) Graphics Design - Level 2 (Certificate) High Risk Processing and Data Protection Impact Assessments (Live, Online) HP-UX System Administration Implementing an Integrated Threat Defense Solution Implementing and Administering Cisco Solutions Implementing and Configuring Cisco Identity Services Implementing and Operating Cisco Collaboration Core Technologies Implementing Cisco Catalyst 9000 Switches Implementing Cisco Enterprise Advanced Routing and Services Implementing Cisco Enterprise Advanced Routing and Services Implementing Cisco IP Routing v2.0 Implementing Cisco IP Switched Networks v2.0 Implementing Cisco Network Security Implementing Cisco SD-WAN Solutions Implementing Endeca Commerce Core Technologies Rel 3.1 Improving Your Presentations Information Governance Information Management and CDMP Professional Certification Infrastructure Hacking Integrating Hybrid Clouds with NetApp Data Fabric Interconnecting Cisco Network Devices Part 1 Version 3.0 Introduction to Artificial Intelligence and Machine Learning (AI/ML) Introduction to Augmented Reality and ARCore Introduction to Enterprise Network Infrastructure Introduction to IIS Certificates Introduction to Oracle NoSQL Database Introduction to Virtual Reality Introduction to XR: VR, AR, and MR Foundations Java SE: Programming II JBoss Application Server Administration Junos Enterprise Switching Junos Security Junos Troubleshooting in the NOC Lean Six Sigma Black Belt Lean Six Sigma Yellow Belt Learn VirtualBox Server and Network Virtualization! Linux System Security Maintaining Windows 10 Making Your First Virtual Reality Game Manage Citrix Endpoint Management Management of Information Security and Risk: IT Risk and Resilience Managing and Defending against current Threats Managing Certificates with AWS Certificate Manager Masterclass Secure Coding Techniques Migrating To AWS Mobile VR App Development with Unity Monitoring of Employees (Live, Online) Motivation and Delegation Mulesoft Negotiating with Authority NetApp HCI Administration for VMware Administrators Network Intuitive SD-WAN Network Intuitive Technical Bootcamp Networking Concepts and Protocols Nutanix Advanced Administration and Performance Management Nutanix Enterprise Cloud Platform Administration v5.10 Object Oriented Analysis & Design OpenShift Enterprise Administration Operations Bridge Reporter 10.x Essentials Operations Manager i 10.x Essentials Oracle BI 11g R1: Create Analyses and Dashboards Oracle BI Applications 11g: Implementation using ODI Oracle Big Data Fundamentals Oracle Commerce: Administering Your Content Environment Rel 11.1 Oracle Commerce: Creating Dynamic Pages with Experience Manager Rel 11.2 Oracle Commerce: Customizing the Commerce Platform Rel 11.1 Oracle Commerce: Developing Experience Manager Applications Rel 11.1 Oracle Commerce: Implementing Guided Search Rel 11.1 Oracle Commerce: Managing Your Site Using the Business Tools Rel 11 Oracle Commerce: Platform Fundamentals for Developers Rel 11.1 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g: Managing Oracle on Linux for DBA Oracle Database: Managing Multitenant Architecture Oracle Database: Performance Management and Tuning Oracle Endeca Information Discovery 3.1: Build Discovery Apps Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases Oracle Fusion Middleware 11g: Build Applications with ADF I Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2) Oracle Linux 5 & 6 Advanced Administration Oracle Linux 5 & 6 System Administration Oracle Linux 5 & 6 System Administration Oracle Linux 7 Administration Oracle Linux 7: Advanced Administration Oracle Linux 7: System Administration Oracle Linux 7: What's New for Administrators Oracle Linux System Administration I Oracle Linux System Administration II Oracle NoSQL Database for Developers Oracle Policy Modeling for Policy Experts Oracle Smart View for Office 11.1.2 for Essbase Oracle SOA Suite 11g: Administration Oracle WebLogic Server 10g R3: Monitoring and Performance Tuning Oracle WebLogic Server 10g R3: System Administration Oracle WebLogic Server 11g: Administration Essentials Oracle WebLogic Server 11g: Administration Essentials Oracle WebLogic Server 11g: RAC Integration Oracle WebLogic Server 12c: Administration - 1 Pathway to Multimedia, ICT, Art and Business Administration Podcasting: advanced Podcasting: introduction Pre-Entry and Entry Creative Multimedia Presentation Skills Privacy Programme Management (CIPM) Programming for Network Engineers R12 Oracle Common Application Components Fundamentals R12 Oracle HRMS System Administration Fundamentals R12 Oracle Payroll Fundamentals: Earnings and Deductions (UK) R12 Oracle Purchasing / Payables Accelerated R12 Oracle Using and Maintaining Approvals Management R12.2 Oracle Cash Management Fundamentals R12.2 Oracle E-Business Suite Fundamentals R12.2 Oracle General Ledger Management Fundamentals R12.2 Oracle Inventory Management Fundamentals R12.2 Oracle iProcurement Fundamentals R12.2 Oracle Purchasing Fundamentals R12.2 Oracle Receivables Management Fundamentals R12.x Oracle Advanced Collections Fundamentals R12.x Oracle HRMS Performance Management Fundamentals R12.x Oracle iStore Fundamentals R12.x Oracle Sourcing Fundamentals R12.x Oracle Time and Labor Fundamentals R12.x Use and Implement Oracle Incentive Compensation Red Hat Security: Linux in Physical, Virtual, and Cloud Red Hat System Administration Relational Databases & Data Modelling Overview Requirements Engineering RHCSA Rapid Track Course Risk Management Securing Email with Cisco Email Security Appliance Securing your Customer with DNA Security Engineering on AWS Security Enhanced Linux (SELinux) Fundamentals Security in the Cloud Selling Cisco SD-WAN Serverless Data Lake on AWS SharePoint Security End to End Sketch-Up for Designers - Introduction Solutions to Building a Positive Data Protection Culture SUSE Linux Advanced System Administration SUSE Linux System Administration System Operations on AWS Systems Design Techniques TCP/IP and Networking Fundamentals for IT Pros TOGAF® for Practitioners - Level 1 Foundation TOGAF® for Practitioners - Level 2 Troubleshooting and Maintaining Cisco IP Networks v2.0 Understanding Cisco Data Center Foundations Understanding Cisco Enterprise Network Foundations Understanding Cisco Wireless Foundations Understanding Networking Fundamentals Veeam Certified Architect (VMCA) Veeam Certified Engineer (VMCE) Veeam Certified Engineer - Advanced: Design & Optimization (VMCE-A: D&O) Video editing: Adobe Premiere tips and tricks VMware Integrated Openstack: Install, Configure, Manage VMware vSphere: Install, Configure, Manage [V6.7] VMware vSphere: Troubleshooting Workshop VR and 360 Video Production Workshop: Windows Server 2019

Didn't find what you are looking for? Contact Us