3405901 - One option only is available under "Open Workbook" selection or in the "Select Data Source" prompt in Analysis for Office

Whenever an user is trying to open a workbook from another platform under path File -> Analysis -> Open Workbook, just one option is available (i.e.: Open a workbook from the SAP Business Warehouse Platform) instead of all options to open from BIP and SAC as well.

When right clicking in the "Select Data Source" screen -> Create Connection, there is just one option available instead of all of them.

Example for "Open Workbook":

Example for "Select Data Source" when creating a new connection:

• SAP Analysis for Microsoft Office

For option "Open Workbook":

1. Open Analysis for Office
2. Go to path File -> Analysis -> Open Workbook
3. Just one option is available for the user

For the "Select Data Source" prompt:

1. Open Analysis for Office
2. Go to path Analysis -> Insert Data Source -> Select Data Source for Analysis...
3. Right click in the prompt screen
4. Just one option is available for the user

The system is working as expected, as just one platform has been selected.

1. Open Analysis for Office;
2. Go to path File -> Analysis -> Customize Analysis -> Click on "Options";
3. Click on tab "Platform";
4. See if option "Preferred Platform" is set as Selectable;
   In case it has any other option selected, just one alternative will be available at step 2.

Example:

• 2218283 - How to remove the dialog "Logon to SAP BusinessObjects BI Platform" when inserting a data source

Open Workbook, Analysis, Office, Preferred Platform, Selectable, BW, BIP, SAC, Business Intelligence Platform, Business Warehouse, SAP Analytics Cloud, Select Data Source, BO, login, screen, dialog, BI, skip, insert, BusinessObjects, BOE, enterprise, logon, blank, nothing, not available, window, dialogue , KBA , BI-RA-AO-XLA , Excel Addin , How To