Jul 17, 2012 · Marc Rouhana
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 · Marc Rouhana
How to best optimize your queries for optimal performance improvement.
Jul 9, 2012 · Marc Rouhana
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