SAP Business Intelligence
How to save hours of frustration when working SAP Application Process Designer (APD)
A client requests a specific report to be saved as a flat file.
In this case, the format is a comma space vertical (CSV) delimited file, which is a common workaround for Microsoft Excel’s limitation of 65,000 rows. That sounds easy enough.
SAP Security Tip: How To Quickly Find Existing Roles
Filling out a security form for a new multiprovider or query is never fun. Here are some steps that may help to smooth that process.
Find a similar multiprovider/query and get the following ZA and ZR roles, where ZA allows a user to access a query or multiprovider and ZR allows a user to find the query in the appropriate role/folder in BEx.
Issue: Replicate Datasource (SAP BW 7.0 SP 20)
I ran into this issue when trying to load from an export datasource (based on an ODS) into another ODS.
- I replicated the datasource, but the problem persisted.
- I activated the update rule, but the problem persisted.
- I logged off the system, re-entered RSA1, and the problem was solved.
FICO Transaction Codes
https://wiki.sdn.sap.com/wiki/display/ERPFI/SAP+FICO+Transaction+Codes
Posted via email from hau’s posterous
Read MoreRuntime Error with BEx Variables
Because today is Monday and the beginning of the workweek, I was greeted with this error message when creating a sample query.
Read More“My setup job isn’t doing anything.”
A coworker faced a common issue when loading setup tables in the SAP ECC source system.
When he started collecting sale orders and filling the setup table via transaction OLI7BW, he noticed that the job was running for a long time. He was not sure if it was still processing or if it had an error.
“Should I go ahead and delete the job“, he asked.
Read MoreAbout Me
SAP BPC, BI, and BW Developer based in Irvine, CA.