Security Considerations

When the data is extracted from your ERP Applicationand put into a cube, then any data in the cube will be visible to that Info Explorer user.

It is advised to use a database user that has Read-Only rights to the database (except where you are using Info-Explorer Writeback to update budget figures). This is configured outside of Info-Explorer.

You can lock Files and Cubes to protect data once it is being extracted. You can also lock the actual query to ensure that users only view the data they are entitled to see.

Example: So if you are concerned about a user seeing GL data in Info Explorer, you need to ensure the user only has access to cubes that don't include GL data and lock the query so that they can't amend the query. Typically, this requires a unique data cube for that user that only shows data you want them to see.

Note: If you were Drilling through the cube into Sage 300 underlying screens, then you would need to log into Sage 300 with an ID and Password and the security settings in Sage 300 would apply any restrictions on what that user could see. only applicable to Sage 300

Clicking Properties on the Home Ribbon will allow you to define and change the existing properties of the cube.

Use the Options > Lock buttons to set passwords on selected functions in Info-Explorer.

Refer to Configure Lock Options in Info-Explorer for details.