In order to work properly with the Dashboard appropriate views have to be generated. These viewing options are presented in T!M in an accessible and easy way. The corresponding sections can be included to the MySQL Client by using copy and paste functionality (Crtl + Enter). Another option would be to download the script and then execute this file via the MySQL Server.

tim_views.sql

CREATE DEFINER=`root`@`localhost` FUNCTION `currentClient`() RETURNS INT(11)
    NO SQL
    DETERMINISTIC
RETURN @currentClient;
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_activity` AS SELECT 
`ni`.`ID_` AS `id`,
`ni`.`NAME_` AS `name`,
`ni`.`client_ID_` AS `clientId`,
`ni`.`CREATION_TIME_` AS `creationTime`,
`ni`.`creationUser_ID_` AS `creationUserId`,
`ni`.`processInstance_ID_` AS `instanceId`,
`ni`.`realStart` AS `start`,
`ni`.`realEnd` AS `end`,
`ni`.`loopCount` AS `loopCount`,
`ni`.`duration` AS `duration`,
`ni`.`escalationTime` AS `escalationTime`,
`ni`.`estimatedEnd` AS `estimatedEnd`,
`ni`.`desiredStart` AS `milestone`,
`ni`.`desiredStartTime` AS `milestoneDate`,
`ni`.`inTime` AS `inTime`,
`ni`.`puffer` AS `timeBuffer`,
`ni`.`calFAZ` AS `calculatedEST`,
`ni`.`calFEZ` AS `calculatedEFT`,
`ni`.`calSAZ` AS `calculatedLST`,
`ni`.`calSEZ` AS `calculatedLFT`,
`ni`.`numFAZ` AS `valueEST`,
`ni`.`numFEZ` AS `valueEFT`,
`ni`.`numSAZ` AS `valueLST`,
`ni`.`numSEZ` AS `valueLFT` ,
`node`.`CLASS_` AS `type`
FROM ((`LOOM_NODEINSTANCE` `ni` JOIN `LOOM_NODE` `node` ON (`ni`.`node_ID_` = `node`.`ID_`))) WHERE (`ni`.`client_ID_` = `currentClient`());
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_definition` AS SELECT 
`LOOM_PROCESSDEFINITION`.`ID_` AS `id`,
`LOOM_PROCESSDEFINITION`.`NAME_` AS `name`,
`LOOM_PROCESSDEFINITION`.`CLIENT_` AS `clientId`,
`LOOM_PROCESSDEFINITION`.`CREATION_TIME_` AS `creationTime`,
`LOOM_PROCESSDEFINITION`.`CREATION_USER_` AS `creationUserId`,
`LOOM_PROCESSDEFINITION`.`DESCRIPTION_` AS `description`,
`LOOM_PROCESSDEFINITION`.`VERSION_` AS `version`,
`LOOM_PROCESSDEFINITION`.`ESCALATIONSTATUS_` AS `escalationStatus`,
`LOOM_PROCESSDEFINITION`.`OWNER_EXPRESSION_` AS `owner`,
`LOOM_PROCESSDEFINITION`.`STARTER_EXPRESSION_` AS `starter`,
`LOOM_PROCESSDEFINITION`.`DEPLOYER_EXPRESSION_` AS `deployer` ,
`LOOM_PROCESSDEFINITION`.`ARCHIV_` AS `archived`
FROM `LOOM_PROCESSDEFINITION` WHERE (`LOOM_PROCESSDEFINITION`.`CLIENT_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_effort` AS SELECT 
`eff`.`ID_` AS `id`,
`eff`.`NAME_` AS `name`,
`eff`.`client_ID_` AS `clientId`,
`eff`.`CREATION_TIME_` AS `creationTime`,
`eff`.`creationUser_ID_` AS `creationUserId`,
`eff`.`CLASS` AS `effortType`,
`eff`.`effort` AS `value`,
`eff`.`description` AS `description`,
`eff`.`costCenter_ID_` AS `costCenterId`,
`ti`.`PROCINST_` AS `instanceId`,
`eff`.`parentFolder_ID_` AS `parentFolderId`
FROM (`LOOM_EFFORT` `eff` JOIN `LOOM_TASKINSTANCE` `ti` ON((`eff`.`parentFolder_ID_` = `ti`.`PARENT_FOLDER_`)))
WHERE (`eff`.`client_ID_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_identity` AS SELECT 
`LOOM_IDENTITY`.`ID_` AS `id`,
`LOOM_IDENTITY`.`NAME_` AS `name`,
concat(`LOOM_IDENTITY`.`namelast`,' ',`LOOM_IDENTITY`.`namefirst`,' (',`LOOM_IDENTITY`.`NAME_`,')') AS `displayName`,
`LOOM_IDENTITY`.`client_ID_` AS `clientId`,
`LOOM_IDENTITY`.`CREATION_TIME_` AS `creationTime`,
`LOOM_IDENTITY`.`creationUser_ID_` AS `creationUserId`,
`LOOM_IDENTITY`.`CLASS` AS `identityType`,
`LOOM_IDENTITY`.`email` AS `email`,
`LOOM_IDENTITY`.`namefirst` AS `firstname`,
`LOOM_IDENTITY`.`namelast` AS `lastname` ,
`LOOM_IDENTITY`.`ARCHIV_` AS `archived` ,
`LOOM_IDENTITY`.`blocked` AS `blocked` ,
`LOOM_IDENTITY`.`parent_ID_` AS `parentID`
FROM `LOOM_IDENTITY` WHERE (`LOOM_IDENTITY`.`client_ID_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_instance` AS SELECT 
`pi`.`ID_` AS `id`,
`pi`.`NAME_` AS `name`,
`pd`.`NAME_` AS `definitionName`,
`pi`.`CLIENT_` AS `clientId`,
`pi`.`CREATION_TIME_` AS `creationTime`,
`pi`.`key_` AS `key`,
`pi`.`CREATION_USER_` AS `creationUserId`,
`pi`.`PROCESSDEFINITION_` AS `definitionId`,
`pi`.`DESCRIPTION_` AS `instanceDescription`,
`pi`.`CREATION_GROUP_` AS `creationGroup`,
`pi`.`END_` AS `end`,
`pi`.`ARCHIV_` AS `archiv`,
`pi`.`ARCHIVATIONUSER_ID_` AS `archivationUserId`,
`pi`.`ROOTTOKEN_` AS `rootToken`,
`pi`.`SUPERPROCESSTOKEN_` AS `parentProcessToken`,
`pi`.`NEXT_ESCALATIONTIME_` AS `nextEscalationTime`,
`pi`.`processVariableIndex_ID_` AS `processVariableIndexId`,
`pi`.`inTime` AS `inTime`,
`pvi`.`field1` AS `index1`,
`pvi`.`value1` AS `value1`,
`pvi`.`field2` AS `index2`,
`pvi`.`value2` AS `value2`,
`pvi`.`field3` AS `index3`,
`pvi`.`value3` AS `value3`,
`pvi`.`field4` AS `index4`,
`pvi`.`value4` AS `value4`,
`pvi`.`field5` AS `index5`,
`pvi`.`value5` AS `value5`,
`pvi`.`field6` AS `index6`,
`pvi`.`value6` AS `value6`,
`pvi`.`field7` AS `index7`,
`pvi`.`value7` AS `value7`,
`pvi`.`field8` AS `index8`,
`pvi`.`value8` AS `value8`,
`pvi`.`field9` AS `index9`,
`pvi`.`value9` AS `value9`,
`pvi`.`field10` AS `index10`,
`pvi`.`value10` AS `value10` 
FROM (((`LOOM_PROCESSINSTANCE` `pi` JOIN `LOOM_PROCESSVARIABLEINDEX` `pvi` ON (`pi`.`processVariableIndex_ID_` = `pvi`.`ID_`))) JOIN `LOOM_PROCESSDEFINITION` `pd` ON((`pi`.`PROCESSDEFINITION_` = `pd`.`ID_`))) 
WHERE (`pi`.`CLIENT_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_swimlane` AS SELECT 
`LOOM_SWIMLANEINSTANCE`.`ID_` AS `id`,
`LOOM_SWIMLANEINSTANCE`.`NAME_` AS `name`,
`LOOM_SWIMLANEINSTANCE`.`CLIENT_` AS `clientId`,
`LOOM_SWIMLANEINSTANCE`.`PROCINST_` AS `instanceId`,
`LOOM_SWIMLANEINSTANCE`.`ACTOR_` AS `actor`,
`LOOM_SWIMLANEINSTANCE`.`POOLEDACTOR_` AS `pooledActor` 
FROM `LOOM_SWIMLANEINSTANCE` WHERE (`LOOM_SWIMLANEINSTANCE`.`CLIENT_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_task` AS SELECT 
`ti`.`ID_` AS `id`,
`ti`.`NAME_` AS `name`,
`ti`.`CLIENT_` AS `clientId`,
`ti`.`CREATION_TIME_` AS `creationTime`,
`ti`.`CREATION_USER_` AS `creationUserId`,
`ti`.`PROCINST_` AS `instanceId`,
`ti`.`DESCRIPTION_` AS `description`,
`ti`.`START_` AS `start`,
`ti`.`END_` AS `end`,
`ti`.`ISOPEN_` AS `isOpen`,
`ti`.`SWIMLANINSTANCE_` AS `swimlaneId`,
`ti`.`ACTOR_` AS `actor`,
`ti`.`POOLEDACTOR_` AS `pooledActor`,
`ti`.`NODEINSTANCE_` AS `activity`,
`ta`.`ISADHOC_` AS `isAdhoc`,
`ti`.`PARENT_FOLDER_` AS `parentFolderId`,
`ti`.`archiv_` AS `archiv`
FROM (`LOOM_TASKINSTANCE` `ti` JOIN `LOOM_TASK` `ta` ON((`ti`.`TASK_` = `ta`.`ID_`))) WHERE (`ti`.`CLIENT_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_token` AS SELECT 
`tok`.`ID_` AS `id`,
`tok`.`NAME_` AS `name`,
`pi`.`CLIENT_` AS `clientId`,
`tok`.`NODEINSTANCE_` AS `nodeInstance`,
`tok`.`PROCESSINSTANCE_` AS `instanceId`,
`tok`.`PARENT_` AS `parent` 
FROM (`LOOM_TOKEN` `tok` JOIN `LOOM_PROCESSINSTANCE` `pi` ON((`tok`.`PROCESSINSTANCE_` = `pi`.`ID_`))) WHERE (`pi`.`CLIENT_` = `currentClient`());
 
 
 
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_variable` AS SELECT 
`vi`.`ID_` AS `id`,
`vi`.`NAME_` AS `name`,
`pi`.`CLIENT_` AS `clientId`,
`vi`.`PROCESSINSTANCE_` AS `instanceId`,
`vi`.`Stringvalue_` AS `stringvalue`,
`vi`.`label_` AS `label`
FROM (`LOOM_VARIABLEINSTANCE` `vi` JOIN `LOOM_PROCESSINSTANCE` `pi` ON((`vi`.`PROCESSINSTANCE_` = `pi`.`ID_`))) WHERE (`pi`.`CLIENT_` = `currentClient`());
 
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_role` AS SELECT
`LOOM_IDENTITY_ID_` AS `identityId`,
`ROLE_ID_` AS `roleId`
FROM `MN_IDENTITY_ROLE`;

As soon these views have been created they can be used by the described T!M table structure and analyzed by T!M Dashboard.