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 will be a nightmare job, if we have too many objects.
Issue DetailsBasis 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 facingDelta Load issues for some of the Master Data DataSources. Error messages
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 blogHow to create data archiving process based on ADK methodStep 1 : Go to transaction RSA1 and right click on the
文章目錄 The IdeaThe Variable-InterfaceConclusion 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
In this document I’ll discuss about an efficient method suggested by SAP to delete incorrect or obsolete master data from the system. NeedThere are many scenarios, in which we will get incorrect master data in the BW system due to incorrect entries
大型系統的生產環境,一般情況下,我們評價一條查詢是否有效率,更多的是關注邏輯IO(至於為什麼,回頭補一篇)。我們常說,“要建彪悍的索引”、“要寫高效的SQL”,其實最終目的就是在相同結果集情況下,儘可能減少邏輯IO。1.1 where條件的列上都得有統計資訊。沒統計資訊SQLServer就無法估算不同查詢計劃開銷優劣,而只能採用最穩妥的Scan(不管是table scan還是clustered index
初始化資料來源包括以下步驟:1.資料來源的Delta初始化結構儲存2.在資訊包中檢查包的所有資料3.請求變綠,delta隊列已經產生在很多應用中,當Delta正在初始化業務處理必須停止 Situation A: The delta process must be initialized successfully (including generating the delta queue for the DataSource) before you can update new
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 for user exits in CMOD exit makes it cumbersome and
用vc++開發的activex空間註冊失敗,用regsvr32 TestOCX.ocx註冊時提示:LoadLibrary("TestOCX.ocx") failed-The specified module could not be found用depends察看TestOCX.ocx發現缺少一些檔案從開發機器上拷貝對應的檔案到測試機後再次depends時發現又缺少其他檔案這樣拷貝檔案不是解決問題的方法,因為客戶機環境千差萬別.最後想到可以做靜態編譯選擇Project-> Setting,
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 will be given in subsequent blogs.For a first rapid
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 cornerstones of your future BW