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
          If ‘Account Total Pending Spend’ >/= Total Accrual
          then ‘Account Total Pending Spend’
          If ‘Account Total Pending Spend’ < Total Accrual
          then ‘Account Total Accrual’

   Tracking code: TC-26816

Dependencies

This update requires the installation of TeamConnect 6.1 and TeamConnect Business Intelligence 6.1.

Replacing ElastiCube Build Files  

1. 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.
2. 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:

1. In Windows Services, stop Sisense.ECMS. 
2.  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.
3.  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:

1. After creating a backup, uninstall the ElastiCube by running the TCBI_Uninstall.bat script from the original installation files.
2. Check the log for any errors.
3. 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.
4. 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:

To remap a field in a report:

1. Open the TeamConnect Business Intelligence dashboard in TeamConnect. Reports that need to be remapped display an error stating that an item cannot be found.
2. Click the Edit Widget icon in the upper right corner of the report. 
3. Delete each field in the report by clicking the Remove the item icon for the individual field. 
4. Re-add each field to the report.
5. Click Apply.