Blogger profile

Marc Rouhana

Jul 17, 2012 ·

How to hide sensitive SAP information in Query Reports

Winshuttle Query is great for adding security on top of the native SAP security to limit users down to the field level. Security administrators can even configure Query to perform custom security checks, restrict or exclusively allow one or multiple tables within an authorization group. What about when we want users to have access to the data but we need to hide or scramble personally identifiable information such as tax id, bank routing, bank account number or show only the last 4 digits of the Social Security number? Winshuttle Query natively supports Excel formulas and functions in the mapper. This… Read more

Jul 12, 2012 ·

Top 10 performance tweaking tips for SAP reports with Winshuttle Query

How to best optimize your queries for optimal performance improvement.

Jul 9, 2012 ·

How to download SAP structure data with Winshuttle Query

Let me start off by saying that structures in and of themselves do not contain data. By definition, a structure is a skeleton of a table which “forms the basic framework of the axes in a table (rows or columns)”. That still doesn’t change the fact that many of us every day SAP users still need to download the data we see in a transaction code regardless of where it is stored on the backend or how it is derived. Technical users know how to backtrack from the data element, run a trace or read and write code to find… Read more