We are trying to hide data like federal ID no's and social security numbers from within a table and not see in JET. However, we are not accomplishing what we have set out to do. does anyone know how to hide data in a specific field in JET through NAV or from within JET itself for security purposes? Has anyone accomplished this?
Thanks,
DGreene
Debra, in Jet Enterprise you do have some standard SQL tools available to you for hiding data in the Data Warehouse
If you want to hide data in the cubes you can do that with OLAP security
https://jetsupport.jetreports.com/hc/en-us/articles/219400947-Configuring-OLAP-Security
Do either of these options sound like what you're trying to accomplish?
You can email me directly at jae@onyxreporting.com
