363 Programming courses in Ely delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owners/Team Leads/Power Users. In this course, students are enabled to transform Excel workbooks into captivating dashboards for executives and business users. Introduction to Dashboards Creating Interactive Dashboards Using an Embedded Excel Workbook in the Dashboard Data Visualizations with Charts Using Data in a Range Using Data in a Series Preparing Future Data by Ignoring End Blanks Dashboard Distribution Distributing a Dashboard Single Value Components Using Single Value Components Alerts Setting Up Alerts Selectors Using Selectors Setting Default Values for Selectors Selecting Multiple Items Common Components Using Images in a Dashboard Using Tables in a Dashboard Using an Interactive Calendar in a Dashboard Adding a URL to a Dashboard Components Used as Selectors Using the Chart Component as a Selector Using the Map Component as a Selector Format Options Configuring Proportional Size and Position Using Themes to Apply Formats Using Templates to Apply Formats Applying Globalization Dynamic Visability Adding Dynamic Visibility Using Formulas to Create Dynamic Visibility Creating Multi-Layer Dashboards Dashboard Design Optimization Optimizing Dashboard Design Dashboard Connection to Live Data Using Live Data Sources Setting Up an XML Connection Using Web Services to Connect to Data Using the Query Browser to Connect to Data Using the Portal Data Connection to Connect to Data Additional course details: Nexus Humans BOX310 SAP BusinessObjects Dashboards 4.1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BOX310 SAP BusinessObjects Dashboards 4.1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for Business application consultant Data Consultant / Manager Database Administrator Application developer BI specialist Overview This course will prepare you to: Understand and put into practice the main advanced modeling capabilities of SAP HANA 2.0 SPS04 in the areas of text search and analysis, graph modeling, spatial analysis and predictive modeling. Promote these advanced modeling capabilities to extend the core SAP HANA Modeling features. Broaden your experience with the modern SAP HANA tooling in XS Advanced (SAP Web IDE for SAP HANA) This course provides advanced knowledge and practical experience on several topics that are included in, or connected to, the scope of the modeler role. Its purpose is to take a step further, beyond the core modeling knowledge from HA300, and to demonstrate how applications powered by SAP HANA can benefit from innovations such as Spatial Data Storage and Processing, Text Search and Analysis, Predictive Analysis and Graph Modeling.The course is supported by many demos and exercise, which demonstrate the advanced modeling capabilities in several scenarios. For example, working with classical schemas or HDI containers in XS Advanced, using the SQL console, developing graphical models. Some of the proposed case studies blend together several modeling capabilities, such as text with spatial, or text with graph.An introduction to SAP HANA Series Data is also provided. Introduction to Advanced ModelingSAP HANA Predictive Analysis Library (PAL) Describing SAP HANA PAL Using PAL in Flowgraphs Calling PAL Functions in Calculation Views Calling PAL Procedures in SQL Scripts Exploring the PAL Library SAP HANA Spatial Introducing SAP HANA Spatial Working with Spatial Data Types Importing and Exporting Spatial Data Accessing and Manipulating Spatial Data Using Spatial Clustering SAP HANA Graph Defining SAP HANA Graph Workspace Describing the Different Graph Algorithms Using the Graph Node in Calculation Views Using GraphScript Procedures SAP HANA Text Understanding Full Text Search Understanding Text Analysis Understanding Text Mining SAP HANA Series Data Getting Started with SAP HANA Series Data

Duration 3 Days 18 CPD hours This course is intended for Application Developer Data Modeler BI / BW Consultant Data Scientist Database Administrator SAP HANA Support Personnel Overview This course will prepare you to: Push down data intensive tasks to the SAP HANA database using SQL and SQLScript Understand how to code using advanced SQLScript techniques Follow recommended practices for writing optimal SQL and SQLScript Debug and analyze SQL and SQLScript code This course provides students with basic SQL knowledge or refreshes their SQL knowledge, and enables them to use basic and some advanced SQL techniques for querying and manipulating data in an SAP HANA database. Getting Started What is SQL and SQLScript? Understanding how ABAP developers work with SQLScript Understanding XS Advanced and HDI Working with Web IDE for SAP HANA Understanding the course data SQL Logic Container Creating user-defined functions Creating database procedures Trapping errors in SQLScript User defined libraries Declarative Logic Using declarative logic Imperative Logic Using imperative Logic Transactional Savepoints How to implement transactional savepoints Analytic Operations Using OLAP Analytic features Implementing Temporal Tables Working with Hierarchies Working with Hierarchies Troubleshooting and Best Practices Tools for troubleshooting Best Practices Appendix Starting from the beginning with SQL fundamentals Additional course details: Nexus Humans HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Technology Consultants Overview Enables you to implement and maintain SAP BW powered by SAP HANA.Outlines advantages of the new SAP 'In-Memory' database foundation for SAP BW.Explains HANA specific features as well as optimized existing as well as new data models and functions of SAP BW.Introduces the new SAP architecture framework of LSA++ and provides guidelines on how to convert your existing EDW-architecture into this new concept.Explains native HANA modeling and how both, HANA information views as well as BW InfoProviders, can complement each other in so-called 'mixed scenarios'. In this course, students gain the knowledge to enable themselves to implement and maintain SAP BW powered by SAP HANA. The course explains HANA specific features as well as optimized existing as well as new data models and functions of SAP BW. Getting Started SAP HANA Basics SAP BW Basics SAP HANA BW Modeling Tools SAP HANA Native Modeling Migration to SAP BW on HANA Migration Strategies and Tools SAP BW Migration Cockpit BW on HANA Data Management Multi-Temperature Data Management Optimizing BW Data Management based on Dynamic Tiering and Non- Active Concept Optimizing BW Data Management based on Nearline-Storage Optimization Areas in BW on HANA HANA-Optimized Data Modeling: InfoCubes HANA-Optimized Data Modeling: Advanced DataStore-Objects HANA-Optimized Data Modeling: CompositeProviders HANA-Optimized Data Staging HANA-Optimized Analytic Manager HANA-Optimized Analysis Processes Modeling with SAPïs Reference Architecture LSA++ Review of Layered Scalable Architecture (LSA) From LSA to LSA++: Streamline Core Layers LSA++: Open Operational Data Store Layer (Open ODS Views) LSA++: Agile Data Mart & BW Workspace Layer Hybrid Modeling in Mixed Scenarios Generation of HANA-Views of BW InfoProviders Mixed Scenarios SAP HANA Live HANA-Optimized BI Content Data Provisioning into SAP HANA and SAP BW Overview of Data Provisioning Methods to SAP HANA SLT Replication into SAP HANA SLT Replication into SAP BW Operational Data Provisioning into SAP BW DB-Connect and Open Hub Destination Additional Enhancements of BW 7.40 InfoObject Enhancements Authorization Enhancements Process Chain Monitoring HANA-Optimized BW Search HANA-Optimized BW Planning Obsolete BW Object Types Mobile Enablement Enhancements SAP HANA vs. BW Accelerator Summary & Outlook New Transactions and BW on HANA Roadmap Additional course details: Nexus Humans BW362 SAP BW on SAP HANA training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BW362 SAP BW on SAP HANA course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This intermediate course is designed for experienced Integration Specialists and Senior-Level Developers with experience in application development, messaging middleware applications, and transport protocols such as HTTP and FTP. Overview Describe the features and uses of the IBM Integration BusDevelop, deploy, and test message flow applicationsGenerate message flow applications from predefined patternsUse IBM Integration Bus problem determination aids to diagnose and solve development and runtime errorsDescribe the function and appropriate use of IBM Integration Bus processing nodesWrite basic Extended Structured Query Language and Java programs to transform dataUse the IBM Graphical Data Mapping editor to transform dataDefine, use, and test simple XML and Data Format Description Language (DFDL) data modelsDescribe supported transport protocols and how to call them in message flows This course teaches you how to use IBM Integration Bus to develop, deploy, and support message flow applications. Students will learn how to construct applications to transport and transform data. Course Outline Course introduction Introduction to IBM Integration Bus Application development fundamentals Exercise: Importing and testing a message flow Creating message flow applications Exercise: Creating a message flow application Connecting to IBM MQ Exercise: Connecting to IBM MQ Controlling the flow of messages Exercise: Adding flow control to a message flow application Modeling the data Exercise: Creating a DFDL model Processing file data Exercise: Processing file data Using problem determination tools and help resources Exercise: Using problem determination tools Exercise: Implementing explicit error handling Mapping messages with the Graphical Data Mapping editor Referencing a database in a message flow application Exercise: Referencing a database in a map Using Compute nodes to transform messages Exercise: Transforming data by using the Compute and JavaCompute nodes Processing JMS, HTTP, and web service messages Preparing for production Exercise: Creating a runtime-aware message flow Course summary Additional course details: Nexus Humans WM666 IBM Integration Bus V10 Application Development I training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the WM666 IBM Integration Bus V10 Application Development I course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for: ? System Administrators ? Patch Administrators ? SA Administrators ? Policy Setters ? IT Managers ? IT or Application Architects ? Data Center Managers ? Application Experts ? Operations Experts ? Deployment Specialists ? Application Deployment Manager Administrators ? QA Team Members and Managers ? Security Administrators ? Other technical personnel who are responsible for data center automation Overview After completing this course, you should be able to: ? Describe the Server Automation (SA) core architecture and key components of SA ? Integrate unmanaged servers into the SA managed environment and discover server information through SA ? Use the Operation System (OS) Provisioning feature of SA to automate the installation of OS onto servers ? Provision virtual servers and manage their server lifecycle through SA ? Create static and dynamic device groups to manage multiple servers as groups ? Manage packages as part of the software management feature in SA ? Use a policy-based management methodology to provision software and manage software updates ? Describe and use Application Deployment Manager (ADM) to manage an application lifecycle using SA ? Use the Application Configuration feature of SA to manage the values in configuration files on managed servers ? Manage patches on various OS platforms using a patch policy or software policy ? Use the Audit and Remediation feature of SA to ensure servers and applications are compliant with defined best practices or corporate policies ? Use the Compliance feature of SA to discover out-of-compliance servers in the managed environment and ensure that they are in compliance with corporate policies ? Use the Global Shell and Global File System (OGFS) features to explore and manage servers in an SA environment ? Create, manage, and execute scripts I SA to manage servers or server groups This five-day course provides the necessary foundation to manage the data center servers and application environment using HP Server Automation (SA) 10. The course covers the key components of SA and their functionality. Course Overview and Introduction to HP Server Automation ? Discuss the IT organization?s preference for automation ? Discuss the main features of HP SA ? Discuss the benefits of using SA ? Describe the distributed architecture of SA Exploring the Architecture and Interfaces ? Define an SA core ? Describe the functionality of each key component of SA ? Describe SA users ? Use the SA client to explore a managed server environment ? Describe the SA core architecture and key components ? Learn how to use the SA interfaces to explore the server environment Agent Functionality and Server Integration ? Differentiate the agent types ? Describe the SA agent functionality ? Specify the requirements for installing an SA agent onto an unmanaged server ? Install an agent onto an unmanaged server using the SA client and manual installation ? Troubleshoot agent installation and communication failures ? Explore the server inventory using the Device Explorer of the SA client ? Describe the Agent Tools feature within SA ? Integrate existing, unmanaged servers into the SA managed environment ? Summarize what server information is collected by the agent ? Explain the server module objects ? Explain agent extensions Provisioning Operating Systems (OS) Using OS Build Plans (OSBPs) ? Describe the Operating System (OS) provisioning feature within SA ? Describe the process of provisioning an OS on a server ? Define and run an OS Build Plan (OSBP) Dynamic Host Configuration Protocol (DHCP) Less or Static IP Provisioning ? Configure and run the Managed Boot Client(s) (MBC) ? Provision Operating Systems (OS) without using Dynamic Host Configuration Protocol (DHCP) (or by using Static IP) Managing Virtualization ? Describe the supported virtualization management features in SA ? Describe the process of provisioning virtual servers for VMware Enterprise Server Xi (VMware ESXi) and Solaris 10 ? Identify the relationship between the hypervisor and its virtual servers ? Manage the lifecycle of VMware Virtual Machines (VMs) ? Manage the lifecycle of Solaris zones ? Integrate with VMware Virtual Center using Virtualization Service (VS) Exploring Device Groups ? Explain device groups and their characteristics ? Describe the different types of device groups supported in SA ? Create static and dynamic device groups using the SA client Exploring Device Groups with Search Results ? Describe the different types of search in the SA client ? Discuss the process to save and retrieve search results ? Create device groups from search results ? Develop sample reports using advanced search Managing Packages ? Describe how to manage packages in SA ? Discuss the supported package types ? Explain how to organize the software library ? Import and export packages into the software repository ? Install and uninstall packages ? Manage Red Hat Package Manager (RPM) packages Software Management ? Describe the use of policy-based software management in SA ? Describe how to manage software policies in SA ? List the software management setup tasks ? Install and uninstall software using software policies ? Manage software updates using software policies Working with Application Deployment Manager (ADM) ? Describe the Application Deployment Manager (ADM) and its functions ? Manage the ADM ? Set permissions for ADM ? Define an application, a target, and a component ? Deploy an application ? Manage an Application Deployment job ? Describe the rollback and undeploy process ? Import and export Application Deployment data from SA Application Configuration Management ? Describe how application configurations are managed in SA ? Describe application configuration components ? Control values using an application configuration inheritance model ? Push application configuration values to servers Managing Patches ? Describe the patch management feature in SA ? View patch information ? Describe UNIX patch management tasks ? Install patches using patch policies on the Windows platform ? Identify Microsoft patch administration tasks ? Manage patches on Red Hat LINUX Working with Audits, Snapshots, and Remediation ? Describe the audit and remediation feature in SA ? Create and run audits ? Configure file audit rules ? Set audit rule exceptions ? View audit results and remediate the differences ? Describe how to use Business Service Automation Essentials (BSAE) Network to run compliance audits Enforcing Compliance ? Define server compliance concepts ? Describe the compliance management feature in SA ? Scan and view the compliance status of servers ? Remediate non-compliant servers Exploring Servers Using the Global Shell and Global File System ? Describe the Global Shell and Opsware Global File System (OGFS) features within SA ? Describe how Global Shell and OGFS features can be used to manage servers within the SA environment ? Describe how to navigate and filter data in the OGFS using the Global Shell ? Use the Remote Shell (ROSH) command to login to a managed server and execute shell scripts on a managed server ? Use the SA remote terminal feature to access and manage servers in the managed environment Scripting with SA ? Describe the script management and execution feature in SA ? Create scripts using the SA client ? Execute ad hoc or saved scripts ? View and download script results ? Describe PowerShell integration with SA ? Explain the Extensible Discovery server module ? Introduce Automation Platform eXtensions (APX) scripting Exploring Reports in SA ? Explain SA reports ? List the reports available in SA ? Generate an SA report ? Explain Business Service Automation (BSA) Essentials basics as a reporting tool OS Provisioning with OS Sequences ? Describe the OS Provisioning feature within SA ? Describe the process of provisioning an OS on a server ? Define and run an OS Sequence

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Learn how to create queries in BEx Query DesignerLearn how to use advanced query functionsLearn how to perform OLAP analysis In this course, students obtain the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis. Data Warehousing Describing Data Warehousing Describing Data Warehouse Architecture Using Reporting Tools Navigation Options in Reports Using the Navigation Options in Reports Saving Analysis Views Simple Queries Creating Simple Queries Finding a Query Filtering Query Definition Data Configuring Query Properties Key Figures and Structures in Queries Creating Restricted Key Figures Creating Calculated Key Figures Creating a New Formula with Boolean Operators Configuring Properties of Key Figures Using Exception and Nested Exception Aggregation Queries with Multiple Structures Creating Structures Resolving Formula Collision Designing Detailed Queries with the Cell Editor Characteristics and Hierarchies in Queries Configuring the Properties of Characteristics Running Display and Navigation Attribute Queries Adding Hierarchies to Reports Adding External Hierarchies to a Report Using Hierarchies and Structures Creating External Hierarchies Variables in Queries Using Variables Creating Characteristic Value and Text Variables in Queries Creating Hierarchy and Hierarchy Node Variables in Queries Creating Formula Variables in Queries Activating Business Content Variables Exceptions and Conditions in Queries Creating Exceptions in Query Design Creating Conditions in Query Design Report-Report Interface Using the Report-Report Interface Query Performance Optimization Optimizing Query Performance Configuring Query Read Mode Use Performance Monitoring Tools Queries Management and Authorizations Overview Managing Query Objects Describing Authorizations Reporting Options Outlining Reporting Options for SAP NetWeaver BW Additional course details: Nexus Humans BW305 SAP Business Warehouse Query Design and Analysis training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BW305 SAP Business Warehouse Query Design and Analysis course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for Application developers who want to increase their understanding of Spring and Spring Boot and a focus on fundamentals. Overview By the end of the course, you should be able to meet the following objectives: Describe the benefits provided by Spring Boot Initialize a project using Spring Boot Starters Leverage Spring Boot's auto configuration features Create simplified backing-store solutions using Spring Data JPA Build a simple MVC application using Spring Boot, embedded Web Server and fat JARs or classic WARs Build a RESTful Web application Use Spring Security to secure Web and REST endpoints Enable and extend metrics and monitoring capabilities using Spring Boot actuator Leverage advance configuration capabilities Utilize Spring Boot enhancements to testing This course offers experience with Spring Boot and its major features, including auto-configuration, Actuator, Spring Boot testing framework and more. On completion, participants will have a foundation for creating enterprise and cloudready applications. Please note that this course is a subset of the material in our 4-day Spring: Core Training course - there is no need to take both courses. This course is recommended if you have a good working knowledge of Spring Basics (see Prerequisites) but are new to Spring Boot. Introduction to Spring Essentials Why Spring Configuration using Spring Bean creation Data Management Spring Boot Introduction Introduction to Spring Boot Features Value Proposition of Spring Boot Creating a simple Boot application using Spring Initializer website Spring Boot Dependencies, Auto-configuration, and Runtime Dependency management using Spring Boot starters How auto-configuration works Configuration properties Overriding auto-configuration Using CommandLineRunner JPA with Spring and Spring Data Quick introduction to ORM with JPA Benefits of using Spring with JPA JPA configuration in Spring Configuring Spring JPA using Spring Boot Spring Data JPA dynamic repositories Spring MVC Architecture and Overview Introduction to Spring MVC and request processing Controller method signatures Using @Controller, @RestController and @GetMapping annotations Configuring Spring MVC with Spring Boot Spring Boot packaging options, JAR or WAR Rest with Spring MVC An introduction to the REST architectural style Controlling HTTP response codes with @ResponseStatus Implementing REST with Spring MVC, @RequestMapping, @RequestBody and @ResponseBody Spring MVC?s HttpMessageConverters and automatic content negotiation Spring Security What problems does Spring Security solve? Configuring authentication Implementing authorization by intercepting URLs Authorization at the Java method level Understanding the Spring Security filter chain Spring security testing Actuators, Metrics and Health Indicators Exposing Spring Boot Actuator endpoints Custom Metrics Health Indicators Creating custom Health Indicators External monitoring systems Spring Boot Testing Enhancements Spring Boot testing overview Integration testing using @SpringBootTest Web slice testing with MockMvc framework Slices to test different layers of the application

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create Web Intelligence documents for your reporting needsRetrieve data by building queries using SAP BusinessObjects universesUse Web Intelligence to enhance documents for easier analysisOrganize, manage and distribute documents using the BI launch pad This course is designed to give students the comprehensive skills and in-depth knowledge needed to access, analyze and share data using SAP BusinessObjects BI launch pad and SAP BusinessObjects Web Intelligence. Web Intelligence Describing Web Intelligence Concepts Explaining Web Intelligence Core Functions Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform Web Intelligence Documents with Queries Creating Queries Creating a Document Modifying a Document?s Query Modify the Query Panel Data Return Restrictions from Queries Restricting Data with Query Filters Modifying a Query with a Predefined Query Filter Applying a Single-Value Query Filter Using Wildcards in Query Filters Using Prompts to Restrict Data Using Complex Filters Web Intelligence Document Design Modifying Web Intelligence Documents Displaying Data in Tables Using Tables Presenting Data in Free-standing Cells Presenting Data in Charts Presentation of Data in Documents Using Breaks and Calculations Using Sorts and Hiding Data Formatting Breaks and Cross Tables Filtering Report Data Ranking Data Highlighting Information with Formatting Rules Organizing a Report into Sections Web Intelligence Document Formatting Formatting Documents Formatting Charts Data Calculation Applying Formulas and Variables Using Formulas and Variables Drilling Functionality Analyzing the Data Cube Drilling in an Web Intelligence Document Web Intelligence Documentation Management Publishing Documents to the Corporate Repository Logging In to the BI Launch Pad Managing Documents in BI Launch Pad Viewing a Web Intelligence Document in the BI Launch Pad Sharing Web Intelligence Documents Setting BI Launch Pad Preferences Logging Off From the BI Launch Pad