Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.


Script to get the Frequency Rates Module View

This query is to pull out data as how it is displayed in the Frequency Rates module

 dou.OrgUnitName as [Business Unit]
 ,dent.EntityName as [Project]
 ,det.EntityTypeName as [Entity]
 ,dehw.Month as [Month] 
 ,dehw.Year as [Year] 
 ,dehw.Hours as [Hours]
 ,dehw.NumberOfWorkers as [Number of Workers]
 ,dht.HoursTypeName as [Classification]

from DimEntityHoursWorked dehw 
left join DimOrgUnit dou on dou.DimOrgUnitId = dehw.DimOrgUnitId
left join DimEntity dent on dent.DimEntityId = dehw.DimEntityId
left join DimHoursType dht on dht.DimHoursTypeId = dehw.DimHoursTypeId
left join BridgeEntityEntityType bet on bet.DimEntityId = dent.DimEntityId
left join DimEntityType det on det.DimEntityTypeId = bet.DimEntityTypeId

group by 
order by dehw.Year, dehw.Month, dou.OrgUnitName"

  • Was this article helpful?