Periodic Jobs and Tasks in SAP BW

This whitepaper, provided by SAP, is a must for those use SAP BW and it provides recommendations about jobs and tasks that have to be performed on a regular basis to ensure system performance and stability in a BW system. It may be also useful for you to check Daily BW Systems Checklist

  • Support Package Strategy
  • Backup Strategy
  • Transports and SAP Notes
  • Monitoring Basis Jobs
  • Monitoring Application
  • Monitoring Query Performance
  • Create, Delete Aggregates
  • Data Management and more…

Read more

BEx Ad Hoc Query Fundamentals

BEx Ad Hoc Query Fundamentals provides key terms and concepts BI Power Users need to understand prior to creating an ad hoc query in BEx Query Designer.

BEx Ad Hoc Query Fundamentals are organized in multiple sections.  Each section will build on the concepts covered in previous Fundamentals topics:

  • BEx Ad Hoc Query Fundamentals – Part I: Provides an overview of basic key terms and concepts BI Power Users need to understand prior to creating a basic ad hoc query in BEx Query Designer. This section covers key terms and concepts of Key Figures, Dimensions, Characteristics, Free Characteristics, Attributes and Filters
  • BEx Ad Hoc Query Fundamentals – Part II: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I. This section covers key terms and concepts of Key Figure Properties, Restricted Key Figures, Caharacteristic Properties and Variables
  • BEx Ad Hoc Query Fundamentals – Part III: Builds on the key terms and concepts covered in BEx Ad Hoc Query Fundamentals – Part I and Part II. This section covers key terms and concepts of Compound Characteristics, Hierarchy Characteristics, Hierarchy Characteristic Properties, Hierarchy Variables, Basic Formulas, Ad Hoc Query Dates, Key Date

Read more

Daily BW Systems Checklist

This list of transactions is designed to guide a Basis Admin team member through the process of keeping tabs on major systems issues and root cause issues and trends for each system in the landscape.

This will only identify and help triage issues to Helpdesk, Infrastructure, OS team or DBA team, Basis or functional developers or whomever…but guarantees that each system in a landscape gets a regular, weekly look. The goal is to eliminate root causes of repeating issues.

Read more

Using Master Data in Business Intelligence

Master data is reference data about an organization’s core business entitles. These entities include people (customers, employees, suppliers), things (products, assets, ledgers), and places (countries, cities, locations). The applications and technologies used to create and maintain master data are part of a master data management (MDM) system. MDM, however, involves more that applications and technologies, it also requires an organization to implement policies and procedures for controlling how master data is created and used.

Read more

How to Load a Flat File in SAP BI Integrated Planning Using BEx

SAP NetWeaver BI Integrated Planning now has the ability to allow users to upload data directly into transactional cubes. The solution outlined in this paper provides a how-to guide to use flat file upload functionality in BEx. It also shows step-by-step how to use a query to preview the data uploaded before deciding whether to save (write) the data to the target cube. This is basically replicating the BPS file upload functionality in IP. The solution depicted in this paper provides the user with the familiarity of BEx, but with the flexibility of Integrated Planning.

Read more

BEx Query Designer Presentations for Beginners

The BEx-Query Designer is used to prepare analysis – known as queries – of all data stored in the SAP BW. The Query Designer can be invoked via the Web or from MS Excel or can be installed as a desktop application. After the Query Designer has been started, the Open dialog allows a fast access to the InfoProviders in the SAP BW and the queries already present.

This presentation package consists of the following topics:

  • Unit 1 – Introduction to BW Reporting: You will be introduced to BW architecture and objects used in SAP BW: InfoObject, InfoCube, Infoprovider and ODS…
  • Unit 2 – BEx query Designer: This presentations gives a brief definition of BEx Query Designer and basic steps required to create, change and display a Query
  • Unit 3 – Calculated and Restricted KEy Figures: Learn what Calculated and Restricted Key Figures are and know their properties. Structures and Cell Editor also covered in this unit
  • Unit 4 – Properties and Attributes of Characteristics: Get a brief overview of Attributes and properties of the Display Hierarchy
  • Unit 5 – Variables: Learn what variables are used in Query Designer
  • Unit 6 – Query Properties: After reading this unit you will be able to understand the purpose of setting parameters under General, Display and Extended properties.
  • Unit 7 – Exceptions and Conditions: What are Exceptions and Conditions ? Read this unit and learn how to create them.

Read more

Top 5 Cool Technical Developments to Learn

After reading this document you will be able to:

  • Expand your overall understanding of existing proven SAP technologies

-Utilize ABAP Shared Memory to ”buffer” data
-Utilize Web Services to retrieve BI data and consume that data in an MVC BSP application
-Utilize Portal Dynamic System Alias functionality to eliminate dual administration
-Utilize Business Server Pages and HTMLB to easily present BI Report Channels in the Portal
-Utilize Java Pricing exits and BADIs to pass additional information within CRM’s Internet Pricing Engine (IPC)

  • Creatively use these SAP technologies and techniques to deliver solutions in your own environment
  • Learn a basic level of detail so you can prototype a solution within your own company

Read more