This guide describes the Universal Drill Through Service and associated tool, UDS Designer.Universal Drill Through Service (UDS) is a technology that allows users to drill down into a WebIntelligence Relational report, or another WebIntelligence OLAP report, from a WebIntelligence OLAP report. With UDS, users can seamlessly carry over their data analysis from report to report. The user selects the cell or cells in the OLAP cube for drilling, and UDS presents them with a list of WebIntelligence Relational or OLAP reports that provide more detailed drill down data. UDS ‘remembers’ the point at which the user left the cube and carries this context across to the target WebIntelligence report.UDS allows users to move from navigation of summarized OLAP cubes to more detailed query, reporting and analysis within the same framework. Users can perform dynamic multidimensional cube analysis and access lower level details stored in the target report.As administrator, you need to map the source OLAP cube to the universe or target OLAP cube and create reports that are appropriate for the different contexts at which the user might drill through from report to report.
Contents of this SAP Universal Drill Through Service Tutorial Guide
Chapter 1 About Drill Through 15
What does the administrator do? . . . . . . 17
What does the administrator need to know? . . . . . . 19
What is drill through? . . . . . . 20
Setting up drill through . . . . . 27
Chapter 2 Drill Through Requirements 29
Normalized relational databases . . . . . . 31
Star schemas . . . 32
What is a Business Objects universe? . . 34
How cubes and universes relate . . . . . . 35
Chapter 3 Designing the Target Universe 41
Designing the target database . . . . . . . . 43
Designing a star schema database . . . . 44
Creating the target universe from the database . . . . 46
Chapter 4 Building Translation Maps 47
What is UDS Designer? . . . 49
What are translation maps? 50
Mapping from cubes to universes . . . . . 53
Building translation maps using UDS Designer . . . . 54
Importing data sources . . . . 56
Creating a translation map . 60
Working with existing translation maps . 75
Making translation maps available to WebIntelligence . . . . . . . 78
Chapter 5 WebIntelligence in Drill Through 79
Creating WebIntelligence target reports 81
Drill through workflow . . . . . 82
Chapter 6 Managing and Maintaining a Drill Through Environment 89
Why maintenance is necessary . . . . . . . 91
Changes that require updates . . . . . . . . 92
Problems caused by outdated translation maps . . . 93
Source cube and target cube/universe locations . . 94
READ / DOWNLOAD THIS SAP PDF GUIDE
SAP BusinessObjects OLAP Connect Tutorial GuideThis guide describes BusinessObjects OLAP Connect, a data provider that lets BusinessObjects users access Microsoft SQL Server OLAP Services (MS OLAP Services) and SAP Business Information Warehouse (SAP BW) multidimensional servers. Contents of this SAP BusinessObjects OLAP Connect Tutorial Guide Chapter 1 Introducing BusinessObjects OLAP Connect 17 What You can Do with BusinessObjects OLAP Connect . . . . . . . 19 How BusinessObjects Integrates with BusinessObjects OLAP Connect . . . 20 Accessing...
SAP WebIntelligence TutorialThis tutorial shows you how to use the core features of SAP WebIntelligence to answer typical business questions. Six lessons teach you the steps you need to follow to view, analyze, format, and create WebIntelligence documents. Each lesson is accompanied by a sample document(s) based on the sample eFashion universe and database. Contents of this SAP WebIntelligence Tutorial Lesson 1 Accessing a document and navigating reports 19 Logging into InfoView.... . . 24 Setting your...
Essbase OLAP Access Pack Tutorial GuideOnline analytical processing (OLAP) describes a software technology extracts and presents multidimensional data from different points of view. The Essbase OLAP Access Pack is a tool that lets BusinessObjects users retrieve data from Hyperion Essbase multidimensional servers. An Essbase OLAP server is a data manipulation engine that supports and operates on multidimensional data structures. These data structures are represented by objects that you manipulate with the Essbase OLAP Access Pack.This guide describes the ESSBASE OLAP...
SAP BW in Universe DesignerSAP BW in Universe Designer This SAP BW pdf guide guide is intended to help you create and manage OLAP universes based on SAP BW data sources. The universes can be used in Web Intelligence, Dashboard and Analytics, Live Office, and Query as a Web Service. An OLAP universe is a Business Objects universe that has been generated from an OLAP cube or query. The universe is created automatically from a selected connection to an...
BusinessObjects Enterprise InfoView Tutorial GuideThis help provides you with information and procedures for using BusinessObjects Enterprise and InfoView. InfoView runs within your web browser and is your main interface for working with objects in BusinessObjects Enterprise. Your BusinessObjects Enterprise administrator may deploy different types of objects, such as Crystal reports, Voyager workspaces, Web Intelligence documents, Desktop Intelligence documents, and other objects that are created from BusinessObjects Enterprise plug-in components. InfoView allows you to view these objects, organize them, and...
Deploying the SAP Business Objects System tutorialDeployment is the distribution and arrangement of Business Objects query,reporting and analysis tools within a network infrastructure.Each deployment is different. How your deployment is structured and configured depends on the number of users supported, the type of information access that you want your users to have, the number and types of databases you’re using, the geographical distribution of your company, and so on. Before looking at the specific products Business Objects has to offer, it...
BusinessObjects Enterprise Administrator’s Tutorial GuideThis help provides you with information and procedures for deploying and configuring your BusinessObjects Enterprise system. Procedures are provided for common tasks. Conceptual information and technical details are provided for all advanced topics.This help is intended for system administrators who are responsible for configuring, managing, and maintaining a BusinessObjects Enterprise installation. Contents of this BusinessObjects Enterprise Administrator's Tutorial Guide Chapter 1 Getting Started 23 About this help...........24 Who should use this help?...24 About BusinessObjects Enterprise.......24...
Introduction tutorial to Crystal Reports 2008 SP1 in SAPCrystal Reports is designed to work with your database to help you analyze and interpret important information. Crystal Reports makes it easy to create simple reports, and, it also has the comprehensive tools you need to produce complex or specialized reports.Crystal Reports is designed to produce the report you want from virtually any data source. Built-in report experts guide you step by step through building reports and completing common reporting tasks. Formulas, cross-tabs, subreports, and...
Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer Tutorial BookDeliver SAP BI 7.0 Web Reports Distribute integrated, accurate, and timely data across your enterprise using the Web-based reporting components in SAP BI. Written by an SAP insider, Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer shows you how to construct effective queries, create HTML-based reports, and combine key analytics into a dashboard-style interface. Learn how to import data from multiple providers, configure custom templates, track Key Performance Indicators...
SAP BusinessObjects Data Services Designer Tutorial GuideSAP BusinessObjects Data Services XI Release 3 provides data integration and data quality processes in one runtime environment, delivering enterprise performance and scalability. The data integration processes of SAP BusinessObjects Data Services allow organizations to easily explore, extract, transform, and deliver any type of data anywhere across the enterprise. The data quality processes of SAP BusinessObjects Data Services allow organizations to easily standardize, cleanse, and consolidate data anywhere, ensuring that end users are always working...
No comments:
Post a Comment