HSO | ProServ
projects360 BI Manual — v10.0.20
  • v10.0.39
  • v10.0.34
  • v10.0.30
Table of Contents
HSO | ProServ
  • projects360 BI Manual — v10.0.20
    • projects360 BI Manual — v10.0.39
    • projects360 BI Manual — v10.0.34
    • projects360 BI Manual — v10.0.30
GrabGrab
GrabGrab
  • Introduction
  • BI Terms
  • What’s New in Version 10.0.20
    • Whats New in Version 10.0.12/13
    • What’s New in Version 10.0.9/11
  • F&O Configurations
    • Business Intelligence Tool
      • Configure
      • Inquire Utilization Data
      • Target update
  • Report Guide
    • Project Portfolio
    • Project Details
    • Contract Portfolio
    • Contract Details
    • Utilization
    • General Ledger Analysis
    • Resourcing Report
    • Accounts Receivable
    • Contract Management
    • Earned Value Management
    • Practice Manager Report
    • Practice Manager Dashboard
    • Data Model and Calculated Measures
  • Technical Guide
    • Table Based Entity Creation Best Practices
      • Best practices
      • Expected Row Count Mismatch
    • Azure SQL Databases (BYOD)
      • Common Tasks
      • Create Azure SQL DB
      • SQL Server Security
      • Publishing SQL Views
    • D365FO Tasks
      • Data Entity Publishing
      • Azure SQL Data Source Configuration
      • Run Data Export to Azure SQL
    • Manage Analysis Services
      • Publishing Tabular Model
    • Power BI
      • Publishing to Power BI
      • Power BI Using Azure Tabular
      • Writing Reports Using Power BI Service
    • Automated Data Refresh
      • Exporting Data from D365FO
      • Refresh Cube using Function App
      • Refresh Cube using PowerShell
      • Default Azure Analysis Services
  • Data Model
    • Table Relationships
      • Fact Tables
        • Actual
        • Actual Sales
        • AR Aging
        • Budget
        • Budget Sales
        • Committed Cost
        • Customer PO
        • General Ledger
        • Project Invoice
        • Timesheet
        • Utilization Target
        • Resourcing
        • Customer Transactions
        • Customer Transaction Settlement
        • Contract Agreement
        • SubContract Agreement
        • Days Sales Outstanding
      • Dimension Tables
        • Date Related Dimensions
          • Date Financial
          • Project Transaction Date
          • EffectiveDate
          • Grace Period
        • Posting Related Dimensions
          • Financial Dimension
          • Exchange Rate
          • Main Account
          • Posting Type
          • Project Transaction Type
          • Transaction Group
          • Utilization Type
          • Project Transaction Status
          • General Journal Entry
          • Timesheet Dimension
        • Resource Related Dimensions
          • Resource
          • Project Role
          • Project Controller
          • Project Manager
          • Sales Manager
        • Attribute Related Dimensions
          • Activity
          • Customer
          • Customer PO
          • Data Area
          • Line Property
          • Project
          • Project Category
          • Project Funding Source
          • Project Invoice
          • Sales Currency
          • Vendor
          • Work Location
          • Contract
          • Contract Agreement Dimension

    Table Relationships2

    Dimensions Actual Actual Sales AR Aging Budget Budget Sales Committed Cost Customer PO General Ledger Project Invoice Time Sheet Utilization Target Resourcing Contract Agreement SubContract Agreement Customer Transactions Customer Transaction Settlement Days Sales Outstanding
    Activity X X
    Contract
    Contract Agreement
    Customer
    Customer PO
    Data Area
    Date Financial
    Exchange Rate
    Financial Dimension
    Line Property
    Main Account
    Posting Type
    Project
    Project Category
    Project Controller
    Project Funding Source
    Project Invoice
    Project Manager
    Project Role
    Project Transaction Status
    Project Transaction Type
    Proj Trans Date
    Resource
    Sales Currency
    Sales Manager
    Transaction Group
    Utilization Type
    Vendor
    Work Location
    Effective Date
    General Journal Entry
    Table Relationships
    Fact Tables

    Feedback

    Was this helpful?

    Yes No
    You indicated this topic was not helpful to you ...
    Could you please leave a comment telling us why? Thank you!
    Thanks for your feedback.

    Post your comment on this topic.

    Post Comment
    Copyright © 2025 HSO | ProServ