How to Configure External Access to the OLAP Cubes

To make it possible for the users to read reporting data from the OLAP cube it is necessary to set permissions for them. Setting user permissions for the OLAP cubes is responsibility of the CUSTOMER. See the linked document for the best practices when setting permissions for the cubes.

Microsoft Office Excel 365

  1. Open Microsoft Office Excel 365 (referred to as Excel).

  2. In the Data tab, select From Database > From Analysis Services.
    images/download/attachments/160480431/from_analysis_services.png

  3. In the Data Connection Wizard, enter the database Server name and select Use Windows Authentication
    or enter a specific User Name and Password

  4. Click Next button.

    images/download/attachments/160480431/data_connection_wizard.png



  5. Choose an OLAP cube that you want to display and click Next.

    images/download/attachments/160480431/data_connection_wizard_select_db_and_table.png



  6. Click Finish button.

    images/download/attachments/160480431/data_connection_wizard_save_data_and_finish.png



  7. Select a display type: pivot table, chart, or both; then click OK
    images/download/attachments/160480431/import_data.png

  8. After successful connection, you will see a window exactly as shown in picture below.

    images/download/attachments/160480431/pivot_table.png



  9. Select dimensions or measures as described above.
    Working with a YSoft SafeQ pivot table is the same as with any other pivot table.
    images/download/attachments/160480431/pivot_table_example.png