Google+ Facebook Twitter MySpace SC

SDN BLOGS


Useful links for SAP BW



SDN Articles - Integrated Planning




SDN Articles - BI Modelling

List Of Articles:


1) Data Source





7) Open Hub Destination (OHD) and APD


Analysis Process Designer: Step by Step Process for Formatting the Query Extract

APD to Update Marketing Attributes from SAP BI to SAP CRM

APDs and Open hubs Sending SAP BW Data to 3rd Party

InfoSpokes and OpenHubs in SAP BIInsert Custom Header and Remove Trailing Commas from APD Generated (or any)-CSV file

Join and Union options in APD

Open Hub Destination - Basics

Open Hub Destination - Make use of Navigational Attributes

Open Hub Destination-Use Same Logical Path for Multiple Directories

SAP BW Infospoke – Dynamic Update Selection Screen Values 


SDN Articles - BI Extraction


List Of Articles:

1) DB Connect



2) Extraction from R3








    2.a) COPA Extraction



       

    2.b) Generic Extraction
















5) XML Services


XML Data Extraction





SDN Articles - BI Loading

List Of Articles:

1) Data Transfer Process (DTP) :













 4) Miscellaneous

 Architecture for Extracting the Custom Hierarchies from Sap R/3 System into BW System 

 Data Loading Strategy for Global Data Warehousing Implementation 

 Extracting SAP ECC Compounding Hierarchies into SAP BI using Custom Datasource 

 Flat File Interface from SAP BW to External System 

 How Second Level Delta Machenisam in 3.x and 7.x 

 How to Automate Loading Hierarchies from R3 _ECC 

 How to Load Hierarchy from Flat File 

 Loading Hierarchies Using a Process Chain 

 Program to Activate Transformation and DTP 

 Restricting Invalid Characters from Loading into SAP BI 7.0 

 Special Characters in BI

 Technical Aspect of Hierarchy in BW







SDN Articles - BI Reporting

This page will provide the collection very good articles related BI Reporting from SDN.

List Of Articles:

1) Query Designer:

  a) Customer Exists:

 Using Customer Exit Variables in BW Reports Part - 18

  b) RRI (Report to Report Interface) :

 Enhance Report-Report Interface - Create Custom Report Type as Receiver 

 Fetching Data Directly from ECC System in BEX Query using RRI 

 Report to Report Interface in SAP BI 7.0 

 RRI - Parameters Not Transferred to R3 Transaction 

 SAP BW -- Pass Selection Screen Values using Customer Exit Variables in RRI 

  c) Series of articles about Query Designer :
Understanding BEx Query Designer- Part-1 Screen Appearance

 Understanding BEx Query Designer: Part-2 Structures, Selections and Formulas

 Understanding BEx Query Designer: Part-3 Calculated Key Figures and restricted Key Figures

 Understanding BEx Query Designer: Part-4 Conditions & Exceptions

 Understanding BEx Query Designer: Part-5 Query Element Properties

 Understanding BEx Query Designer: Part-6 Simple Query Design

  d) Text Variable :

 How to Use Text Variables in BW Reports Part - 1

 How to Use Text Variables in BW Reports Part - 2

 How to use Text Variables in BW Reports Part - 3

  e) Miscellaneous

 BW Text Variables of Type Replacement Path

 Calculating the Difference between Created Date and Changed Date in BW-BI Reports

 Change the Query Cache Mode

 Creating Bucket Scenarios using Exception Aggregation (SAP Netweaver 7.0 BI)

 Customer Exit Variables in SAP BW_BI Reports – First day of the Current_ Previous Month

 How can a Reference Query Be used?

 How to Create Variable for a Given Key Figure

 How to Get the List of Queries Having a Particular Variable, Infoobject

 How to Make Conditions and Exceptions Work Based on User Defined Values at the Time of Report Execution

 How to use Boolean Operations in the Formula as Subsidiary for “IF” Condition

 How to Use Cell Definition to Calculate Incentive of Salesmen

 Inconsistencies on Reusable Query Elements (Objects) – BI 7.0

 Master Text data label display in BEx Query

 Populating Virtual Characteristic and Highlighting the Values

 Replacement Path Explained with an Illustrated Example

 SAP BW - Copy Query Between Mismatch Info Providers and Queries

 SAP BW - Dynamic Call Customer Exit Variables Using Same Exit

 SAP BW - Virtual Characteristic Ext (RSR00002)

 Step by Step Guide on How to Use Cell Definition in BEx Query

 Step by Step guide to Fiscal Week and Fiscal Quarter

 Step by Step Procedure to Create Broadcasters, to Schedule and to Enhance of SAP- BI Queries from Query Designer

 Step By Step Process for Virtual Key Figures and Characteristics through BAdi

 The Definitive and Complete Method for using Virtual Characteristics and Key Figures in NetWeaver BI

 Variable Exit in Sap BI 7.0 - How to Start

 2) BEx Analyzer (Report Analyzer) :

 How to Use Cell Restrictions in BEx (BI) Reports

 Step by Step Procedure of Creating Workbook using Bex Analyzer

 Understanding OLAP Processor and RSRT

 View the Reports Based on Two Fiscal Definition

 3) Web Application Desginer (WAD) :

 Customizing SAP Delivered BEx Standard Template

 Formatting BEx Workbook Template

 How To Build a Fast and Flexible Comment Solution for BEx Web Applications

 How to Read Variable Values in WAD 7.0 Using JavaScript

 Using Radio Button in Web Template

 WAD Web Item and Parameter ModificationWeb Application Designer – Tips and Tricks to use Commands




SDN Articles - BI Related ABAP


List Of Articles:

i) Data Source Enhancements:






iii) Routines:











iii) Miscellaneous:











SDN Blogs Index - BW Part1

List Of BW Blogs:


How most BW performance support messages are solved

All embracing inventory Management in BW with special emphasis on Non cumulative and Markers

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26630


How to Fetch Your Info package Details From R/3 System

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26901


3 Easy Steps to Upload an Image into Process Chain Maintenance Screen

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26069


How to save your Listcube selction screen and the output

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26903


Creating Multiple Records using Expert Routine

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26868


BEx Workbooks Size Reduction for Performance Boost up

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26885


Get list of workbooks in roles and queries included in workbooks

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26553


Query searching based on Object name

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26591


Process Chain Monitoring - Approach and Correction

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26274


SAP BI Statistics Installation

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26437


How To Collect a Variant and ABAP Program in a Transport

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26516


Demystifying aggregates in SAP BI 7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26054


Inversion Routines - Making use of Set Objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26414


Getting Number of Partitions for all active Infocubes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26411


Maintain Currency Translation Ratios in OBBS

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26245


Different Options for Debugging BEx Query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26356


Reporting on SAP BW Performance

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26234


RSZELTPROP: The Query Element Parameters Table

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26225


'Force Delta' in BW Dataflows

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26033


All About SAP BW Transport Errors and fixes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26159


SAP BW System Improvement Tips

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26113


BW Technical Content – Deletion of BI Statistics

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26114


Capturing data from BEx Query output and storing in BI/BW Data Targets using Analysis Process Designer (APD)

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25452


Transport History of BW Objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26026


Some of the known reasons of the slow performing Change run

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25723


Why Data Transfer Process (DTP) over Info Package (IP) in SAP BI 7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25907


BW: Restricting the value help in the variables screen of a query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25694


Execute a BW query by excluding values from another BW query

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25643


Dissection of a long running Hierarchy Attribute Change run job

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25616


Parameters of table RSFRONTENDINIT - BW's frontend requirements

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25652


Display of totals with Non-cumulative Key figures

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25632


Data Loads from Data Stage to BW

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25622


Periodic Maintenance of RSDDSTATLOGGING Table

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25611


Collection of Dependent Objects in a Transport Request

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25505


Migration of Update Rules, 3.x InfoSources, and Transfer Rules

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25567


BW Transport - Order of Object list

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25550


The concept of Business Intelligence for ALL (part 3 of 3)

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25645


Bizzare Bex Report: Concatenating multiple rows in a single cell

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25440


Avoiding ECC Downtime for LO data source Full Reloads

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25607


How to find the usage of aggregates in Reports

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25407


How to Convert a Standard Info Cube in to a Real-Time Info Cube with Data

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25408


Remodeling on DSO

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25362


Exceptional Broadcasting using Bex in BI7.0

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25374


You don't have to be an expert to write Expert Routine

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25313




SDN Blogs Index - BW Part2

List Of Blogs:

Dependency information of Function Modules in BW transformations and DTPs

List BEx Analyzer 7.X variables and generate the associated PROCESS_VARIABLES commands


SAP BW: monitor inactive objects (Multiprovider, Cubes, Update Rules etc.) after the import of transport requests 


General Guidelines for ABAP coding in BW


Deletion of WDSO (Write-optimized DataStore object) Load requests and active table data without deleting it from target


Hey Kids, it's time to learn BW!


Remodeling in SAP BI 7.0


Interrupting the Process chain


Creating a Unit InfoObject


How to schedule Bex Broadcasting jobs using Process chain


LOST IDOCS?


Naming Convention for SAP Netweaver BI -Integrated Planning


Difference between transactions RS12 / SM12 ?


How to use ABAP routine in Infopackage, where Fiscal month range is based on current month


Validate Bex variable values


Bex variables – where used list


Filling an Infocube with sample data without loading it!


How to find the BW 7.0/7.01 Planning URL


What is the future of Infocubes?


Copy Queries(RSZC) across infoproviders which are slightly different


DSO activation job log and settings explained


Performance Improvements for DataStore Objects


What actually happens when you schedule a report to run "right-now"?


Overview of BW tables per object type


Removing Invalid Characters using field routine


An Introduction to Modern BI


DSO Transport and Activation performance issue - adding new fields


Loss Data into infocube after executing report RSDG_CUBE_ACTIVATE


Counters in Infoproviders - Boon or Bane ?


How to generate a selective deletion program for info provider


How to get selection criteria in Transformations routines?


How long BEx report in Excel can be?


New SAP Note - 1516916 - RSAU_UPDR_REACTIVATE_ALL doesn't activate inactive upd. Rule


Summary of BI/BW 7.0 performance improvements


Optimize the Use of SAP BW Reports

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21323


List of Characteristics and Keyfigures Used in Levels

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21330

 


SDN Blogs Index - BW Part3

List Of Blogs:

How to get selection criteria in Transformations routines?

Overview of BW 3.x to 7.x migration possibilities per BW objects


BW 7.30: Transport support in BW landscapes


How to generate a selective deletion program for info provider


Counters in Infoproviders - Boon or Bane ?


Triggering Email to different users using same email setting each with different Query Variants


Two Frequent Business Warehouse Issues - 1/2: RSTRAN803


How long BEx report in Excel can be?


New SAP Note - 1516916 - RSAU_UPDR_REACTIVATE_ALL doesn't activate inactive upd. Rule


Summary of BI/BW 7.0 performance improvements




SDN Articles - BW Administration

List Of Articles:

 The Documents in this section answers most of the questions related to Administration in SAP BW/BI.
i) Aggregates:

 The below documents will give overview about when to create aggregates and how to create also how the performance improvement will happen due to aggregates.


ii) Authorizations:

 This section tells about how the Analysis Authorizations works and how to create them. How the analysis authorizations works at report level.



iii) Attribute Change Run (ACR):

What is Attribute Change Run, Advantages of it. Back end operations of Attribute Change Run. How to run the Attribute Change Run. 


SAP BW Hierarchy Attribute Change run Management

 iv) DSO Administration:

 This section explains about the different parameters in DSO Administration. How to check the DSO Activation job log. This also gives information about step by step procedure of selective deletion in DSO.




v) Info Cube Administration:

This section provides information about different operations we perform on info cube like
i) Compression ii) Roll Up and how to do LISTCUBE. This also explains about indexes in Info Cube.







vi) Miscellaneous:

This section gives overview about the daily activities we do in normal BI systems like

 a) Lock Entries
b) Decommission of specific objects and how to find inactive objects in BI system.
c) How to perform where used list on different objects.
d) PSA and Change log deletions.
e) how to manage jobs in SAP BI.


















vii) Process Chains:

This is the most important part in SAP BI Support Projects. This gives information about the below things

a) Process chains creation.
b) Different Process types available.
c) Alerts creation in Process chain
d) Decision steps in Process chain
e) Process chains monitoring and frequent issues we face and lot more.























viii) Transports:

This sections provides knowledge about the transport management in SAP BI. Which includes
a) Transport Creation and adding objects to it.
b) Moving transports from one system to other.
c) Regular issues we face.
d) Best Practices.












 

No comments:

Post a Comment

Subscribe to: Posts (Atom)