Here’s are steps that need to execute before start executing Data Transformation 1. Delete Data and SID On Cube (Destination) 2.Delete Index (Destination) 3.Delete Aggregate (Destination)
SAP BW : Prepare Large ETL (DSO and Cube)
Posts tagged "erp"
What is the secret recepies for making a good and reliable ERP system ?
What is the secret recepies for making a good and reliable ERP system ?and the answer is… Centralization of Master Data All you have to do is to have one Centralize ‘Master Data’ and the next steps, which is, how you have to build ERP system is becoming less important (critical). Any implementation model, In-House,… Continue reading
SAP BW: DTP, Extract Very Large Data from PSA to DSO
The next step in SAP BW after Initial (INIT) and Full of Logistic (LIS) Data Extaction (with InfoPackage) from SAP R/3 to Persistance Storage Area (PSA), is to load very large data (2LIS_11_VAKON) from PSA to DataSource Object (DSO). This data source is one of the biggest Datasource we have on our SAP BW 7… Continue reading
SAP BW: COPY, DELETE Query and WorkBook
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
SAP BW, Documentation (1)
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
SAP BW : Cannot delete DTP
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
SAP BW UD Connect and SQL Server Unicode Setting
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 BW , Repairing BW Objects
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 NW7 Transaction
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
How good is SAP ERP, really?
SAP ERP is the flagship ERP solution from the third largest software company in the world. So it has to be good, right? That’s the marketing hype, but does that mean that SAP ERP is good for the particular needs of your organization? Because at the end of the day, that’s what really matters. And… Continue reading