TeamConnect Business Intelligence 6.1.1 Release Notes
Summary
Release Date: 03/01/2019
Installation Instructions can be found at the end of these release notes.
Issue Resolutions
TeamConnect Business Intelligence 6.1.1 resolves the following issues:
- Issue: Administrators were not notified when an ElastiCube build or sync failed. Now, they can configure an email notification with status and logs attached.
Tracking code: TC-24142
To configure the email notifications:- Open the autocube.properties file with a text editor.
- Set the following property values:
- enable.fail.email.notification - Set to YES if you want email notifications for failed builds, set to NO if you do not.
- enable.success.email.notification - Set to YES if you want email notification for successful builds, set to NO if you do not.
- email.recipient - Type the email of the recipient. If you want to send notifications to multiple recipients, separate the values with a comma.
- email.sender - Type a valid email address for the sender.
- email.server - Type the IP address of the email server.
Note: If you do not want any email notifications, leave all of these properties blank.
- Issue: TeamConnect administrators had no visibility into all the customizations that had been added to an instance. Now Mitratech provides a script so that administrators can generate their own data dictionary.
Tracking code: TC-26138
To generate a data dictionary report:- Open the Reports tab in TeamConnect.
- Create a new widget/report and click Select Data.
- Add the following data dictionary fields from Zz Data Dictionary:
- Table Friendly Name In ECube
- Field Friendly Name In ECube
- Field Description
- Field Calculation
- Click Create.
Other information available in the Zz Data Dictionary include:
- Column Name In The Database
- Data Type In The Database
- Table Name In The Database
-
Issue: The following fields have been added to all objects: Workflow Current Action, Workflow Current Approver, Workflow Current Status, Workflow Last Performer, Workflow Multiple Approvers.
Tracking code: TC-25991 -
Issue: Corporate Project and Product/Area are now reportable in relation to Matters.
Tracking code: TC-225861
Dependencies
This update requires the installation of TeamConnect 6.1 and TeamConnect Business Intelligence 6.1.
Installation Instructions
This section contains a quick overview of the upgrade process. Each line links to specific instructions on how to perform the process.
NOTE: Dashboard owners MUST backup their existing dashboards prior to upgrade. Under normal upgrade processes, dashboard templates will persist and not have to be re-imported. The backup ensures that you do not lose your dashboards in the case that we encounter a unique scenario and the dashboards are deleted.
To upgrade TeamConnect Business Intelligence:
- Replace the ElastiCube build files with released version on build server.
- Create a backup of the Existing ElastiCube.
- Upgrade the ElastiCube.
Replacing ElastiCube Build Files
- Create a backup of the existing TeamConnect_BI directory by removing it from this directory, placing a copy in a different location, and changing the name of the copy (for example, TeamConnect_BI_backup). Make a note of the location of the autoCube.proproperties file. You will need the property values in this file.
- Extract the files from the TCBI_Install_Package.zip to the same the location of the original TeamConnect_BI directory.
Creating a Backup of the Existing ElastiCube
To backup your ElastiCube:
- In Windows Services, stop Sisense.ECMS.
- Open the PrismServer\ElasticubeData directory, typically located here:
%ProgramData%\Sisense\PrismServer\ElastiCubeData
Note: If the directory is not in this location, open the Sisense Server Console and click the Server Preferences icon to verify the correct path. - Copy the data to your backup location.
Upgrading the ElastiCube
- After creating a backup, uninstall the ElastiCube by running the TCBI_Uninstall.bat script from the original installation files.
- Check the log for any errors.
- Open the new autoCube.properties file with a text editor. Define the property values with the information from the previous installation, being careful not to erase any new properties.
- Run the updated TCBI_SchemaSync.bat as an administrator and check the log for any errors.