Permissions Issues with Data Cube File

This article contains the following topics: 

• Issue description
• Solution 1
• Other causes
• Solution 2

Problem

• Access and Configuration Issues: Users may encounter problems accessing a data cube file due to permission settings or file configuration.

Solution 1

1. Confirm Permissions:

   • Ensure that user permissions are appropriately set to access the data cube in your EBM website.

2. Troubleshooting Steps:

   • Step 1: Login to the platform.

   • Step 2: Download a fresh copy of the data cube.

   • Step 3: Verify if users can access and download the cube without any issues.

If you determine your user can access a fresh cube and can login without issue, then move on to the next section. 

Identified Issues

• External Connections and Links:

  • Your file may contain numerous external connections and links, which could cause issues such as file degradation and permission inaccessibility during usage.

  • Queries present in the file might not be derived from EBM and could lead to inaccessible data.
    

• Duplicate Connections:

  • Check for duplicated connections under the Data tab, which should be removed to prevent potential conflicts.
    

• Inaccessible External Workbook:

  • External links to locally stored workbooks is not best practice, as it immediately introduces permission variables that can create headaches. EBM is unable to troubleshoot files like this, as we won’t have access to the data. Doublecheck that everyone you intend has access to any external links, queries, connections, or workbooks. If they do not, the file will not work. External links may also be hidden at first glance, so double check hidden tabs in the file. It is recommended to remove links like this to avoid complications.
    

Solution 2

1. File Sanitization:

   • Collaborate with your internal team or EBM to sanitize the file, removing unnecessary connections, queries, and inaccessible links.

   • Sanitizing the file ensures it can be used as intended and accessed by all authorized users.

   • Refer to best practices article here for more. 

2. Removing Duplicate Connections and External Links:

   • Remove duplicate connections and external links that hinder the usability of the file.

Additional Assistance

• If further assistance is required or if there are any other questions, feel free to reach out for support and clarification.