The BI Tools tab could not appear for a number of reasons –

  • Incorrect versions of DLL files. Unfortunately in this case the quickest resolution would be to note the file version of all the in the C:\Program Files (x86)\Common Files\BIComponentsOR C:\Program Files\Common Files\BIComponents directory. Sage Intelligence support desk will send you the correct DLL file version for the installed application.
  • Excel forcefully staying opened during the install process
  • Excel not being launched and configured since install. When more than 1 Excel version is installed, one of the installed Excel versions have not been launched or configured. These block Sage Intelligence Add-Ins from registering themselves due to their dependency on Excel.

  • Ghost instances of Excel in the task manager.

A ghost process is a process which is not terminated when its associated application is closed. This is visible in the Task Manager(right click the task bar and select Start Task Manager).

Where to find AlchemexPolicy.exe and AlchemexWizard.vsto

Resolution 1

Prerequisites-

Ensure file extensions are visible

There should be no ghost processes of Excel in the Task Manager.

Excel must have been previously launched and configured

  1. Navigate to C:\Program Files (x86)\Common Files\BIGeneratorORC:\Program Files\Common Files\BIGeneratoron 32 bit machines.
  2. Run the AlchemexPolicy.exe as administrator

Resolution 2

  1. Launch MSDOS Command Prompt as Administrator
  2. Navigate to C:\Program Files (x86)\Common Files\BIGeneratorORC:\Program Files\Common Files\BIGeneratoron 32 bit machines.
  3. Enter the following command line “AlchemexPolicy.exe –EXCEL” without quotesand hit Enter. This registers the Alchemex application.

Resolution 3

  1. Navigate to C:\Program Files (x86)\Common Files\BIGeneratorORC:\Program Files\Common Files\BIGeneratoron 32 bit machines.
  2. Run the AlchemexWizard.vsto as administrator

Resolution 4

  1. If the above do not resolve the issue then navigate to Control Panel>Programs>Programs and Features.
  2. Repair all excel/office versions installed.
  3. Launch and configure all excel versions.
  4. Close all office applications and ensure no ghost processes are visible in Task Manager.
  5. Locate and select the Sage intelligence application in the list of applications and click Uninstall/Change.
  6. Repair the software installation.

If the Report Designer (Report Designer Add-in) does not display the task pane it could be due to one of the below scenarios-

  • The ERP has been installed as a user with elevated privileges(EG: Administrator) and the ERP is attempting to be opened by another user.
  • Excel forcefully staying opened during the install process.
  • Excel not being launched and configured since install. When more than 1 Excel version is installed, one of the installed Excel versions have not been launched or configured. These block Sage Intelligence Add-Ins from registering themselves due to their dependency on Excel.

Resolution 1

Prerequisites-

Ensure file extensions are visible

There should be no ghost processes of Excel in the Task Manager.

Excel must have been previously launched and configured

  1. Login to windows as the user with the issue.
  2. Open Excel and click on Options>Add-Ins.
  3. If the Report Designer is listed under Inactive Applications, select Disabled Items under Manage and activate the disabled Report Designer. Skip to step 11.

  1. Select Excel Add-ins and click Go…
  1. Click on Browse
  2. Navigate to C:\Program Files (x86)\Common Files\BIExcelFunctions1.1 ORC:\Program Files\Common Files\BIExcelFunctions1.1 on 32 bit machines.
  3. Navigate to the relevant folder depending on your Excel version (32bit folder for 32 bit Excel and 64bit for 64 bit Excel versions 2010 and above).
  4. Select the Sage.BI.ExcelFunctions1.1.xll file and click OK

  1. The Report Designer will show in the next screen(below) as selected. Click OK
  1. The task pane will now be registered.
  2. Click on BI Tools and click Show Task Pane.