TeamConnect Business Intelligence 6.1.2 Release Notes
Summary
Release Date: 03/29/2019
Installation Instructions can be found at the end of these release notes.
Issue Resolutions
TeamConnect Business Intelligence 6.1.2 resolves the following issues:
- Issue: The query for Account Spend was causing performance issues for large databases. To fix this issue, Spend has been converted to M-View and broken into subqueries.
Tracking code: TC-23295
- Issue: Account Spend for invoices with a status other than Posted was not displayed accurately.
Tracking code: TC-23586
- Issue: The log mislabeled the Elasticube size as MB instead of bytes.
Tracking code: TC-27049
- Issue: A new calculated field for Account Total Calculated Accrual has been added to help track reversals if TeamConnect is used to track reversals.
If reversal = full/none
If ‘Account Total Pending Spend’ > 0
then ‘Account Total Pending Spend’
If ‘Account Total Pending Spend’ = 0
then ‘Account Total Accrual’If reversal = partial
Tracking code: TC-26816
If ‘Account Total Pending Spend’ >/= Total Accrual
then ‘Account Total Pending Spend’
If ‘Account Total Pending Spend’ < Total Accrual
then ‘Account Total Accrual’
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.properties 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
New parameters have been added to the autoCube.properties file. The older version of this file cannot be used, or else null pointer issues can occur due to missing properties.
To update the autoCube.properties files:
- 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.
Remapping Fields
The following fields were renamed and must be remapped by a report designer:
Old Table | Old Field | New Table | New Field |
---|---|---|---|
Account Budget And Spend | Startdate | Account Budget And Spend | Account Period Start On |
Account Budget And Spend | Spend | Account Budget And Spend | Account Total Spend |
Account Budget And Spend | Account Fiscal Start Month | Account Budget And Spend | Account Fiscal Month |
Account Budget And Spend | Account Fiscal Year | Account Budget And Spend | Account Fiscal Year |
Account Budget And Spend | Account Month Num | Account Budget And Spend | Account Fiscal Month |
Account Budget And Spend | Account Total Accrual | Account Budget And Spend | Account Total Accrual |
Account Budget And Spend | Account Total Allocated | Account Budget And Spend | Account Total Budget Allocated |
Account Budget And Spend | Account Total Budget Available | Account Budget And Spend | Account Total Budget Remaining |
Account Budget And Spend | Budget End Yearmonth | Account Budget And Spend | Account Period End On |
Account Budget And Spend | Budget Start Yearmonth | Account Budget And Spend | Account Period Start On |
Account Month Number | Account Month Num Fiscal Month | Account Budget And Spend | Account Fiscal Month |
Account Month Number | Account Month Num Start Year | Account Budget And Spend | Account Fiscal Year |
Account Month Number | Spend | Account Budget And Spend | Account Total Spend |
Account Budget And Spend | Account Created On | Account | Account Created On |
Account Budget And Spend | Account Created On Behalf Of | Account | Account Created On Behalf Of |
Account Budget And Spend | Account Modified By | Account | Account Modified By |
Account Budget And Spend | Account Modified On | Account | Account Modified On |
Account Budget And Spend | Account Name | Account | Account Name |
To remap a field in a report:
- Open the TeamConnect Business Intelligence dashboard in TeamConnect. Reports that need to be remapped display an error stating that an item cannot be found.
- Click the Edit Widget icon in the upper right corner of the report.
- Delete each field in the report by clicking the Remove the item icon for the individual field.
- Re-add each field to the report.
- Click Apply.