TRIRIGA

 View Only
  • 1.  TRIRIGA Data Dictionary

    Posted Mon March 27, 2023 09:44 AM

    We're being asked to provide a data dictionary for TRIRIGA. Is there one published or a way to obtain one?  Thanks!



    ------------------------------
    Brad Pade
    ------------------------------


  • 2.  RE: TRIRIGA Data Dictionary

    Posted Tue March 28, 2023 09:00 AM
    Edited by Michael Pemberton Tue March 28, 2023 09:04 AM

    Brad,

    This question is difficult to answer because TRIRIGA allows you to build tables and relationships within the application. Depending on what format is acceptable, the answer changes. The system is unique in that there a few 'master' tables that handle most relationships between tables (tables start with IBS*). 

    1. If you are seeking a PDF of the Data Dictionary, I am unaware of this existing but if it does exist IBM will have to provide it per version of the system you are running and any customizations your system has will not be reflected. This file would be a very large file and not easily usable.
    2. If an online Data Dictionary would work then you may be able to train users to use the Data Modeler built into the TRIRIGA application. This is used by developers and encompasses everything you will need. 

    At this time I would not go into more detail until I understood the use of the data dictionary for your purposes. If you can share more details I or someone else may be able to provide some more insight into how we would approach this.

    Mike



    ------------------------------
    Michael Pemberton
    ------------------------------



  • 3.  RE: TRIRIGA Data Dictionary

    Posted Tue March 28, 2023 02:38 PM

    Hello Brad,

    I wish you luck with finding any documentation of the Tririga table and field structure.  I have been the administrator of our Tririga system since 2003 and we upgraded from the 7.x application to the Tririga 10.x application in 2016. 

    I have been trying to find documentation to utilize external reporting tools such as Microsoft Power BI for years now.  Our IBM Business partner has informed me that no such documentation exists for this Tririga 10.x product and the best option is to utilize the internal queries and BIRT reporting tool. 

     

    The key area of difficulty is the use of the intermediate IBS table for all table relationship joins.  The IBS_SPEC_ASSIGMENTS table alone has millions of records in it so linking to these tables with an external reporting tool is not viable.   Without these tables, joining tables can be onerous as the tables cannot be accurately joined together directly.  I believe the SPEC_ID field is the primary key that should be utilized to join the "T" tables, but the intermediate IBS tables need to be utilized.

     

    While the internal queries can be created and exported as SQL, the exported SQL can be difficult to decipher without a good knowledge of SQL.

     

    For example, the following is an export of the SQL for retrieving some Work Request data:

     

    SELECT T1.triIdTX AS T1_1289, T1.triRevisionNU AS T1_1375, T1.triStatusCL AS T1_1316, T1.triStatusCLObjId AS T1_1316_OBJID, T1.triCreatedDateTimeSY AS T1_1413, T1.triModifiedSY AS T1_1304, T2.triDescriptionTX AS T2_1009, T1.triRequestClassCL AS T1_1295, T1.triRequestClassCLObjId AS T1_1295_OBJID, T1.triDescriptionTX AS T1_1300, T1.triRequestedByTX AS T1_1349, T1.triRequestedByTXObjId AS T1_1349_OBJID, T1.triRequestedForTX AS T1_1352, T1.triRequestedForTXObjId AS T1_1352_OBJID, T1.triLocationRequested AS T1_1290, T1.triLocationRequestedObjId AS T1_1290_OBJID, T1.triBuildingTX AS T1_1406, T1.triBuildingTXObjId AS T1_1406_OBJID, T1.triFloorTX AS T1_1405, T1.triFloorTXObjId AS T1_1405_OBJID, T1.triSpaceTX AS T1_1408, T1.triSpaceTXObjId AS T1_1408_OBJID, T1.SYS_TYPE1 AS T1_SYS_TYPE1, T1.SYS_GUIID AS T1_SYS_GUIID, T2.SPEC_ID AS T2_SPEC_ID, T2.SYS_TYPE1 AS T2_SYS_TYPE1, T1.SPEC_ID AS T1_SPEC_ID FROM T_TRISERVICEREQUEST T1 LEFT OUTER JOIN IBS_SPEC_ASSIGNMENTS T3 ON T1.SPEC_ID = T3.SPEC_ID AND T3.ASS_SPEC_CLASS_TYPE = 25 AND T3.ASS_SPEC_TEMPLATE_ID = 10002030 LEFT OUTER JOIN T_TRIREQUESTCLASS T2 ON T3.ASS_SPEC_ID = T2.SPEC_ID AND T2.SYS_OBJECTID > 0 WHERE T1.SYS_PROJECTID = 1 AND T1.SYS_OBJECTID > 0 ORDER BY T1.triCreatedDateTimeSY DESC

     

     

    Thanks,

    John

     

    John Marshall

    Senior Information Technologist

    University of Rhode Island; Facilities Operations

    Email: johnmarshall@uri.edu

     

     

     






  • 4.  RE: TRIRIGA Data Dictionary

    Posted Tue March 28, 2023 02:38 PM

    I was looking for something similar a while back and found this: 

    https://www.ibm.com/mysupport/s/question/0D50z000060eYXaCAM/tririga-data-dictionary-calculations?language=en_US 

    The post is from 2014, so it might be a bit outdated. I'm by no means an expert, but the two SQLs provided were helpful for what I was looking to accomplish. 

    Hope this helps. 

    -Chris 



    ------------------------------
    Chris Bombeck
    ------------------------------