- 博客(265)
- 资源 (7)
- 收藏
- 关注
原创 Exit Variant
一同事收到BT需求,要求在主数据中将不必要的数据过滤掉,原来这种实践应该在主数据加属性就可以完成的,查了查NOTES有这种解决方案: 将所有的值LOOP 至内表LOW字段值,且将变量定义成Select option variable 类型, 出口变量中控制数据出口; Symptom Either you want to create a new variable of the cus
2014-01-16 09:00:52
269
原创 About PSA
针对网上一系统的PSA 理解,我们来深入理解下啥是PSA,以及他是怎么样操作的一种机制: http://scn.sap.com/thread/1799927 首先PSA table的内容都是和request关联的(上次有提到怎么看关联)。 而且在BW系统脱离request存在的数据抽取是不现实的。 (这句话怎么理解有些微妙,
2014-01-15 13:27:15
348
转载 Performance Tuning
Performance Tuning Ø When the query is running slow, how should we improve the query performance? Query Performance Ø When we are extracting data from source system to BI, Loading might
2014-01-12 23:37:22
187
转载 How to find the transport request that changed a BW Object in the system
Any sudden change to an existing BW object(s) in the system may be caused by a transport request. This document helps in finding the transport request which made changes to a BW object. There are ma
2014-01-12 23:10:51
173
转载 How to retain deltas when you change LO in Production system!
Requirement may come up to add new fields to LO cockpit extractor which is up & running in production environment. This means the extractor is delivering daily deltas from SAP R/3 to BW system .
2014-01-12 23:09:41
215
转载 How to Create generic extractor to get the Value Table of Domain
Requirement - Many times we have requirement to get the data of “value table of domain” inside BW infoobject. To solve this one we can create a generic extractor on this domain. S
2014-01-12 22:33:33
162
转载 How to insert record in report at run time
Scenario Description:- In general ledger data remains in transaction currency, local currency etc. If we want to display trial balance in local currency (company code currency) i.e. r
2014-01-12 22:23:23
229
转载 如何修改已释放的请求
1. 找到你已经释放但是又需要修改的请求号 2. 进入E070表中,找到你的请求,此时该请求的TRSTATUS是R-已释放状态.我们要只把该字段的值改为D-修改状态,即可.(个人习惯是先修改子请求 ,再修改 母请求 .) 3. 输入调试命令,按两次回车,进入DEBUG界面. 4. 修改CODE值为EDIT(注意大写).
2013-04-10 22:29:10
440
转载 Incorrect Master Data Deletion
In this document I’ll discuss about an efficient method suggested by SAP to delete incorrect or obsolete master data from the system. Need There are many scenarios, in which we will get incorrect
2013-03-26 22:40:12
426
转载 Easy implementation of BEx-Userexit-Variables
If you want to control the processing of BEx-Queries you can define different types of variables: Manual Entry/Default Value, Replacement Path, SAP Exit, Authorization or Customer Exit. This blogs dea
2013-03-26 20:44:16
413
转载 SAP NetWeaver BW: BW Layered Scalable Architecture (LSA) Building Blocks
Welcome to my second blog about the BW Layered Scalable Architecture (LSA) the reference architecture for large scale BW DWHs/ EDWs. In this blog we will have a look at the LSA Building Blocks, the co
2013-02-25 22:24:54
561
转载 SAP NetWeaver BW: What is the BW Layered Scalable Architecture (LSA) all about?
This blog provides an overview about the BW Layered Scalable Architecture (LSA) the reference architecture for large scale BW DWHs/ EDWs and the process of customer adoption. Details about the LSA wil
2013-02-25 22:13:00
595
转载 Badi Implementation for Bex user exit variables
This document gives the step by step method for implementing BADI for user exit variables in Bex. This is an alternative approach to adding the code in EXIT_SAPLRRS0_001 through CMOD. Writing codes f
2013-01-04 14:39:36
1101
转载 Generating Custom Hierarchies in SAP BI BW using Custom DataSource
Summary Standard Business Content extractors support main hierarchies but it does not support all the hierarchies. SAP does not provide a standard DataSource to extract Employee-Supervisor Hierarchie
2013-01-04 11:51:14
1319
转载 DATA ARCHIVING PROCESS IN SAP BW
This document explains the steps on how to create a DAP in sap bw, more information on what is archiving is covered in my archiving blog How to create data archiving process based on ADK method
2013-01-04 11:43:54
790
转载 How-to document on ALE pointers causing delta issues for master data Datasources - post Support-pack
Issue Details Basis team is doing a support pack upgrade from BI 701-007 to 701-012. After this upgrade done in Sandbox, Development, Quality and Pre-production we are facing Delta Load issues for
2013-01-04 11:41:45
494
转载 Unlocking Objects while creating Transport Requests
Introduction We face many issues while creating Transport Requests like "some objects are locked in other transport requests". Generally we keep on deleting each object individually in SE09 which
2013-01-04 11:40:17
382
转载 Performance Optimization techniques in SAP BW
Introduction: The performance of the data warehouse processes depends on various factors. Good system performance begins with the design of the data model. The other important aspects that affect B
2013-01-04 11:19:45
865
转载 Program to delete table entries
Scenario : We may come across different inconsistencies in the data base tables due to incorrect deletions happened in the Infoproviders, Infopackages etc.. At times, we are forced to delete the un
2013-01-04 11:17:21
320
转载 Enhanced functionalities of Process chains in SAP BW 7.3
Enhanced functionalities of Process chains in SAP BW 7.3 Applies to: SAP NetWeaver Business Warehouse 7.30 (BW7.30) Summary This paper provides details on enhanced functionalities of proce
2013-01-04 10:26:18
493
转载 Update Behavior of Fields in the End Routine
Update Behavior of Fields in the EndRoutine Use Using thisfunction, you can change the update behavior of fields in the end routine of astandard DataStore object or master data attribute. Depend
2012-08-25 12:39:51
343
转载 Real-Time Data Acquisition
Description Real-time dataacquisition (RDA) supports operative reporting. The data is transferred intoBI at regular intervals and is then updated to the DataStore objects, whichare directly available
2012-08-25 12:39:14
348
转载 How to write routine to fetch current day's filename
Applies to: SAP BI 7.0 developers for carrying out tasks related to data loading and monitoring. Summary This document provides step by step approach to create infopackage/ datasource routine to fe
2012-08-12 16:18:56
633
原创 Financial Accounting: Line Item Extraction Procedure
General information about the line item extraction procedure For the General Ledger, selection is made from tables BKPF and BSEG, while selection for the subsidiary accounts is made from t
2012-07-30 23:07:11
521
转载 ABAP program to find BI lookups and code Patterns
Description *****************Actual Source Code for the Program******************************************** *********************************************************************** * PROGRAM
2012-07-25 23:07:51
360
转载 Business Transaction Events (BTE)
What is a BTE BTE are comparable to the old enhancementsBTEs are used mostly within FIBTEs can be used both by SAP, third party vendors and customers. Each use their own function modules where the
2012-07-15 21:28:16
394
转载 Easy implementation of BEx-Userexit-Variables
If you want to control the processing of BEx-Queries you can define different types of variables: Manual Entry/Default Value, Replacement Path, SAP Exit, Authorization or Customer Exit. This blogs dea
2012-06-18 11:15:14
337
原创 BW中的增强类型
根据所了解的资料,BW中的有关增强可分为五部分,如下: 1、 数据抽取增强 即在标准数据源中加入数据源中所不存在的字段,或者标准数据源不存在所需数据而需要自定义数据源,相关的事务代码有RSO2(用于定义一般数据源)、RSA6(维护数据源,用于增加其他字段)、SMOD(出口:RSAP0001,其中EXIT_SAPLRSAP_001用于业务数据,EXIT_SAPLRSAP_002用于主数
2012-06-11 09:38:44
461
转载 SAP用户出口(exit)问题--数据源增强
SAP用户出口(exit)问题 数据源增强 sap的用户出口总共有三代: 第一代 sap提供一个空代码的子过程,在这个子过程中用户可以添加自己的代码,控制自己的需求。这类增强都需要修改sap的标准代码。 示例:USEREXIT.. in SAPMV45A 对于第一代增强,可以用以下方法查找增强:打开欲增强的程序,点击工具栏上的“Display Object List”按钮,
2012-06-11 09:26:59
503
原创 bw report language problems
Sometimes,bw report display "#" charater,now following those steps many help you again. 1,check language installed package using tcode RSCPINST 2,check RFC charater extractor setting through tcode S
2012-05-31 10:32:07
245
转载 Useful functions for Data Transformation
Functions for Data Transformation RSAU_READ_MASTER_DATA Very often you need to read a characteristic's [attribute] during a data transformation process, e.g. in an update rule. Rather than accessing
2012-05-28 23:24:48
264
转载 How to find size of Infocube
************************************************************************ * Description... InfoCube Size Determination * Author - Kenneth Murray * Disclaimer.... The author of this program ass
2012-05-28 23:22:41
322
转载 Program to get List of Scheduled Process Chains
Applies to: SAP Business Warehouse, Netweaver 7.0 Summary There is no simple straight forward way to get a list of scheduled Process chains in SAP BW system. This program will give you a list of pr
2012-05-28 23:00:53
241
转载 How to check the status of the job in the application server level
Sometimes there comes situation where the job doesn’t progress with further steps in the Job log and it remains on hold for long time (even for several hours). So if the job doesn’t proceed with the
2012-05-25 11:23:29
211
转载 SAP BW 7.30: Semantically Partitioned Objects (SPOs) built from BAdI
Abstract Logical Partitioning is a very popular modeling pattern in BW. It means instead of storing data in a single InfoCube or DSO distributing the data into several identical InfoCubes or DSOs.
2012-05-21 15:42:16
611
转载 Currency symbol display in BEx 7.0
Query Output with stadard design option: The Query output with default setting for currency ; Sample query: Currency key is appearing after values of amount key figure. Report require
2012-05-21 14:45:42
272
原创 BW学习笔记1
1,Abr 与 aie 的区别 Abr 支持新项,前项,后项和反转像 Aie只支持后项,所以模型选择上,只支持aie的数据源,psa上层只能选择dso,支持abr的数据源既可以选择dso也可以选择cube。 2, 2lis_03_bx,2lis_03_bf,2lis_03_um 三个数据源的区别以及加载时的先后顺序。 2lis_03_bx 存放盘点数据 2lis_03_bf 存放
2012-05-10 15:55:26
140
原创 Reset the status of a process chain step_updating
*********************************************************************** * Author: leno email:leno.lotus@gmail.com * Function: Resets the status of a process chain step. *****************
2012-05-04 16:06:24
284
原创 Procedure for Custom Hierarchy Extraction In SAP BW
Many times,you wanna create custom hierarchy whereas no stardard hierarchy. this topic purpose of these articles is to Create a custom hierarchy in R/3Create a Generic Hierarchy data source for the
2012-05-03 13:29:04
244
Apress-Pro SQL Server 2008 Disaster Recovery (2008)
2010-02-09
Apress-Pro SQL Server 2008 Relational Database Design and Implementation(2008)
2010-02-09
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人