User Guides

Report Designer Tutorial

Report Viewer Tutorial

eCube Data Dictionary for TeamConnect Enterprise

eCube Data Dictionary for TeamConnect Essentials

Enhancement and Improvements

Enhancement: [TCBI eCube updates] Add invoice line item adjustment calculated total
Impact: LNI$_ADJ$_CALC_TOTAL column is added to the SI$_LNI$_ADJUSTMENTS table that stores the data of the difference between the total before the adjustment and the total after the adjustment. 
Tracking Code: TC-35454

Enhancement: [TCBI ecube updates] Add in timekeeper PRIMARY KEY field
Impact: LNI$_TMK$_HOME_OFFICE_PROFILE column is added to the SI$_LNI$_TMK$_CONTACT table that stores the information about the Invoice Line Item Timekeeper Home Office Profile. The value will be stored in the format: full_name (company_name)
Tracking Code: TC-33840, TC-36528

Enhancement: [TCBI] Include isLeaf field for end level categories in the eCube
Impact: New field is added to the following object category tables and this new field (XXXX_CATEGORY_IS_LEAF) would help to identify whether the category is the lowest level category and there is no other sub category under which it is selected(or checked).
New field added for the following objects: 

• Contact
• Project (All custom objects will have this new field)
• Involved
• Invoice

Tracking Code: TC-33912

Enhancement: [TCBI eCube updates] Add Currency and Converted Rate fields for Contacts Rate tables
Impact: New columns CONT_CURRENCY_CODE and CONT_CONVERTED_RATE are added to SI$_CONTACT_RATE_HISTORY table to store the data of currency code and current converted rate for the contact.
Tracking Code: TC-35147

Enhancement:[TCBI eCube updates] Add recent progress note information to the eCube
Impact: New columns are added to the objects to store the data of recent progress information in eCube.

For Enterprise: XXXX_RECENT_STATUS_NOTES, XXXX_RECENT_STATUS_DATE
For Essentials: XXXX_RECENT_PROGRESS_NOTES, XXXX_RECENT_PROGRESS_DATE 

Tracking Code: TC-34400

Enhancement: [TCBI ecube updates] Ability to translate CHECKED/UNCHECKED values into "yes/no" or "true/false" for report displays
Impact: By default, the data value stored for Checkbox fields in eCube is either CHECKED or UNCHECKED. Now, users (Admin) have the ability to customize the data value stored for Checkbox fields in eCube to Yes/No or True/False by editing the script and run the schemasync.
Script location: User can find the script file named "505_CheckBoxDisplay.sql" in the below folder path:
TeamConnect_BI directory > scripts > mssql > install > Customization (or)
TeamConnect_BI directory > scripts > oracle > install > Customization

Tracking Code: TC-35156

Enhancement: [TCBI eCube updates] Add supervisor information to the eCube
Impact: New column CONT_SUPERVISOR is added to the SI$_CONTACT table in the database to fetch the workload data of direct reportees to the manager.
Tracking Code: TC-34381

Enhancement: [TCBI ecube updates] Add Invoice Vendor Currency
Impact: INVC_VEN$_CURRENCY_CODE, INVC_VEN$_CURRENCY_NAME and INVC_VEN$_CURRENCY_SYMBOL are the new columns added to the SI$_INVC_VEN$_CONTACT table in database to help the report designer in building the spend report from the invoice table.
Tracking Code: TC-35456

Enhancement: [TCBI] Add Contact ID for Main Assignee to the default eCube
Impact: Column ContactID is added on the following tables:

For Enterprise:
XXXX_ASSIGNEE_USER_ID$$ and XXXX_ASSIGNEE_CONTACT_ID$$ are the new columns added to SI$_PROJECT_XXXX_ASSIGNEES table.

For Essentials:
XXXX_MAIN_ASSIGNEE_USER_ID$$ and XXXX_MAIN_ASSIGNEE_CONT_ID$$ are the new columns added to SI$_PROJECT_XXXX table.

Tracking Code: TC-34218

Enhancement: [TCBI eCube updates] Add Task and Appointment objects to the eCube
Impact: 

• Tasks and Appointments objects are now reportable in the eCube. Based on START_ON, DUE_ON, COMPLETED_ON columns, the data for these objects is limited to:

  • Include next 90 days of appts/tasks (regardless of status)
  • Include past 90 days of appts/tasks (regardless of status)
  • Include all overdue tasks (not marked complete)

• To make these system objects (Appointment and Task) available for reporting.
  Navigate to Setup Menu > Object definition > General to check/uncheck the Remove from Reporting checkbox for the Appointment and Task system objects.

Tracking Code: TC-34924, TC-35148, TC-35149

Enhancement: [TCBI eCube updates] Add a calculated Task "Timeliness" field to the eCube
Impact: New column TASK_TIMELINESS is added to the SI$_TASK table to provide the Task Timeliness Status:Pending,on time,early,late,overdue in report.
Tracking Code: TC-35154

Enhancement: [TCBI ecube updates] Update the table name to be dynamic based on TeamConnect object name
Impact: From CSM 6.2.4, Vendor is now called Office. The table names in the eCube should be dynamic based on TC object name (For example, it could be either Invoice Office Contact or Invoice Vendor Contact)
Tracking Code: TC-35499

Enhancement: [TCBI] Expand home page portal pane capability to include dashboards
Impact: To enhance the portal pane capability to embed the TCBI dashboards and the ability to customize the portal pane dimensions and also choose the shared dashboard to embed on the home page. For more information, refer to Embed dashboard on portal pane.

Tracking Code: TC-34370

Enhancement: [TCBI] Display the selected dashboard or widget in the specified record
Impact:

• To embed the TCBI dashboards with the last refresh date displayed in the existing tab or new tab within the record.
• Embedded dashboard or widget should automatically apply a filter for that record primary key. 
• Applying multiple primary key filters when embedding a dashboard

For more information, refer to Embed the dashboard/widgets at record level.

Tracking Code: TC-34372, TC-36522

Fixed Bugs

Issue: Scheduled report ignores the time zone setup, and sends based on server time zone. 
Impact: User has the ability to configure the scheduler by defining the specific time zones to share the reports. Scheduler ignores the time zone defined and sends the report based on the server time zone.
Tracking Code: TC-33847

Known Issues

The following issue exists in TeamConnect Business Intelligence 6.3

Issue: Editing the embedded dashboard inside a record displays error message
Description: Do not include any editable fields in the block along with the embedded report as it throws an error message when we try to save the page after modifying the values.
Tracking Code: TC-36578

Issue: Data Security table is not synchronizing
Description:When you modify the TCBI Security value in TeamConnect. After running the schemasync and syncUsersAndGroups, If a user having report rights is unable to create/edit the dashboard then check the data security table in the sisense standalone for the eCube. 
If the user details with reporting rights in teamconnect are not reflected in the data security table then refer to the below workaround for solution.
Workaround: Delete the entire Data Security table in sisense standalone for the eCube and then do the syncUsersAndGroups.
Tracking Code: TC-36585

Issue:TeamConnect Business Intelligence session may time out when working in the Reports tab.
Tracking Code: TC-36663

Issue: Changing the Contact Name is not reflecting in sisense automatically
Description: All other details like User name, Email etc are updating to sisense standalone server Automatically except Contact Name. 
Workaround: User has to perform a syncUsersAndGroups to get it updated in sisense standalone.
Tracking Code: TC-36575

Issue:  When multiple pivot tables are added to single dashboard and pivot tables consist of 5 or more columns, the resizing of the columns may not persist on the screen or when a scheduled report is sent by email.
Additional Information: If this issue is identified, a patch is available to fix it. For more assistance, please get in touch with customer support.
Tracking Code: TC-45624

Known Issues from Previous Versions

The following known issues existed in TeamConnect Business Intelligence 6.2.4 and 6.2.2:

Issue: Legal - Uncheck Remove from reporting for Involved party object
Impact: Remove from Reporting (Business Intelligence) option must be unchecked for Involved party object and this object should be included in eCube by default for Legal.
Tracking code: TC-33780

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

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 in 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
Workaround: The formula for calculating averages of all matters that includes null values is AVG([ID],if(isnull([Total Cost]),0,[Total Cost]))
Tracking code: TC-30376, Sisense 111406, TC-31925

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 Intelligence can only display the related project number, project name and relation type regardless of the user's security.
Tracking code: TC-29792

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