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
SAP BW Client – SBIW : SAP Business Information Warehouse IMG (Implementation Guide) – RSA1 : Modelling DW Workbench. This is Main Transaction – SCC4 : Client Administration (BASIS Area) – RSECADMIN : Authorization, Replacing Obselete RSSM – SE10 : Transport Organizer – RSPC : Process Chain Maintenance – SE37 : ABAP Function Modules –… Continue reading
Problem 1. Remote Desktop Connection (RDC) from Vista x86 as Client to Windows Server 2008 x64 as Server, lost (disconnected) in randomize duration. The error message: Because of an error in data encryption, this session will end. Please try connecting to the remote computer again 2. SQL Server Management Studio 2008 on Vista x86 cannot… Continue reading