All About SAP: August 2011

Wednesday 31 August 2011

SAP PS Documentation

I found a number of useful PDF documents for SAP PS. Hope you find them helpful.

SAP help also provides a menu driven html versions of SAP PS Documentation.

User: Creating User in SAP

How to create user in SAP

Steps

Execute SU01Enter user name and press CREATE (notepad)
0003-creat-user001

Enter necessary details such as Firstname and Lastname
0003-creat-user002

Click on Logon Data Tab and enter password a password eg: enjoysap123
0003-creat-user003

Click Save (floppy disk icon). Now you can informed the user that his/her account has been created.Be the first to like this post.

News: SAP is still doing great

From eweek.com

Salaries for SAP specializations increased 15.2 percent in 2006, according to research released in February by Foote Partners, a New Canaan, Conn., IT workforce research firm. Data from the first two quarters of 2007 suggests little abatement of this trend.

“Right now, anybody who is working in the SAP world, either with functional or technical skills, is doing great,” said Jim Lanzalotto, vice president of strategy and marketing for Yoh, a recruiting and outsourcing firm, based in Philadelphia. “The demands are for specialized skills, and if you’ve got to pick the right market to be a specialist in, the world of SAP is hot.”

ERP-related roles accounted for two of the best-paying IT jobs in the second quarter of 2007, according to the second quarter 2007 Yoh Index of Technology Wages, released July 23. SAP technical consultants came in first, with average hourly pay rates of $85.53, and ERP (enterprise resource planning) functional consultants came in eight dollars behind in second place, at $78.40 per hour.

more at http://www.eweek.com/article2/0,1759,2161806,00.asp

Be the first to like this post.

Procedure Cache Hit Ratio for database

What is it?
The hit ratio is a mean value that gives a snapshot of a short period of time before the analysis. This value should always be above 95%, even during periods of heavy workload. If the hit ratio is significantly below 95%, the data cache could be too small.

To check the hit ratio:
1. Execute ST04
003-ST04

2. If the hit ratio is below 95%, you will have to increase it.

Be the first to like this post.

Job: Error ‘Print parameters for step 1 could not be found’

Most common SPOOL error encountered by BASIS. How do we resolve this issue?

Steps

Execute SM37. You found an error Job. When you double click you foundYou saw the below error
0002-spool-error-param1-001

This error is caused by job spooler is not defined when job creation hence it picks up the job owner’s default output device.Since the default output device is no populated on master user record, the job log can’t find the print parameter.To resolve the issue, please populate the output device and select your preference for your SAP spool request via transaction code SU3.For Output device, you can choose one of SAP printer which has been defined in SAP (you can look at via transaction code SPAD)Recommendation: please do not select LOCL if you want to opt ‘Output immediately’. Moreover, this output device is not good for network performanceSelect ‘Output immediately’ if you want to immediate print for every spool request that you create in SAP. Recommendation: do not select this.Select ‘Delete After Output’ if you want SAP to delete every spool that you create. Recommendation: do not select this. You can manage your spools e.g. printing, reprinting, deletion, etc via transaction code SP01 as below: 0002-spool-error-param1-002

Be the first to like this post.

SAP Business Objects Repository Reference PDF Guide

The Business Objects repository is a relational database used to share data among the applications in the Business Objects suite.When it is created, the Business Objects repository is made up of three domains ( the security domain , the document domain, the universe domain ).This document describes the tables in domain and the structure and contents of the tables they contain.

Contents of this SAP Business Objects Repository Reference PDF Guide
Chapter 1 The Business Objects Repository 7
Chapter 2 The Security Domain 9
DS_PENDING_JOB       . 12
DS_USER_LIST       . . . . 21
OBJ_M_ACTOR       . . . . 22
OBJ_M_ACTORDOC       27
OBJ_M_ACTORLINK       28
OBJ_M_CATEG       . . . . 30
OBJ_M_CHANNEL       . 31
OBJ_M_CONNECTDATA      . . . 33
OBJ_M_CONNECTION      . . . . . 35
OBJ_M_DOCAT       . . . . 36
OBJ_M_DOCCATEG       37
OBJ_M_DOCATVAR       38
OBJ_M_DOCCST       . . 40
OBJ_M_DOCUMENTS      . . . . . 41
OBJ_M_GENPAR       . . 45
OBJ_M_MAGICID       . . 51
OBJ_M_OBJSLICE       . 53
OBJ_M_REPOSITORY      . . . . . 55
OBJ_M_RESERVATION      . . . . 57
OBJ_M_RESLINK       . . 59
OBJ_M_TIMESTAMP      . . . . . . 62
OBJ_M_UNIVCST       . . 68
OBJ_M_UNIVDBCST      . . . . . . 72
OBJ_M_UNIVERSES      . . . . . . 75
OBJ_M_UNIVSLC       . . 80
OBJ_M_USRATTR       . 81
Chapter 3 The Document and Universe Domains 83
OBJ_X_DOCUMENTS      . . . . . . 85
UNV_AUDIT        86
UNV_CLASS       . . . . . . 87
UNV_CLASS_DATA       89
UNV_COLUMN_DATA      . . . . . 90
UNV_COLUMNS       . . . 91
UNV_CONTEXT       . . . 93
UNV_CONTEXT_DATA      . . . . . 94
UNV_CTX_JOIN       . . . 95
UNV_DIMENSION       . . 96
UNV_DIM_OBJ       . . . . 97
UNV_JOIN        . 98
UNV_JOINCONTENT      . . . . . 100
UNV_JOIN_DATA       . 102
UNV_JOIN_OBJECT      . . . . . . 103
UNV_OBJCONTENT      . . . . . . 104
UNV_OBJECT       . . . . 108
UNV_OBJECT_DATA      . . . . . 110
UNV_OBJECT_KEY      . . . . . . 112
UNV_OBJ_COLUMN      . . . . . . 113
UNV_OBJ_TAB       . . . 114
UNV_PROPERTY       . 115
UNV_PROP_DATA       117
UNV_PROP_TAB       . 118
UNV_RELATIONS       . 119
UNV_TABLE       . . . . . 120
UNV_TABLE_DATA       122
UNV_TAB_OBJ       . . . 123
UNV_TAB_PROP       . 124
UNV_UNIVERSE       . . 125
UNV_UNIVERSE_DATA      . . . 129

READ / DOWNLOAD THIS SAP PDF GUIDE

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...

SAP Business Objects business intelligence Deployment Diagnostic Tools GuideYour company has bought the Business Objects business intelligence solution. You have deployed at least part of this solution, but are experiencing issues that prevent your users from being able to exploit the Business Objects solution’s full functionality.This guide describes the tools and methods available to you when you need to troubleshoot performance or functional problems encountered while using your Business Objects system. Contents of this SAP Business Objects business intelligence Deployment Diagnostic Tools Guide...

SQL Server Setup Guide for SAP Business Objects PlanningInstallation, configuration and administration of SQL Server is typically handled by the organization’s Information Technology department. Business Objects Planning Support is also available to assist you with issues relating to use of SQL Server with Business Objects Planning. This PDF study material provides details about SQL Server Setup Guide for SAP Business Objects Planning Contents of this Guide Introduction SQL Server Versions . . .5 Intended Audience . . . . .5 Technical Requirements .5...

SAP Business Objects PDF USER Guide Advanced Analysis, edition for Microsoft OfficeThis guide is intended for users interested in building and analyzing workbooks using SAP BusinessObjects Advanced Analyzer, edition for Microsoft Office. Contents of this SAP Business Objects PDF USER Guide Advanced Analysis, edition for Microsoft Office Chapter 1 About this guide.............7 1.1 Who should read this guide?..........7 1.2 User profiles...7 1.3 About the documentation set.........7 Chapter 2 Getting Started9 2.1 What is SAP BusinessObjects Advanced Analysis, edition for Microsoft Office? .....9 2.2 Working with Advanced...

SAP Business Information Warehouse Reporting: Building Better BI with SAP BI 7.0This SAP BI book is aGuide to SAP Business Information Warehouse Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also...

SAP BI (BUSINESS INTELLIGENCE )SAP BUSINESS INTELLIGENCE ( BI ) SAP Business Intelligence (SAP BI) provides a complete view of the company. The solution, which is part of SAP NetWeaver, provides the tools needed to make the right decisions, optimize processes, and measure strategic success: data from all enterprise sources are merged effectively and can be comprehensively analyzed, business-critical factors can be monitored using external and internal benchmarks, the most important KPIs can be passed on to all the...

SAP BW (BUSINESS INFORMATION WAREHOUSE )SAP BW (BUSINESS INFORMATION WAREHOUSE ) The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market. As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these...

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...

SAP Universal Drill Through Service Tutorial GuideThis 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...

SAP Custom Data Provider Plug-in Developer tutorial GuideThe Custom Data Provider Plug-in Developer Guide is intended to help plug-in developers gain a better understanding of Custom Data Source Framework. It describes how to create a Web Intelligence document (.wid) using a Custom Data Source by developing a plug-in and using it with Web Intelligence Rich Client (WRC). This document also describes how to develop, configure, and deploy a plug-in for the Custom Data Source (CDS) Framework. The CDS Framework plug-in uses a...

View the original article here

Essbase OLAP Access Pack Tutorial Guide

Online 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 ACCESS PACK, a data provider that lets BUSINESSOBJECTS users access Essbase multidimensional servers.

Contents of this Essbase OLAP Access Pack Tutorial Guide
Chapter 1 Introducing the Essbase OLAP Access Pack 15
What You Can Do with the Essbase OLAP Access Pack . . . . . . 17
How BusinessObjects Integrates with the Essbase OLAP Access Pack . . . 18
The BusinessObjects Environment for the Essbase OLAP Access Pack . . 22
Chapter 2 OLAP Concepts 29
Accounts . . . 31
Aggregation . 31
Ancestor . . . . 32
Cell 32
Child . . . . . . . 32
Database Outline . . . . . 32
Descendant . 33
Dimension . . 33
Drill Down/Up 33
Generation, Hierarchical . . . . . . . 34
Hierarchy . . . 34
Level, Hierarchical . . . . 35
Measure . . . . 35
Member, Dimension . . . 35
Nesting . . . . . 36
OLAP (Online Analytical Processing) . . . . . 36
Parent . . . . . 37
Sibling . . . . . 37
Slice and Dice . . . . . . . 37
Chapter 3 Getting Started 39
The Document Creation Process 41
Step 1: Selecting a Report Layout and Connecting to an Essbase
OLAP Server 42
Step 2: Selecting Your Initial Data 45
Step 3: Fine-Tuning your Initial Data . . . . . . 50
Step 4: Selecting a Level of Detail . . . . . . . 54
Step 5: Selecting Report Options 59
Step 6: Generating the BusinessObjects Report . . . . . 65
Step 7: Refreshing and Editing Documents 67
Chapter 4 Advanced Techniques 69
Power Users and Basic Users . . . 71
Modifying Restricted Data in a Document . . 72
Creating an Interactive Document 75
Working with Differences between Data Models . . . . . 79
Advanced Techniques for the Generated Report . . . . 88
Index 89

View the original article here

Customizing SAP BusinessObjects 6.5 Without Programming

Business Objects provides you with numerous ways to customize your Business Intelligence solution. Many of these customization solutions do not require knowledge of programming. These are the solutions discussed in this guide.
Contents of this Customizing SAP BusinessObjects 6.5 Without Programming
Chapter 1 Introduction 13
Chapter 2 Customizing from Within InfoView 17
Default start page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
My InfoView . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Default document editor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Default document viewing options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Default fonts for reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Document list display . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
User language default . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Modifying default user settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Chapter 3 Customizing the Skins 45
Skin components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49
Finding the styles and GIFs in the HTML . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Where to find the files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
Creating a skin: some examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
Adding a skin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
List of GIFs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
List of styles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Java Report Panel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87

READ / DOWNLOAD THIS SAP PDF GUIDE

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...

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 BusinessObjects Explorer (blade) Administration Tutorial GuideThis guide is for administrators responsible for managing an SAP BusinessObjects Explorer system as part of an SAP BusinessObjects Explorer, accelerated version implementation, which includes SAP NetWeaver BW Accelerator. Contents of this SAP BusinessObjects Explorer (blade) Administration Tutorial Guide Chapter 1 Introduction......7 About this guide.......7 Important SAP Notes.............7 Related guides.........8 Chapter 2 Business Scenarios.....11 End-user features..11 Administration features........12 Key terms.12 Chapter 3 Technical System Landscape...15 Architecture............15 The BI platform......16 The Explorer servers...........17 Supported data providers....17...

BusinessObjects XI Integration KitBusinessObjects XI Release 2 Integration Kit for SAP Installation Guide BusinessObjects XI Integration Kit for SAP provides you with powerful report design tools and a framework for managing, scheduling, and distributing your Crystal reports over the Web. As such, it enables you to extract value from your SAP Business Information Warehouse (BW) and R/3 data and share it with users across the enterprise. BusinessObjects XI Integration Kit for SAP includes three major products—BusinessObjects Enterprise Professional,...

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...

BusinessObjects LifeCycle Manager Installation Tutorial Guide for SAP XI 3.1BusinessObjects LifeCycle Manager (LCM) is a web-based tool that enables you to move BI resources from one system to another system, without affecting the dependencies of these resources. It also enables you to manage different versions of BI resources, manage dependencies of BI resources, and roll back a promoted resource to restore the destination system to its previous state. The LCM tool is a plug-in for the BusinessObjects Enterprise application. You can promote a BI...

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...

View the original article here

Tuesday 30 August 2011

SAP Business Objects business intelligence Deployment Diagnostic Tools Guide

Your company has bought the Business Objects business intelligence solution. You have deployed at least part of this solution, but are experiencing issues that prevent your users from being able to exploit the Business Objects solution’s full functionality.This guide describes the tools and methods available to you when you need to troubleshoot performance or functional problems encountered while using your Business Objects system.

Contents of this SAP Business Objects business intelligence Deployment Diagnostic Tools Guide
Chapter 1 Troubleshooting Overview 13
You have an issue – what can you do about it? . . . . 15
A troubleshooting methodology . . . . 21
The troubleshooting toolset . 23
Chapter 2 Checking Installation and System Settings 27
Where to store the bomain.key file . . 29
Adding locale and connectivity environment variables to MyWebiEnv.sh . . 29
Testing the bomain.key file with wmainkey . 30
Checking your license files with wlicense . . 31
Checking Business Objects software with WICheckInstall . 32
Checking system settings with WICheckConfig . . . . 34
Installation and Configuration Tool log files . 36
Chapter 3 Monitoring Your Business Objects System 37
Monitoring the Business Objects system . . . 39
Monitoring general system availability with wping . . 40
Monitoring the cluster with wasfadm 44
Monitoring Business Objects log files with wsnmp . . 45
Monitoring Business Objects processes with WIMonProc . . 47
Monitoring core file generation with WIMonCore . . . 50
Chapter 4 Retrieving Information 55
Retrieving information about your system’s configuration with
WIGetPlatformInfo . . 57
Collecting essential system files with WIGetConfDmp . . . . 61
Facilitating tracing with WITraceCtl . 64

READ / DOWNLOAD THIS SAP PDF GUIDE

SAP Business Objects Repository Reference PDF GuideThe Business Objects repository is a relational database used to share data among the applications in the Business Objects suite.When it is created, the Business Objects repository is made up of three domains ( the security domain , the document domain, the universe domain ).This document describes the tables in domain and the structure and contents of the tables they contain. Contents of this SAP Business Objects Repository Reference PDF Guide Chapter 1 The Business...

View the original article here

Deploying the SAP Business Objects System tutorial

Deployment 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 may be useful to review some basics, and to look at the reasons companies choose Business Objects as their database query, reporting, and analysis tool.

Contents of this Deploying the SAP Business Objects System tutorial
Chapter 1 Introducing BusinessObjects 6.5 23
Standard SQL reporting configurations . 26
The secure Business Objects configuration . . . . . . . 27
What can you do with the Business Objects solution? . . . . . . . . 28
BusinessObjects 6.5 . . . . . . 30
Desktop products 31
Server products . 36
Administration products . . . . 46
Database Access Packs . . . 54
Demonstrations . 55
Developer Suite . 56
Organization of this guide . . 58
How terminology has changed . . . . . . . . 61
Chapter 2 System Architecture and Communication 63
Deployment architectures . . 65
3-tier architecture overview . 67
The client . . . . . . 69
The middle tier . . 70
Database components . . . . 75
What products are associated with each architecture? . . . . . . . 76
What platforms are associated with each architecture? . . . . . . 79
What is a cluster? . . . . . . . . 80
Why use distributed configurations? . . . 82
What is CORBA? 83
The Application Server Framework . . . . 85
How the system accesses data . . . . . . . 89
Chapter 3 How the System Is Administered 93
The Administration Console 95
Administering Broadcast Agent . . . . . . . 98
Monitoring and analyzing system activity . . . . . . . 101
Command-line administration tools . . . 103
Chapter 4 The Repository and Security 105
Data security through the repository . . 107
Repository domains . . . . . . 108
How clients access the repository . . . . 110
Which components access the repository? . . . . . . 113
Using multiple repositories 115
The repository and your data warehouse . . . . . . . 116
How do users access the repository? . 118
Working with or without a repository . . 121
Repository compatibility issues . . . . . . 123
Chapter 5 Deployment Considerations 127
Pre-deployment checklist . . 129
Education: providing the tools to be successful . . . 130
Performance: what is acceptable and how can you attain it? . 131
Server sizing: efficiently supporting peak user activity . . . . . . . 132
Deployment configuration . 133
Data management: making data accessible . . . . . 134
Protecting your system and your resources . . . . . . 135
Users: know their numbers, profiles, groups and rights . . . . . . 136
Documents: what type, how complex? . 140
Load balancing: matching system processes and server resources . . . . . 141
Disaster recovery: what can you do about it? . . . . 142
Deployment procedure . . . . 143
Conclusion . . . . 145
Chapter 6 Modeling your System 147
Designing your architecture 149
Selecting your system’s software . . . . . 153
Selecting your system’s operating system . . . . . . . 154
Deployment models . . . . . . 159
Cluster architecture . . . . . . 161
Repository architecture . . . 166
Database and repository location . . . . . 168
Centralized or decentralized architecture? . . . . . . . 170
Global deployment scenario summary . 182
Chapter 7 Supported Deployment Configurations 183
Terminology . . . 186
Basic 2-tier deployments . . 188
Citrix configurations . . . . . . 190
3-tier architecture overview 192
Combined 2- and 3-tier deployments . 193
Basic intranet deployments 195
DMZ configurations . . . . . . 197
Extranet deployments . . . . 202
Deported application servers . . . . . . . . 208
Reverse proxies . . . . . . . . 211
IP redirectors . . 214
Multiple clusters in an intranet . . . . . . . 218
Single-cluster intranet/extranet deployment options . . . . . . . . 222
Multiple-instance servers under UNIX . 225
Multihomed configurations 227
Multilingual configurations using Unicode . . . . . . . 230
Heterogeneous clusters . . 232
Deployment configuration summary . . 234
Part III Practical Deployment Specifics
Chapter 8 From Development to Production 239
The development lifecycle . 241
Planning the pre-production environment . . . . . . . 246
Creating the lifecycle environments . . 252
Migrating between environments . . . . 261
Planning and building the production environment 265
Chapter 9 Overall Deployment Checklist 267
Setting up a Windows deployment . . . 269
Setting up a UNIX deployment . . . . . . 274
Setting up a heterogeneous deployment . . . . . . . . 280
Chapter 10 Implementing Supported Deployment Configurations 287
Installation and configuration for all 3-tier deployments . . . . . . 289
Implementing a Citrix configuration . . . 294
Implementing a basic intranet deployment . . . . . . . 298
Implementing a DMZ configuration . . . 299
Implementing an extranet deployment . 302
Implementing a deported application server . . . . . 307
Implementing an IP redirector . . . . . . . 311
Implementing a multihomed configuration . . . . . . . 319
Implementing a multiple-instance UNIX configuration . . . . . . . 321
Implementing heterogeneous clusters . 323
Implementing a single web server for intranet and extranet users . . . . . . . 325
Implementing Unicode corporate databases . . . . . 326
Chapter 11 Deploying and Managing the Repository 339
Choosing a repository database . . . . . 341
How much space should you allot for the repository? . . . . . . . 344
The location of repository domains . . . 347
Deploying and using multiple repositories . . . . . . . 349
Optimizing the security domain . . . . . . 352
Making documents available to users of other repositories . . . 353
Changing a cluster’s repository . . . . . . 354
Chapter 12 Deploying Specific Components and Products 355
Overall 3-tier deployment guidelines . . 357
Choosing your applications and how they are deployed . . . . . 362
Deploying Connection Server . . . . . . . 372
Deploying InfoView/WebIntelligence . . 380
Deploying BusinessObjects 391
Deploying Broadcast Agent 399
Deploying Auditor . . . . . . . . 411
Chapter 13 Deploying WebIntelligence for OLAP Data Sources 417
WebIntelligence OLAP server as part of the cluster . . . . . . . . 419
Setting up the dedicated OLAP node . 421
The WebIntelligence cache service . . . 423
The Universal Drill Through Service (UDS) . . . . . . 424
Installing the OLAP services on cluster nodes . . . 425
Configuring the OLAP services on cluster nodes . 427
Defining the OLAP connection in WebIntelligence 437
Part IV Securing the Solution
Chapter 14 Data Security 441
Security at the product feature level . . 444
Data security at the universe level . . . 446
Section and block security at the report level . . . . 462
Chapter 15 Network Security 465
Common protection techniques . . . . . . 467
Appendix A How Products Compare Functionally 475
InfoView vs. WebIntelligence . . . . . . . 477
BusinessObjects: 2-tier vs. 3-tier mode 479
BusinessObjects in 3-tier mode vs. InfoView/WebIntelligence 480
Processing different types of documents in InfoView . . . . . . . 482
Version 2.x/5.x vs. 6.5 . . . . 485

READ / DOWNLOAD THIS SAP PDF GUIDE

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...

View the original article here

BusinessObjects LifeCycle Manager Installation Tutorial Guide for SAP XI 3.1

BusinessObjects LifeCycle Manager (LCM) is a web-based tool that enables you to move BI resources from one system to another system, without affecting the dependencies of these resources. It also enables you to manage different versions of BI resources, manage dependencies of BI resources, and roll back a promoted resource to restore the destination system to its previous state. The LCM tool is a plug-in for the BusinessObjects Enterprise application. You can promote a BI resource from one system to another only if the same version of the BusinessObjects Enterprise application is installed on the source and the destination systems.
Contents of this BusinessObjects LifeCycle Manager Installation Tutorial Guide for SAP XI 3.1
Chapter 1 Introduction 5
Overview………..6
About this guide6
Who should read this guide……..6
Chapter 2 Planning the LCM installation 7
System requirements…..8
Restrictions…….9
Chapter 3 Installing LCM 11
Installing LifeCycle Manager by using GUI………12
Deploying the web application manually ……17
Installing LifeCycle Manager by using CLI ……..17
Chapter 4 Configuring the Subversion repository manually 19
Chapter 5 Maintaining LifeCycle Manager 23
Preparing for uninstallation…….24
Uninstalling LifeCycle Manager by using GUI….24
Uninstalling LifeCycle Manager by using CLI…..25
Uninstalling Subversion…………26
Repairing the LCM installation..26

READ / DOWNLOAD THIS SAP PDF GUIDE

SAP Product Lifecycle Management ( PLM ) introduction, tutorialSAP Product Lifecycle Management ( PLM ) is a collection of solutions with which you digitally create, maintain and make available product information in the whole company and for the entire life cycle of a product. As an ambitious company, you do not want to just keep up with the international competition, you want to increase your competitiveness in the field of new information technology. Only a flexible company that optimizes daily business in all...

Enable SAP BW Web functionality after a new SAP BW installation – pdf guideEnable SAP BW Web functionality after a new SAP BW installation If you have just completed the technical installation of SAP BW 3.x and wish to enable BW web functionality for your users and administrators to use. This functionality could include the following: · Development and deployment of BW Web Applications · XML data loads via the HTTP/SOAP interface · Display and maintenance of BW documents · Display of BW MetaData in a Web Browser...

Customizing SAP BusinessObjects 6.5 Without ProgrammingBusiness Objects provides you with numerous ways to customize your Business Intelligence solution. Many of these customization solutions do not require knowledge of programming. These are the solutions discussed in this guide. Contents of this Customizing SAP BusinessObjects 6.5 Without Programming Chapter 1 Introduction 13 Chapter 2 Customizing from Within InfoView 17 Default start page . . . . . . . . . . . . . . . . . . . ....

View the original article here

SAP WebIntelligence Tutorial

This 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 WebIntelligence viewing options.. . . . 27
Searching for a WebIntelligence document.. . . . . . 29
Navigating the reports…. . 33
Saving the document as an Excel spreadsheet.. . . 37
Logging out of InfoView…. 41
Lesson 2 Working with prompts, filters, sorts, and drilling to more detail 43
Setting your WebIntelligence drill options.. . . . . . . 46
Opening a corporate document… . . . . 48
Filtering a report to focus on a time period.. . . . . . . 51
Sort sales revenue results by state… . 55
Drilling to more detailed information… . 57
Printing a report…. . . . . . . 60
Saving a document to a personal category.. . . . . . 62
Logging out of InfoView…. 66
Lesson 3 Creating a new document 67
Setting your create/edit options… . . . . 70
Building a query…. . . . . . . 72
Filtering the query…. . . . . 78
Creating a prompt…. . . . . 83
Running the query to generate a report.. . . . . . . . 87
Saving the document as a corporate document.. . 93
Logging out of InfoView…. 97
Lesson 4 Organizing the data in your document 99
Opening a document in Edit mode… 102
Group the report into sections for each quarter.. . 104
Add a break to a table to split out product line information. . . 106
Sort the sales revenue results to prioritize high results. . . . . . 109
Add sum and average calculations… 111
Apply a currency format to cell values.. . . . . . . . . 113
Saving your changes as a personal document.. . 116
Logging out of InfoView…118
Lesson 5 Incorporating drill capabilities 119
Setting your drill options in InfoView..122
Opening a document in Edit mode… 124
Setting the scope of analysis for drill..127
Testing the document drill capabilities.. . . . . . . . 133
Saving the document as personal document.. . . 137
Logging out of InfoView…140
Lesson 6 Giving a document your corporate look 141
Opening a document in Edit mode… . 144
Naming the reports…. . . . 146
Inserting a chart in a report… . . . . . . 148
Defining the page layout of the report.. . . . . . . . . 158
Formatting a chart title and legend… . 162
Display alternate row colors in the table.. . . . . . . 167
Inserting a company logo in the page header.. . . 169
Saving the document to InfoView Corporate Documents. . . . 172
View the final document…175
Logging out of InfoView…176

READ / DOWNLOAD THIS SAP PDF GUIDE

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...

View the original article here

SAP BusinessObjects OLAP Connect Tutorial Guide

This 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 MS OLAP Services or SAP BW . 25
Chapter 2 Getting Started 27
Connecting to the Data Source . . 29
Defining the Data for a Report . . . 41
Changing the Report Data Source 72
Changing the Report Login . . . . . 75
Changing the Display of the List of Values in InfoView 79
Setting the Connection Strategy . 80
Getting Information About the Report Data . 82
Saving a Report Definition . . . . . . 84
Formatting the Report . 85
Refreshing the Report . 86
Including Different Queries in One Report . . 87
Chapter 3 Fine-Tuning Your Data Selection 89
Adding and Removing Dimension Members 91
Nesting . . . . 97
Using Filters to Focus Your Analysis . . . . . 100
Sorts and Ranks . . . . 114
Attributes . . 125
Chapter 4 Performing Time Series Analysis 131
Performing Periods to Date Analysis . . . . . 133
Editing a Time Series 139
Performing Opening Period Analysis . . . . 140
Performing Closing Period Analysis . . . . . 142
Performing Parallel Period Analysis . . . . . 143
Performing Last Period Analysis 146
Combining Time Series . . . . . . . 148
Chapter 5 Working with OLAP Calculations 149
Creating Calculated Members . . 151
Common Business Calculations 153
Using Common Business Calculations with Dimensions . . . . . 158
Business Statistics . . 160
Distinct Counts and Basket Analysis . . . . . 164
Custom Calculations . 170
Editing and Deleting Calculations . . . . . . . 173
Calculation of Values . 174
Standard BusinessObjects Calculations . . 175
Chapter 6 Creating an Interactive Document 177
Filter Prompts . . . . . . . 179
SAP Variables . . . . . . 192
Drill . . . . . . . 200
Formatting the Report 207
Distributing the Document . . . . . 208

View the original article here

SAP Universal Drill Through Service Tutorial Guide

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 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...

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...

View the original article here

SAP BusinessObjects Data Services Designer Tutorial Guide

SAP 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 with information that’s readily available, accurate, and trusted.

Contents of this SAP BusinessObjects Data Services Designer Tutorial Guide

Chapter 1 Introduction 21
Welcome to SAP BusinessObjects Data Services22
Welcome……….22
Documentation set for SAP BusinessObjects Data Services…22
Accessing documentation……..25
SAP BusinessObjects information resources…26
Overview of this guide…….28
About this guide28
Who should read this guide……29
Chapter 2 Logging into the Designer 31
Creating a repository………32
Associating the repository with a Job Server………32
Entering repository login information………33
Version restrictions…….33
Oracle login …..33
Microsoft SQL Server login……34
IBM DB2 login..34
Sybase ASE login………35
Resetting users……35
Chapter 3 Designer User Interface 37
Objects…….38
Reusable objects……….38
Single-use objects……..39
Object hierarchy………..39
Designer window…41
Menu bar….42
Project menu….42
Edit menu………43
View menu……..43
Tools menu…….44
Debug menu…..46
Validation menu47
Dictionary menu………..48
Window menu…48
Help menu……..49
Toolbar…….49
Project area ……….52
Tool palette53
Workspace.55
Moving objects in the workspace area.55
Connecting objects…….55
Disconnecting objects..56
Describing objects …….56
Scaling the workspace.56
Arranging workspace windows.57
Closing workspace windows….57
Local object library.57
To open the object library………58
To display the name of each tab as well as its icon…..59
To sort columns in the object library…..59
Object editors………60
Working with objects……….61
Creating new reusable objects.61
Changing object names63
Viewing and changing object properties………..63
Creating descriptions….66
Creating annotations …68
Copying objects69
Saving and deleting objects…..70
Searching for objects….72
General and environment options.74
Designer — Environment………75
Designer — General…..77
Designer — Graphics…78
Designer — Central Repository Connections..79
Data — General………..79
Job Server — Environment……80
Job Server — General..80
Chapter 4 Projects and Jobs 83
Projects……84
Objects that make up a project.84
Creating a new project.85
Opening existing projects………85
Saving projects.85
Jobs………..86
Creating jobs….87
Naming conventions for objects in jobs88
Chapter 5 Datastores 91
What are datastores?……..92
Database datastores……….93
Mainframe interface……93
Defining a database datastore.97
Configuring data sources used in a datastore100
Changing a datastore definition………102
Browsing metadata through a database datastore….104
Importing metadata through a database datastore….108
Memory datastores…..114
Persistent cache datastores…120
Linked datastores…….123
Adapter datastores……….125
Defining an adapter datastore126
Browsing metadata through an adapter datastore…..129
Importing metadata through an adapter datastore…..129
Web service datastores…130
Defining a web service datastore…….130
Browsing WSDL metadata through a web service datastore.131
Importing metadata through a web service datastore133
Creating and managing multiple datastore configurations……….133
Definitions…….134
Why use multiple datastore configurations?..135
Creating a new configuration..135
Adding a datastore alias………137
Functions to identify the configuration138
Portability solutions….140
Job portability tips…….145
Renaming table and function owner…146
Defining a system configuration………152
Chapter 6 File formats 155
What are file formats?……156
File format editor..156
Creating file formats………159
To specify a source or target file………159
To create a new file format…..159
Modeling a file format on a sample file………..161
Replicating and renaming file formats163
To create a file format from an existing flat table schema……164
To create a specific source or target file………164
Editing file formats………..165
To edit a file format template..165
To edit a source or target file..166
Change multiple column properties….166
File format features……….167
Reading multiple files at one time……167
Identifying source file names .168
Number formats……….168
Ignoring rows with specified markers.169
Date formats at the field level.170
Parallel process threads………171
Error handling for flat-file sources……171
Creating COBOL copybook file formats..175
To create a new COBOL copybook file format………..175
To create a new COBOL copybook file format and a data file………..176
To create rules to identify which records represent which schemas…177
To identify the field that contains the length of the schema’s record…178
Creating Microsoft Excel workbook file formats on UNIX platforms …….178
To create a Microsoft Excel workbook file format on UNIX …179
File transfers……..180
Custom transfer system variables for flat files………..180
Custom transfer options for flat files…182
Setting custom transfer options……….184
Design tips……185
Web log support…186
Word_ext function……188
Concat_date_time function…..188
WL_GetKeyValue function…..189
Chapter 7 Data Flows 193
What is a data flow?……..194
Naming data flows……194
Data flow example……194
Steps in a data flow….195
Data flows as steps in work flows…….195
Intermediate data sets in a data flow.196
Operation codes………196
Passing parameters to data flows……197
Creating and defining data flows.198
To define a new data flow using the object library……198
To define a new data flow using the tool palette……..199
To change properties of a data flow…199
Source and target objects200
Source objects201
Target objects.201
Adding source or target objects to data flows202
Template tables……….204
Converting template tables to regular tables..206
Adding columns within a data flow ………207
To add columns within a data flow…..209
Propagating columns in a data flow containing a Merge transform….209
Lookup tables and the lookup_ext function………211
Accessing the lookup_ext editor……..212
Example: Defining a simple lookup_ext function……..213
Example: Defining a complex lookup_ext function ….216
Data flow execution………219
Push down operations to the database server………..220
Distributed data flow execution……….221
Load balancing………..222
Caches………..223
Audit Data Flow overview223
Chapter 8 Transforms 225
Transform configurations.229
To create a transform configuration….230
To add a user-defined field ….231
To add transforms to data flows…232
Transform editors.233
Chapter 9 Query transform overview 235
Query editor………236
To change the current schema….237
To modify output schema contents……….237
To add a Query transform to a data flow.238
Chapter 10 Data Quality transforms overview 241
Data Quality editors………242
Associate, Match, and User-Defined transform editors…245
Ordered options editor…..246
To add a Data Quality transform to a data flow…246
Chapter 11 Work Flows 249
What is a work flow?……..250
Steps in a work flow………250
Order of execution in work flows.251
Example of a work flow….252
Creating work flows………253
To create a new work flow using the object library…..253
To create a new work flow using the tool palette …….253
To specify that a job executes the work flow one time………..254
Conditionals………254
To define a conditional256
While loops……….257
Design considerations257
Defining a while loop..258
Using a while loop with View Data…..259
Try/catch blocks…260
Defining a try/catch block…….261
Categories of available exceptions….263
Example: Catching details of an error263
Scripts……264
To create a script……..265
Debugging scripts using the print function…..266
Chapter 12 Nested Data 267
What is nested data?…….268
Representing hierarchical data….268
Formatting XML documents………271
Importing XML Schemas……..272
Specifying source options for XML files ……..278
Mapping optional schemas…..279
Using Document Type Definitions (DTDs) ….281
Generating DTDs and XML Schemas from an NRDM schema………283
Operations on nested data……….284
Overview of nested data and the Query transform….284
FROM clause construction…..285
Nesting columns ……..289
Using correlated columns in nested data…….290
Distinct rows and nested data292
Grouping values across nested schemas……292
Unnesting nested data ……….293
Transforming lower levels of nested data…….296
XML extraction and parsing for columns.297
Sample Scenarios……298
Chapter 13 Real-time Jobs 303
Request-response message processing.304
What is a real-time job?…305
Real-time versus batch………..305
Messages…….306
Real-time job examples……….308
Creating real-time jobs…..310
Real-time job models..310
Using real-time job models…..311
To create a real-time job………313
Real-time source and target objects……..316
To view an XML message source or target schema..317
Secondary sources and targets………318
Transactional loading of tables………..319
Design tips for data flows in real-time jobs…..320
Testing real-time jobs…….321
Executing a real-time job in test mode………..321
Using View Data………322
Using an XML file target………322
Building blocks for real-time jobs.323
Supplementing message data323
Branching data flow based on a data cache value…..326
Calling application functions…332
Designing real-time applications..332
Reducing queries requiring back-office application access…333
Messages from real-time jobs to adapter instances…333
Real-time service invoked by an adapter instance…..334
Chapter 14 Embedded Data Flows 335
Overview of embedded data flows……….336
Example of when to use embedded data flows…337
Creating embedded data flows….337
Using the Make Embedded Data Flow option338
Creating embedded data flows from existing flows….341
Using embedded data flows…342
Separately testing an embedded data flow….344
Troubleshooting embedded data flows……….345
Chapter 15 Variables and Parameters 347
Overview of variables and parameters….348
The Variables and Parameters window…350
To view the variables and parameters in each job, work flow, or data
flow…..350
Using local variables and parameters…..352
Parameters…..353
Passing values into data flows………..353
To define a local variable……..354
Defining parameters…355
Using global variables …..356
Creating global variables……..357
Viewing global variables ……..357
Setting global variable values.358
Local and global variable rules….363
Naming………..363
Replicating jobs and work flows………363
Importing and exporting……….363
Environment variables…..364
Setting file names at run-time using variables…..364
To use a variable in a flat file name….364
Substitution parameters…366
Overview of substitution parameters..366
Using the Substitution Parameter Editor……..368
Associating a substitution parameter configuration with a system
configuration…371
Overriding a substitution parameter in the Administrator…….372
Executing a job with substitution parameters 373
Exporting and importing substitution parameters…….374
Chapter 16 Executing Jobs 377
Overview of job execution378
Preparing for job execution……….379
Validating jobs and job components…379
Ensuring that the Job Server is running………380
Setting job execution options.381
Executing jobs as immediate tasks………381
To execute a job as an immediate task……….381
Monitor tab ….383
Log tab ……….383
Debugging execution errors……..383
Using logs…….384
Examining target data388
Changing Job Server options……389
To change option values for an individual Job Server392
To use mapped drive names in a path………..395
Chapter 17 Data Assessment 397
Using the Data Profiler…..399
Data sources that you can profile…….400
Connecting to the profiler server……..400
Profiler statistics………402
Executing a profiler task………406
Monitoring profiler tasks using the Designer..412
Viewing the profiler results…..414
Using View Data to determine data quality……….422
Data tab……….422
Profile tab…….423
Relationship Profile or Column Profile tab…..424
Using the Validation transform…..424
Analyze column profile………..424
Defining validation rule based on column profile……..426
Using Auditing …..427
Auditing objects in a data flow428
Accessing the Audit window…433
Defining audit points, rules, and action on failure……434
Guidelines to choose audit points …..438
Auditing embedded data flows………..439
Resolving invalid audit labels.442
Viewing audit results .443
Chapter 18 Data Quality 447
Overview of data quality..448
Address Cleanse.448
How address cleanse works…449
Prepare your input data……….452
Determine which transform(s) to use.454
Identify the country of destination……458
Set up the reference files…….458
Define the standardization options…..460
Beyond the basics……461
Process Japanese addressees ………514
Supported countries (Global Address Cleanse)………526
Address Server………..529
New Zealand Certification……533
Data Cleanse…….537
What is Data Cleanse.538
Parse data……538
Prepare records for matching.540
Data parsing overview541
Parsing dictionaries….548
Dictionary entries……..552
Classifications562
Region-specific data…571
Japanese Data………..573
Universal Data Cleanse……….578
Rank and prioritize parsing engines…601
Geocoding………..602
Prepare records for geocoding………..602
Understanding your output…..602
Match…….603
Matching strategies….603
Match components…..604
Match Wizard.607
Transforms for match data flows……..614
Working in the Match and Associate editors..616
Physical and logical sources..617
Match preparation……623
Match criteria..650
Post-match processing………..669
Association matching.692
Unicode matching…….693
Phonetic matching……696
Set up for match reports ……..699
Chapter 19 Design and Debug 701
Using View Where Used..702
Accessing View Where Used from the object library.703
Accessing View Where Used from the workspace…..706
Limitations……707
Using View Data..708
Accessing View Data..709
Viewing data in the workspace………..710
View Data Properties..712
View Data tool bar options…..717
View Data tabs………..718
Using the interactive debugger….723
Before starting the interactive debugger……..723
Starting and stopping the interactive debugger……….727
Panes.729
Debug menu options and tool bar……738
Viewing data passed by transforms…740
Push-down optimizer..741
Limitations……742
Comparing Objects……….742
To compare two different objects……..743
To compare two versions of the same object.744
Overview of the Difference Viewer window….744
Navigating through differences………..748
Calculating column mappings……749
To automatically calculate column mappings 750
To manually calculate column mappings …….750
Chapter 20 Exchanging Metadata 751
Metadata exchange………752
Importing metadata files into the software…..753
Exporting metadata files from the software….753
Creating SAP universes…754
To create universes using the Tools menu ….755
To create universes using the object library…755
Mappings between repository and universe metadata………..755
Attributes that support metadata exchange…757
SAP BusinessObjects Accelerator ………758
SAP BusinessObjects Accelerator Workflow.759
Modifying BWA indexes………760
Chapter 21 Recovery Mechanisms 763
Recovering from unsuccessful job execution……764
Automatically recovering jobs……765
Enabling automated recovery765
Marking recovery units………..766
Running in recovery mode…..767
Ensuring proper execution path………768
Using try/catch blocks with automatic recovery………769
Ensuring that data is not duplicated in targets………..771
Using preload SQL to allow re-executable data flows ………..772
Manually recovering jobs using status tables……774
Processing data with problems….775
Using overflow files….776
Filtering missing or bad values ……….777
Handling facts with missing dimensions………778
Chapter 22 Techniques for Capturing Changed Data 779
Understanding changed-data capture…..780
Full refresh…..780
Capturing only changes……….780
Source-based and target-based CDC781
Using CDC with Oracle sources..783
Overview of CDC for Oracle databases………783
Setting up Oracle CDC………..788
To create a CDC datastore for Oracle789
Importing CDC data from Oracle……..790
Viewing an imported CDC table………794
To configure an Oracle CDC source table……795
To create a data flow with an Oracle CDC source…..799
Maintaining CDC tables and subscriptions….800
Limitations……801
Using CDC with Attunity mainframe sources…….802
Setting up Attunity CDC………803
Setting up the software for CDC on mainframe sources……..804
Importing mainframe CDC data……….806
Configuring a mainframe CDC source………..808
Using mainframe check-points………..810
Limitations……811
Using CDC with Microsoft SQL Server databases ………812
Overview of CDC for SQL Server databases.812
Setting up Microsoft SQL Server for CDC……814
Setting up the software for CDC on SQL Server……..817
Importing SQL Server CDC data……..818
Configuring a SQL Server CDC source………821
Limitations……825
Using CDC with timestamp-based sources………825
Processing timestamps……….826
Overlaps………830
Types of timestamps..838
Timestamp-based CDC examples…..840
Additional job design tips……..847
Using CDC for targets……849
Chapter 23 Monitoring Jobs 851
Administrator……..852
SNMP support…..852
About the SNMP agent………..852
Job Server, SNMP agent, and NMS application architecture.853
About SNMP Agent’s Management Information Base (MIB)..854
About an NMS application……858
Configuring the software to support an NMS application…….859
Troubleshooting……….871

READ / DOWNLOD THIS SAP PDF GUIDE

Data Warehousing with SAP Bw7 Bi in SAP Netweaver 2004s: Architecture, Concepts, and ImplementationBI in SAP NetWeaver 2004s is the official abbreviation for the successor of the Business Information Warehouse (BW) which has been completely revised by SAP with its latest release. Core elements of this comprehensive suite for decision making applications are functions for extraction, transformation and data management. With this new release, these functions aim more heavily at company-wide data warehousing. The book focuses on these core tasks of SAP BW and gives well-founded insights into...

View the original article here