Installing the stand-alone Controller client

You can download the stand-alone Controller client.

Before you begin

The stand-alone Controller client (download link) is not enabled by default. To enable it, follow the instructions:
  1. Find the config.js file in the installation directory. The default directory path is C:\Program Files\ibm\cognos\ccr_64\frontend.
  2. Open the config.js file in a text editor.
  3. The existing customers, make the following change in the config.js file:
    1. In the 'expressJs' parameter, to enable the Remote Client function, change the value of enableClient from false to true.
  4. To change the installation type from ZIP based installation to MSI based installation, change the enablemsi parameter from false to true. By default, the value of enablemsi parameter is false.
  5. The new customer, make the following changes in the config.js file:
    1. In the 'Proxies - target - host' parameter:
      1. Locate the "host": "{hostname}" line.
      2. Change it to "host": "myserver.companyname.com".
    2. In the 'expressJs' parameter:
      1. Locate the "host": "{publicInterface}", //interface used by Controller Web UI service line.
      2. Change it to "host": "myserver.companyname.com", //interface used by Controller Web UI service.
      3. To enable the remote client functions, change the value of "enableclient" from false to true.
    3. In the 'expressJsReact' parameter:
      1. Locate the "host": "localhost", //interface used by Controller Web UI service line.
      2. Change it to "host": "myserver.companyname.com", //interface used by Controller Web UI service.
    4. Verify whether the "host": "myserver.companyname.com" is updated at all the three instances.
  6. Save the config.js file.
  7. Open the Microsoft Windows Service Manager console, find IBM® Controller Web UI, and start the service.
Note: The installation of the standalone Controller client will also install the Excel link.

Procedure

  1. Ensure that your computer meets each of these prerequisites:
    • You uninstalled Controller excel link.
    • You installed Microsoft Excel for Microsoft 365.
    • You installed Microsoft Edge Runtime.
    • You are logged into Microsoft account.
    • You installed Microsoft .Net 4.8
      Note: .NET Framework 4.8 is included by default in Windows 10 Version 1903 and newer. For earlier versions of Windows OS, you must manually install .NET Framework 4.8 from the official Microsoft download page.
  2. In a browser window, log in to Controller Web.
  3. Download the installer:
    1. On the landing page, click the User icon user icon.
    2. From the User list, click Controller Client.
    3. In the Controller Client License Information window, select I agree to proceed.
  4. Choose your installation method and follow the corresponding procedure:
    • Installing the Controller client - MSI based installation
      1. The file CCRRemoteClient64.msi is downloaded to your computer.
      2. Double click the file CCRRemoteClient64.msi.
      3. When prompted for the WSS URL, enter http://your_controller_server/ibmcognos/controllerserver and then click Next.
        Important: Cloud users must use https instead of http.
      4. Select the destination folder, and then click Next.
      5. Select default values in the remaining installation windows, and then click Finish.
      6. Open the IBM Controller application.
      7. Select the database.
      8. Enter your Username and Password, and then click Login.
        Important: It may take a minute or two for the login to finish. Do not click in Controller or navigate to another application during this time.
    • Installing the Controller client - ZIP based installation
      Note: If you are switching from an MSI based installation to the ZIP installation, check the registry for the ADXStartMode entry. If it exists, delete it. For more information, see Uninstalling the stand-alone Controller Client (ZIP installation).
      1. Open the Downloads folder or the directory where the ZIP file was saved.
      2. Unzip the downloaded .zip file to a preferred location on your computer.
        Note: Always unzip the installation file into a newly created, empty folder. If you unzip it into a folder that already contains other files, all contents of that folder may be deleted during the uninstallation process.
      3. Inside the extracted folder, double-click the client.bat file to execute the client setup.
      4. When prompted, for the WSS URL, enter http://your_controller_server/ibmcognos/controllerserver. If you are using the HTTPS protocol, enter https://your_controller_server/ibmcognos/controllerserver and click Enter.
      5. Open the Controller Client.
        Note: Make sure you are logged into Controller Classic before accessing Excel client.
      6. Navigate to the CCRRemoteClient64.zip extracted folder.
      7. Double-click CCR.exe to start the application.
      8. Select the database.
      9. Enter your Username and Password, and then click Login.
        Note: If you are accessing the embedded Excel from the Controller application and the Controller tab is missing, please refer to the instructions provided in Controller Tab Missing Under Excel Ribbon or Error on Opening Embedded Excel Link.
        Important: It may take a minute or two for the login to finish. Do not click in Controller or navigate to another application during this time.

Results

You should now be able to connect to IBM Controller.

Note: If you cannot connect to Controller Client, it may be related to an incorrect registry setting. If you continue to experience an issue with your Controller Client installation, uninstall it completely, and then reinstall it.