Enhancements & Improvements

This section contains a list of feature enhancements and improvements that were released with TCBI 6.2.2.

Enhancement: There is now a toggle that controls whether security is enabled in the TCBI data cube. By default, matter level security is turned OFF. Mitratech Services can now turn matter level security ON / OFF via an SQL script. 
Impact:  Out of the box, Matter level security defaults to OFF upon upgrade to 6.2.2. This means that anyone viewing a Dashboard will be able to see any Matter listed regardless of their TeamConnect security limitations. It is turned OFF because removing the security results in up to a 2x performance improvement. Best practice is to turn off matter security for analytical reports because it could cause perceived inaccuracies if security restrictions limit a user from seeing all the data and therefore, the complete picture. It is possible for a Report Designer to manage some security concerns when building reports. NOTE:  Mitratech strongly suggests toggling security to ON if you are upgrading to 6.2.2 from a previous version.  This will ensure any existing reports continue to be secure.
Tracking Code: TC-31505
Additional Details: Details for how to run the script that controls matter security can be found in the 6.2.2 Integration or Upgrade guides in the Client Success Center.

Enhancement: Enable or disable Drill to Anywhere setting. When enabled, anyone can drill into any field. When disabled, the drill down option is turned off. Custom hierarchies can be built that allow drill down to only certain fields. 
Impact:  The “drill to anywhere” feature can allow users to gain access to sensitive information once security is disabled, as described above.  Therefore, disabling this feature and instead designing custom drill hierarchies is highly recommended for customers who have security disabled.  For more information, refer to this article on creating custom hierarchies.
Tracking Code: TC-31625
Additional Details: This setting is turned OFF by default and will need to be enabled/disabled by a Services or Hosting team member. Custom Hierarchies will also require support from Services and Hosting. Instructions for using this feature and guidance on methods to manage security on dashboards can be found in the Tutorial for Report Designers.

Enhancement: TeamConnect Administrators can now control what fields are selected to sync to the eCube and made reportable through Sisense based dashboards.
Impact:  By controlling which fields do or do not appear in the TCBI ecube, clients can optimize both the field selection process (by only including important fields, thus reducing clutter) and can improve performance of the data synchronization process (for example, eliminating unneeded fields - especially large comment fields - will reduce the load each time the data is synchronized).
Tracking Code: TC-31454
Additional Details: In TeamConnect setup, there was a single setting to determine if a field was reportable. It is now split into two selections - one to determine what goes into the data warehouse for operational reports through native reporting and Business Objects and a second to determine what goes into the eCube for Sisense analytical dashboard reporting. Removing fields like Comments - that are not typically needed for analytical reporting - should optimize performance of the eCube. More details can be found in the 6.2.2 Integration or Upgrade guides in the Client Success Center.

Known Issues 

The following known issues exist in TeamConnect Business Intelligence 6.2.2.

Issue: Inconsistent behavior in click-thru on Chrome and Firefox
Impact:  There are two issues:
1. The click-thru link in a report will take you to the object - a matter, invoice, contact, etc - but when you click the back button, it will not take you back to the report. In Chrome, you must click the back button twice before it takes you back to the report. In Firefox, it never goes back to the report. You have to go to the Reports tab to get back to your report.
2. If a widget is set up with a click-thru link(s) and you edit one of those scripts, it is not getting saved on Firefox and Chrome. The workaround is to edit the script and refresh the browser without clicking the Apply button.
Tracking Code: TC-32573

Issue: TCBI plugins installer fails to complete when the Sisense administrative password contains ‘+’ and ‘&’ characters
Impact: A Sisense administrative password cannot contain either a ‘+’ or ‘&’ included or the installer will fail. In this scenario, the administrative password needs to be changed with those characters removed and the installer run again.
Tracking Code: TC-32663 

Known Issues from previous versions

The following known issues existed in TeamConnect 6.2.1 and 6.2.

• Issue: TeamConnect Business Intelligence session may time out when working in the Reports tab.
  Tracking code: TC-21444
• Issue: Due to caching, the "You might be interested in" fields may show older information from the ElasticCube although the actual object has been renamed. removed, or translated from the ElasticCube .
  Tracking code: TC-28568

• Issue: TeamConnect Business Intelligence does not support table names exceeding 149 characters, with non-alphanumeric characters are considered 4 characters. Table names are concatenated when they are multi-level so the table name may be smaller than 149, but the concatenation will drive it to a larger size.
  Tracking code: TC-27773
• Issue: TeamConnect incorrectly times out when a report designer is working on widgets and reports.
  Tracking code: TC-23291
• Issue: If a user restores a dashboard that has not been shared and then creates a new widget under the dashboard, the reporting structure does not display correctly.
  Tracking code: TC-27113
• Issue: The values for Ratio Function and Total Average for matters is not correct due to a limitation in Sisense.  The ratio is calculated by counting the number of closed matters divided by the number of opened. Sisense counts the number of opened and closed separately but it won't use the result of that calculation for another calculation. Thus, ratio is not doable using the standard, out of-the-box function. The average function behaves inconsistently, in most cases; it includes non-0 values but on certain cases, it excludes non-0 values. For example, if the input are "0,0,2,4,0,0", in most cases the average is (2+4)/6 = 1; however, sometimes the average is (2+4)/2 = 3
  Tracking code: TC-30376, Sisense 111406

• Issue: Project relation is not reportable at this time. If enabled, the related objects will not have security applied, and it will not join to the actual object in the eCube. TeamConnect Business Intellegence can only display the related project number, project name and relation type regardless of the user's security.
  Tracking code: TC-29792

• Issue: The Export to Excel function for pivot tables is currently not working.  Use Export to CSV instead.
  Tracking code: TC-30675

• Issue: Dynamically changing a report title with the results of a filter is not possible. For example, if you want the title of a report to dynamically insert an "As of" date, this title change is not possible.
  Tracking code: TC-28829

The following known issues existed in TeamConnect 6.1.