Read Master Data (Master Data Derivation) in SAP BW NW 7 is one of popular Transformation method to fill an InfoObject on a Cube or DSO. I think 99 percent of SAP BW architecture use this method. Recently we have problem , an ABAP dump (error) occurs just after we finished a modification to a… Continue reading
If you are using ASP.NET Membership Provider for a website, one simple and practical way how to get ‘username’ for logging activities on CRUD (Create Read Update Delete) implementation is by storing the “username” on a session. Put this little code on Default page, or first landing page after succesfull user login.
|
1 |
using System.Web.Security; |
…
|
1 2 3 4 5 6 7 8 9 |
protected void Page_Load(object sender, EventArgs e) { //check user login if (User.Identity.IsAuthenticated) { //get username and put into session Session["UserName"] = Membership.GetUser().UserName.ToString(); } } |
Managing Query in SAP BW NW7 can be done with theese tools and t-code: Note for Deleting Query Deleting Query can be easily done by using this t-code: RSZDELETE or using Query Designer, but sometimes problem just happen. Problem / Symptom that migght happen when Deleting query with RSZDELETE: The Query Cannot be deleted from… Continue reading
After getting to know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is http://sap.seo-gym.com/. Lots of goodies relating SAP BW, such as tutorials, learning guides and help files containing PDF or Microsoft Documents (Doc) . Interesting, I thought the page/sub domain is a technic for Search Engine… Continue reading
The common T-SQL script to shrink/truncate log file is using the script below
|
1 2 3 |
USE [foo] GO DBCC SHRINKFILE(foo_log, 1) |
But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file. To solve the issue here’s a work… Continue reading
although CURSOR and FETCH is classified as ‘evil‘ in SQL server, but sometimes we cannot avoid using it. Cause in some scenarios, pivot and other similiar method to perform looping and transformation is not sufficient enough. here’s a link of good example implementing cursor. all example copy from microsoft sites, http://msdn.microsoft.com/en-us/library/ms180152.aspx A. Using FETCH in… Continue reading
Problem: Cannot delete Data Transfer Process (DTP) from DSO/CUBE to DSO/CUBE. Despite all the pre-conditions have been met, such as deleting data and requests in the target and source. Error Message: Delta DTP cannot currently be deleted (see long text) Message no. RSBK037 Diagnosis You want to delete a delta DTP that has been successfully… Continue reading
With UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a SAP RemoteCube…. Continue reading
SAP Net Weaver 7 (SAP NW7) has a capability to store query bookmark on web application (Bex Web Analyzer). If we execute query from Query Designer, than it will launch a query in web application. The other way running a query is from Excel Ad In (Query Analyzer). I like to run query from web… Continue reading
First, if there is an error on the activation of a DataSource Object (DSO) or the Transfer Rule Object. Run this transaction code: RSRV: Analysis and Repair of BW Objects Second, If an SAP BW InfoObject get an enhancement then it should be repaired too. Apply these steps: Run this transaction code: RSA1 : Goto… Continue reading