This feature is used to import pre-defined database security (.SEC file) into the current database. This feature is only enabled when working with secured databases, otherwise it will be inactive or grayed out.
1. From the PowerOLAP ribbon, go to
Data tab, then in the Import control group select Security
icon or Import
Security command.
The Import Data dialog box is displayed.
.png)
2. Browse for a particular .SEC import file.
3. Enter a valid password.
4. Click OK.
.png)
You will get a message prompt that all security data is imported successfully.
However, if there are errors during the import or there are fact and meta security that failed to import into the database, you will be prompted with an error message.
.png)
Only applicable fact and meta security, as well as users and user groups, contained in the import file will be imported automatically