Microsoft Financials 2.60

Cubes

Name	Quick Links
CRM
CRM	Overview	Measures	Dimensions
Finance
Customer Ledger	Overview	Measures	Dimensions
General Ledger	Overview	Measures	Dimensions
Vendor Ledger	Overview	Measures	Dimensions
Project
Job	Overview	Measures	Dimensions
Sales
Sales	Overview	Measures	Dimensions
SCM
Inventory	Overview	Measures	Dimensions
Purchase	Overview	Measures	Dimensions

CRM

Bus Matrix

Activity

Bill-to Customer

Campaign

Company

Contact

Customer

Department

Invoice Customer

Posting Period

Project

Prospect

SalespersonPurchaser

Ship-to Customer

Completion %

Cost

Number of Activities

Number of Completed Activities

Number of Uncompleted Activities

Profit

Profit %

Profit per Activity (Avg.)

Quantity

Sales

Sales per Activity (Avg.)

Measures

Number of Activities
Aggregate function	Sum
Source	dActivity.wCount
Visible to Users	True

Number of Completed Activities
Aggregate function	Sum
Source	dActivity.wCountCompleted
Visible to Users	True

Number of Uncompleted Activities
Aggregate function	Sum
Source	dActivity.wCountUncompleted
Visible to Users	True

Calculations

Sales
Expression	[Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Cost
Expression	[Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Quantity
Expression	[Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Profit
Expression	[Sales]-[Cost]
Visible to Users	True

Profit %
Expression	([Profit]/[Sales])*100
Visible to Users	True

Sales per Activity (Avg.)
Expression	[Sales]/[Number of Activities]
Visible to Users	True

Profit per Activity (Avg.)
Expression	[Profit]/[Number of Activities]
Visible to Users	True

Completion %
Expression	([Number of Completed Activities]/[Number of Activities])*100
Visible to Users	True

Dimensions

Activity
Attributes
Name	Source	Description
Description	dActivity.Description
Type	dActivityType.Description
Completion	dActivity.CompletedText
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Type	Type
Description	Description

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Campaign
Attributes
Name	Source	Description
Description	dCampaign.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Contact
Attributes
Name	Source	Description
Number	dContact.No
Name	dContact.Name
Prospect	dProspect.Name
Job Responsibility	dContactJobResponsibility.Description
Prospect INTERMEDIATE	dContact.ProspectNo
Hierarchies
Prospect Hierarchy
Level Name	Source Attribute	Description
Prospect	Prospect
Name	Name

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Invoice Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProject.Name

Prospect
Attributes
Name	Source	Description
Name	dProspect.Name
Size	dProspect.NoofEmployeesGroup
Status	dProspectStatus.Description
Customer INTERMEDIATE	dProspect.CustomerNo
Department INTERMEDIATE	dProspect.DepartmentCode
Project INTERMEDIATE	dProspect.ProjectCode

Sales Credit Memo
Attributes
Name	Source	Description
Number	dSalesCrMemoHeader.No

Sales Invoice
Attributes
Name	Source	Description
Number	dSalesInvoiceHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Ship-to Customer
Attributes
Name	Source	Description
Code	dShiptoAddress.Code
Name	dShiptoAddress.Name
Type	wdShiptoType.Text
Hierarchies
Country Hierarchy
Level Name	Source Attribute	Description
Country	Country
Name	Name

Customer Ledger

Bus Matrix

	Aging Bucket	Company	Credit Limit Type	Customer	Customer Ledger Entry	Department	Due Period	Posting Period	Project	SalespersonPurchaser	Source
Amount	x	x	x	x	x	x	x	x	x	x	x
Amount Credited	x	x	x	x	x	x	x	x	x	x	x
Amount Debited	x	x	x	x	x	x	x	x	x	x	x
Average number of Open Days	x	x	x	x	x	x	x	x	x	x	x
Average number of Overdue Days	x	x	x	x	x	x	x	x	x	x	x
Avg Customer Balance	x	x	x	x	x	x	x	x	x	x	x
Closed Amount	x	x	x	x	x	x	x	x	x	x	x
Closed Entry Count	x	x	x	x	x	x	x	x	x	x	x
Credit Limit		x	x	x		x			x	x
Credit Limit Utilization		x	x	x		x			x	x
Current Balance Due	x	x	x	x	x	x	x	x	x	x	x
Current Balance Overdue	x	x	x	x	x	x	x	x	x	x	x
Customer Balance	x	x	x	x	x	x	x	x	x	x	x
Limited Customer Balance	x	x	x	x	x	x	x	x	x	x	x
Overdue Entry Count	x	x	x	x	x	x	x	x	x	x	x
Sales	x	x	x	x	x	x	x	x	x	x	x
Total number of Open Days	x	x	x	x	x	x	x	x	x	x	x
Total number of Overdue Days	x	x	x	x	x	x	x	x	x	x	x
Turnover Ratio	x	x	x	x	x	x	x	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fDetailedCustLedgEntry.AmountLCY
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fDetailedCustLedgEntry.DebitAmountLCY
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fDetailedCustLedgEntry.CreditAmountLCY
Visible to Users	True

Total number of Open Days
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wOpenDays
Visible to Users	True

Total number of Overdue Days
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wOverdueDays
Visible to Users	True

Closed Entry Count
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wCountClosed
Visible to Users	True

Overdue Entry Count
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wCountOverdue
Visible to Users	True

Current Balance Due
Aggregate function	Sum
Source	fDetailedCustLedgEntry.RemainingAmtLCY
Visible to Users	True

Closed Amount
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wClosedAmountLCY
Visible to Users	True

Sales
Aggregate function	Sum
Source	fDetailedCustLedgEntry.SalesLCY
Visible to Users	True

Current Balance Overdue
Aggregate function	Sum
Source	fDetailedCustLedgEntry.wRemainingAmtOverdueLCY
Visible to Users	True

Credit Limit
Aggregate function	Sum
Source	dCustomer.CreditLimitLCY
Visible to Users	True

Calculations

Average number of Open Days
Expression	[Total number of Open Days]/[Closed Entry Count]
Visible to Users	True

Average number of Overdue Days
Expression	[Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users	True

Customer Balance
Function	End Balance
Expression	[Amount]
Visible to Users	True

Limited Customer Balance
Expression	([Credit Limit Type].[LimitID].&[1],[Customer Balance])
Visible to Users	True

Credit Limit Utilization
Expression	([Limited Customer Balance]/[Credit Limit])*100
Visible to Users	True

Avg Customer Balance
Expression	([Customer Balance]+[wCustomerOpeningBalance])/2
Visible to Users	True

Turnover Ratio
Expression	round([Sales]/[Avg Customer Balance],2)
Visible to Users	True

Dimensions

Aging Bucket
Attributes
Name	Source	Description
Group	wdAgingBucket.Text

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Credit Limit Type
Attributes
Name	Source	Description
Limit Type	dCustomer.wHasCreditLimit

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Customer Ledger Entry
Attributes
Name	Source	Description
Number	fDetailedCustLedgEntry.EntryNo
Description	fDetailedCustLedgEntry.Description
Document Type	wdJournalDocumentType.Text
Document Number	fDetailedCustLedgEntry.DocumentNo

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Due Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProject.Name

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

General Ledger

Bus Matrix

Account

Budget

Business Posting Group

Closing Entries

Company

Customer

Department

General Ledger Detail

IncomeBalance

Job

Posting Period

Product Posting Group

Project

Source

Vendor

Amount Credited

Amount Debited

Amount Posted

Budget Amount

Budget Index

Budget Variance

End Balance

Start Balance

Measures

Amount Posted
Aggregate function	Sum
Source	fGLEntry.Amount
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fGLEntry.DebitAmount
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fGLEntry.CreditAmount
Visible to Users	True

Budget Amount
Aggregate function	Sum
Source	fGLBudgetEntry.Amount
Visible to Users	True

Calculations

Budget Variance
Expression	[Amount Posted]-[Budget Amount]
Visible to Users	True

Budget Index
Expression	([Amount Posted]/[Budget Amount])
Visible to Users	True

End Balance
Function	End Balance
Expression	[Amount Posted]
Visible to Users	True

Start Balance
Expression	[End Balance]-[Amount Posted]
Visible to Users	True

Dimensions

Account
Attributes
Name	Source	Description
Account Table	dGLAccount.wParentNo
Number	dGLAccount.No
Name	dGLAccount.Name
Number and Name	dGLAccount.NoName
IncomeBalance	dGLAccount.wAccountGroup
Company and Account	dGLAccount.CompanyNoName

Budget
Attributes
Name	Source	Description
Name	dGLBudgetName.Description

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Closing Entries
Attributes
Name	Source	Description
Text	wdPostingDateClosing.ClosingText

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

General Ledger Detail
Attributes
Name	Source	Description
Number	fGLEntry.EntryNo
Type	wdGLSourceType.Text
Hierarchies
Number Group
Level Name	Source Attribute	Description
Range	wGroup
Number	Number

IncomeBalance
Attributes
Name	Source	Description
Text	dGLAccount.wAccountGroup

Job
Attributes
Name	Source	Description
Job Number	dJob.No
Job Description	dJob.Description
Job Number and Description	dJob.NoDescription
Status	wdJobStatus.Text

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Project
Attributes
Name	Source	Description
Name	dProject.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Territory	dTerritory.Name
Country	dCountry.Name
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Inventory

Bus Matrix

Business Posting Group

Company

Customer

Department

Inventory Entry Type

Inventory Posting Group

Item

Location

Posting Period

Product Posting Group

Project

Vendor

Cost of Sales

Cost Posted to G/L

Days to sell Inventory

Days to sell Inventory (Yearly)

Inventory Value Average

Inventory Value Primo

Inventory Value Ultimo

Net Sales Cost

Profit

Profit %

Quantity Changes

Quantity Decreases

Quantity in Stock Primo

Quantity in Stock Ultimo

Quantity Increases

Quantity Sold

Sales

Speed

Value Changes

Value Decreases

Value Increases

Yearly Speed

Measures

Calculations

Value Increases
Expression	([Inventory Main Entry Type].[Main Type].&[1],[Base Value])
Visible to Users	True

Value Decreases
Expression	([Inventory Main Entry Type].[Main Type].&[0],[Base Value])*(-1)
Visible to Users	True

Value Changes
Expression	[Value Increases]-[Value Decreases]
Visible to Users	True

Quantity Increases
Expression	([Inventory Main Entry Type].[Main Type].&[1],[Base Quantity])
Visible to Users	True

Quantity Decreases
Expression	([Inventory Main Entry Type].[Main Type].&[0],[Base Quantity])*(-1)
Visible to Users	True

Quantity Changes
Expression	[Quantity Increases]-[Quantity Decreases]
Visible to Users	True

Inventory Value Ultimo
Function	End Balance
Expression	[Value Changes]
Visible to Users	True

Inventory Value Primo
Expression	[Inventory Value Ultimo]-[Value Changes]
Visible to Users	True

Quantity in Stock Ultimo
Function	End Balance
Expression	[Quantity Changes]
Visible to Users	True

Quantity in Stock Primo
Expression	[Quantity in Stock Ultimo]-[Quantity Changes]
Visible to Users	True

Net Sales Cost
Expression	([Inventory Main Entry Type].[Entry Type].&[1],[Value Changes])*(-1)
Visible to Users	True

Inventory Value Average
Expression	([Inventory Value Primo]+[Inventory Value Ultimo])/2
Visible to Users	True

Speed
Expression	[Inventory Value Average]>0, [Net Sales Cost]/[Inventory Value Average]
Visible to Users	True

Yearly Speed
Expression	([Speed]*365)/[Number of Days]
Visible to Users	True

Sales
Expression	([Inventory Main Entry Type].[Entry Type].&[1],[Amount])*(-1)
Visible to Users	True

Cost of Sales
Expression	([Inventory Main Entry Type].[Entry Type].&[1],[Adjusted Cost Invoiced])*(-1)
Visible to Users	True

Quantity Sold
Expression	([Inventory Main Entry Type].[Entry Type].&[1],[Quantity Changes])*(-1)
Visible to Users	True

Profit
Expression	[Sales]-[Cost of Sales]
Visible to Users	True

Profit %
Expression	([Profit]/[Sales])*100
Visible to Users	True

Cost Posted to G/L
Expression	[Cost Posted to G_L]
Visible to Users	True

Days to sell Inventory
Expression	365/[Speed]
Visible to Users	True

Days to sell Inventory (Yearly)
Expression	365/[Yearly Speed]
Visible to Users	True

Dimensions

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Inventory Entry Type
Attributes
Name	Source	Description
Description	wdItemEntryType.EntryTypeDescription
Hierarchies
Main Type
Level Name	Source Attribute	Description
Description	wMainType
Type	Description

Inventory Posting Group
Attributes
Name	Source	Description
Description	dInventoryPostingGroup.Description

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription

Location
Attributes
Name	Source	Description
Name	dLocation.Name

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Project
Attributes
Name	Source	Description
Name	dProject.Name

Valuation Method
Attributes
Name	Source	Description
Text	wdInventoryValuationMethod.Text

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Territory	dTerritory.Name
Country	dCountry.Name
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Job

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Department

Invoice Customer

Job

Job Phase

Job Step

Job Task

Posting Period

Product Posting Group

Project

Sales Entity

SalespersonPurchaser

Ship-to Customer

Source

Budgeted Job Cost

Budgeted Job Price

Budgeted Job Quantity

Cost Budget Index

Cost Budget Variance

Excess Invoicing

Excess Invoicing %

Invoiced Cost

Invoiced Price

Invoiced Quantity

Price Budget Index

Price Budget Variance

Profit

Profit %

Quantity Budget Index

Quantity Budget Variance

Total Cost

Total Price

Total Quantity

Measures

Budgeted Job Quantity
Aggregate function	Sum
Source	fJobBudgetEntry.Quantity
Visible to Users	True

Budgeted Job Cost
Aggregate function	Sum
Source	fJobBudgetEntry.TotalCost
Visible to Users	True

Budgeted Job Price
Aggregate function	Sum
Source	fJobBudgetEntry.TotalPrice
Visible to Users	True

Calculations

Invoiced Price
Expression	[Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Invoiced Cost
Expression	[Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Invoiced Quantity
Expression	[Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Total Price
Expression	[Invoiced Price]+[Job Ledger Price]
Visible to Users	True

Total Quantity
Expression	[Invoiced Quantity]+[Job Ledger Quantity]
Visible to Users	True

Total Cost
Expression	[Invoiced Cost]+[Job Ledger Cost]
Visible to Users	True

Excess Invoicing
Expression	[Total Price]-[Invoiced Price]
Visible to Users	True

Profit
Expression	[Invoiced Price]-[Total Cost]
Visible to Users	True

Profit %
Expression	([Profit]/[Invoiced Price])*100
Visible to Users	True

Excess Invoicing %
Expression	([Invoiced Price]/[Total Price])*100
Visible to Users	True

Price Budget Variance
Expression	[Invoiced Price]-[Budgeted Job Price]
Visible to Users	True

Price Budget Index
Expression	([Invoiced Price]/[Budgeted Job Price])*100
Visible to Users	True

Cost Budget Variance
Expression	[Budgeted Job Cost]-[Total Cost]
Visible to Users	True

Cost Budget Index
Expression	([Budgeted Job Cost]/[Total Cost])*100
Visible to Users	True

Quantity Budget Variance
Expression	[Budgeted Job Quantity]-[Total Quantity]
Visible to Users	True

Quantity Budget Index
Expression	iif ([Total Quantity]=0, null, ([Budgeted Job Quantity]/[Total Quantity])*100)
Visible to Users	True

Dimensions

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Invoice Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Job
Attributes
Name	Source	Description
Job Number	dJob.No
Job Description	dJob.Description
Job Number and Description	dJob.NoDescription
Status	wdJobStatus.Text

Job Phase
Attributes
Name	Source	Description
Description	dPhase.Description

Job Step
Attributes
Name	Source	Description
Description	dStep.Description

Job Task
Attributes
Name	Source	Description
Description	dTask.Description

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Project
Attributes
Name	Source	Description
Name	dProject.Name

Sales Credit Memo
Attributes
Name	Source	Description
Number	dSalesCrMemoHeader.No

Sales Entity
Attributes
Name	Source	Description
Sales Entity	wdItemResourceType.Text
Number	wdItemResource.No
Description	wdItemResource.Description
Number and Description	wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Sales Entity	Sales Entity
Number and Description	Number and Description

Sales Invoice
Attributes
Name	Source	Description
Number	dSalesInvoiceHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Ship-to Customer
Attributes
Name	Source	Description
Code	dShiptoAddress.Code
Name	dShiptoAddress.Name
Type	wdShiptoType.Text
Hierarchies
Country Hierarchy
Level Name	Source Attribute	Description
Country	Country
Name	Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Purchase

Bus Matrix

Business Posting Group

Company

Department

Invoice Vendor

Item

Job

Order Period

Posting Period

Product Posting Group

Project

Purchase Credit Memo

Purchase Entity

Purchase Invoice

Purchase Order

SalespersonPurchaser

Source

Vendor

Average Cost Price

Cost

Credit Memo Amount

Credit Memo Cost

Credit Memo Quantity

Invoice Amount

Invoice Cost

Invoice Quantity

Order Amount

Order Cost

Order Quantity

Outstanding Amount

Outstanding Cost

Outstanding Quantity

Purchase

Quantity

Total Average Cost Price

Total Cost

Total Purchase

Total Quantity

Measures

Invoice Quantity
Aggregate function	Sum
Source	fPurchInvLine.Quantity
Visible to Users	True

Invoice Amount
Aggregate function	Sum
Source	fPurchInvLine.wAmountLCY
Visible to Users	True

Invoice Cost
Aggregate function	Sum
Source	fPurchInvLine.wCostLCY
Visible to Users	True

Credit Memo Quantity
Aggregate function	Sum
Source	fPurchCrMemoLine.Quantity
Visible to Users	True

Credit Memo Amount
Aggregate function	Sum
Source	fPurchCrMemoLine.wAmountLCY
Visible to Users	True

Credit Memo Cost
Aggregate function	Sum
Source	fPurchCrMemoLine.wCostLCY
Visible to Users	True

Order Quantity
Aggregate function	Sum
Source	fPurchaseLine.Quantity
Visible to Users	True

Order Amount
Aggregate function	Sum
Source	fPurchaseLine.wAmountLCY
Visible to Users	True

Outstanding Amount
Aggregate function	Sum
Source	fPurchaseLine.wOutstandingAmountLCY
Visible to Users	True

Outstanding Quantity
Aggregate function	Sum
Source	fPurchaseLine.wOutstandingQuantity
Visible to Users	True

Order Cost
Aggregate function	Sum
Source	fPurchaseLine.wCostLCY
Visible to Users	True

Outstanding Cost
Aggregate function	Sum
Source	fPurchaseLine.wOutstandingCostLCY
Visible to Users	True

Calculations

Purchase
Expression	[Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Quantity
Expression	[Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Cost
Expression	[Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Average Cost Price
Expression	[Purchase]/[Quantity]
Visible to Users	True

Total Purchase
Expression	[Purchase] + [Outstanding Amount]
Visible to Users	True

Total Quantity
Expression	[Quantity] + [Outstanding Quantity]
Visible to Users	True

Total Average Cost Price
Expression	[Total Purchase]/[Total Quantity]
Visible to Users	True

Total Cost
Expression	[Cost] + [Outstanding Cost]
Visible to Users	True

Dimensions

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Invoice Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Territory	dTerritory.Name
Country	dCountry.Name
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription

Job
Attributes
Name	Source	Description
Job Number	dJob.No
Job Description	dJob.Description
Job Number and Description	dJob.NoDescription
Status	wdJobStatus.Text

Order Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Project
Attributes
Name	Source	Description
Name	dProject.Name

Purchase Credit Memo
Attributes
Name	Source	Description
Number	dPurchCrMemoHdr.No

Purchase Entity
Attributes
Name	Source	Description
Type	wdItemAsset.TypeDescription
Number	wdItemAsset.No
Description	wdItemAsset.Description
Number and Description	wdItemAsset.NoDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Type	Type
Description	Description

Purchase Invoice
Attributes
Name	Source	Description
Number	dPurchInvHeader.No

Purchase Order
Attributes
Name	Source	Description
Number	dPurchaseHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Territory	dTerritory.Name
Country	dCountry.Name
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Sales

Bus Matrix

Bill-to Customer

Business Posting Group

Company

Customer

Department

Invoice Customer

Item

Job

Order Period

Posting Period

Product Posting Group

Project

Sales Credit Memo

Sales Entity

Sales Invoice

Sales Order

SalespersonPurchaser

Shipment Period

Ship-to Customer

Source

Cost

Credit Memo Amount

Credit Memo Cost

Credit Memo Quantity

Number of Credit Memos

Number of Invoices

Number of Open Orders

Order Amount

Order Cost

Order Profit

Order Profit %

Order Quantity

Outstanding Amount

Outstanding Cost

Outstanding Profit

Outstanding Profit %

Outstanding Quantity

Profit

Profit %

Quantity

Sales

Sales Invoice Amount

Sales Invoice Cost

Sales Invoice Quantity

Shipped Not Invoiced Amount

Shipped not Invoiced Quantity

Total Cost

Total Profit

Total Profit %

Total Quantity

Total Sales

Measures

Credit Memo Quantity
Aggregate function	Sum
Source	fSalesCrMemoLine.Quantity
Visible to Users	True

Credit Memo Amount
Aggregate function	Sum
Source	fSalesCrMemoLine.wAmountLCY
Visible to Users	True

Credit Memo Cost
Aggregate function	Sum
Source	fSalesCrMemoLine.wCostLCY
Visible to Users	True

Sales Invoice Quantity
Aggregate function	Sum
Source	fSalesInvoiceLine.Quantity
Visible to Users	True

Sales Invoice Amount
Aggregate function	Sum
Source	fSalesInvoiceLine.wAmountLCY
Visible to Users	True

Sales Invoice Cost
Aggregate function	Sum
Source	fSalesInvoiceLine.wCostLCY
Visible to Users	True

Order Amount
Aggregate function	Sum
Source	fSalesLine.wLineAmountLCY
Visible to Users	True

Outstanding Amount
Aggregate function	Sum
Source	fSalesLine.wOutstandingAmountLCY
Visible to Users	True

Order Cost
Aggregate function	Sum
Source	fSalesLine.wLineCostLCY
Visible to Users	True

Outstanding Cost
Aggregate function	Sum
Source	fSalesLine.wOutstandingCostLCY
Visible to Users	True

Order Quantity
Aggregate function	Sum
Source	fSalesLine.Quantity
Visible to Users	True

Outstanding Quantity
Aggregate function	Sum
Source	fSalesLine.wOutstandingQuantity
Visible to Users	True

Shipped not Invoiced Quantity
Aggregate function	Sum
Source	fSalesLine.QtyShippedNotInvoiced
Visible to Users	True

Shipped Not Invoiced Amount
Aggregate function	Sum
Source	fSalesLine.wShippedNotInvoicedAmountLCY
Visible to Users	True

Number of Invoices
Aggregate function	DistinctCount
Source	fSalesInvoiceLine.wSalesInvoiceCount
Visible to Users	True

Number of Credit Memos
Aggregate function	DistinctCount
Source	fSalesCrMemoLine.wCreditMemoCount
Visible to Users	True

Number of Open Orders
Aggregate function	DistinctCount
Source	fSalesLine.wSalesCount
Visible to Users	True

Calculations

Sales
Expression	[Sales Invoice Amount]-[Credit Memo Amount]
Visible to Users	True

Cost
Expression	[Sales Invoice Cost]-[Credit Memo Cost]
Visible to Users	True

Quantity
Expression	[Sales Invoice Quantity]-[Credit Memo Quantity]
Visible to Users	True

Profit
Expression	[Sales]-[Cost]
Visible to Users	True

Profit %
Expression	([Profit]/[Sales])*100
Visible to Users	True

Order Profit
Expression	[Order Amount]-[Order Cost]
Visible to Users	True

Order Profit %
Expression	([Order Profit]/[Order Amount])*100
Visible to Users	True

Outstanding Profit
Expression	[Outstanding Amount]-[Outstanding Cost]
Visible to Users	True

Outstanding Profit %
Expression	([Outstanding Profit]/[Outstanding Amount])*100
Visible to Users	True

Total Sales
Expression	[Sales]+[Outstanding Amount]
Visible to Users	True

Total Cost
Expression	[Cost]+[Outstanding Cost]
Visible to Users	True

Total Quantity
Expression	[Quantity]+[Outstanding Quantity]
Visible to Users	True

Total Profit
Expression	[Total Sales]-[Total Cost]
Visible to Users	True

Total Profit %
Expression	([Total Profit]/[Total Sales])*100
Visible to Users	True

Dimensions

Bill-to Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Business Posting Group
Attributes
Name	Source	Description
Description	dGenBusinessPostingGroup.Description

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Invoice Customer
Attributes
Name	Source	Description
Number	dCustomer.No
Name	dCustomer.Name
Credit Limit Type	dCustomer.wHasCreditLimit
Country	dCountry.Name
Territory	dTerritory.Name
Number and Name	dCustomer.NoName
Payment Terms	dPaymentTerms.Description
Hierarchies
Customer Country
Level Name	Source Attribute	Description
Country	Country
Name	Name
Customer Territory
Level Name	Source Attribute	Description
Territory	Territory
Name	Name

Item
Attributes
Name	Source	Description
Number	dItem.No
Description	dItem.Description
Number and Description	dItem.NoDescription

Job
Attributes
Name	Source	Description
Job Number	dJob.No
Job Description	dJob.Description
Job Number and Description	dJob.NoDescription
Status	wdJobStatus.Text

Order Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Product Posting Group
Attributes
Name	Source	Description
Description	dGenProductPostingGroup.Description

Project
Attributes
Name	Source	Description
Name	dProject.Name

Sales Credit Memo
Attributes
Name	Source	Description
Number	dSalesCrMemoHeader.No

Sales Entity
Attributes
Name	Source	Description
Sales Entity	wdItemResourceType.Text
Number	wdItemResource.No
Description	wdItemResource.Description
Number and Description	wdItemResource.NoDescription
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Sales Entity	Sales Entity
Number and Description	Number and Description

Sales Invoice
Attributes
Name	Source	Description
Number	dSalesInvoiceHeader.No

Sales Order
Attributes
Name	Source	Description
Number	dSalesHeader.No

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Shipment Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Ship-to Customer
Attributes
Name	Source	Description
Code	dShiptoAddress.Code
Name	dShiptoAddress.Name
Type	wdShiptoType.Text
Hierarchies
Country Hierarchy
Level Name	Source Attribute	Description
Country	Country
Name	Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor Ledger

Bus Matrix

	Company	Department	Due Period	Posting Period	Project	SalespersonPurchaser	Source	Vendor	Vendor Ledger Entry
Amount	x	x	x	x	x	x	x	x	x
Amount Credited	x	x	x	x	x	x	x	x	x
Amount Debited	x	x	x	x	x	x	x	x	x
Average number of Open Days	x	x	x	x	x	x	x	x	x
Average number of Overdue Days	x	x	x	x	x	x	x	x	x
Closed Entry Count	x	x	x	x	x	x	x	x	x
Overdue Entry Count	x	x	x	x	x	x	x	x	x
Total number of Open Days	x	x	x	x	x	x	x	x	x
Total number of Overdue Days	x	x	x	x	x	x	x	x	x
Vendor Balance	x	x	x	x	x	x	x	x	x

Measures

Amount
Aggregate function	Sum
Source	fVendorLedgerEntry.AmountLCY
Visible to Users	True

Amount Debited
Aggregate function	Sum
Source	fVendorLedgerEntry.DebitAmountLCY
Visible to Users	True

Amount Credited
Aggregate function	Sum
Source	fVendorLedgerEntry.CreditAmountLCY
Visible to Users	True

Total number of Open Days
Aggregate function	Sum
Source	fVendorLedgerEntry.wOpenDays
Visible to Users	True

Total number of Overdue Days
Aggregate function	Sum
Source	fVendorLedgerEntry.wOverdueDays
Visible to Users	True

Closed Entry Count
Aggregate function	Sum
Source	fVendorLedgerEntry.wCountClosed
Visible to Users	True

Overdue Entry Count
Aggregate function	Sum
Source	fVendorLedgerEntry.wCountOverdue
Visible to Users	True

Calculations

Average number of Open Days
Expression	[Total number of Open Days]/[Closed Entry Count]
Visible to Users	True

Average number of Overdue Days
Expression	[Total number of Overdue Days]/[Overdue Entry Count]
Visible to Users	True

Vendor Balance
Function	End Balance
Expression	[Amount]
Visible to Users	True

Dimensions

Company
Attributes
Name	Source	Description
Name	wdCompany.CompanyName

Department
Attributes
Name	Source	Description
Name	dDepartment.Name

Due Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Posting Period
Attributes
Name	Source	Description
Year	wdPostingPeriod.YearName
Quarter	wdPostingPeriod.QuarterName
Month	wdPostingPeriod.MonthName
Date	wdPostingPeriod.DateName
Calendar Date	wdPostingPeriod.DateName
Calendar Month	wdPostingPeriod.CalendarMonthName
Calendar Quarter	wdPostingPeriod.CalendarQuarterName
Calendar Year	wdPostingPeriod.CalendarYearName
Week	wdPostingPeriod.WeekName
Week Year	wdPostingPeriod.WeekYearName
Hierarchies
Hierarchy
Level Name	Source Attribute	Description
Year	Year
Quarter	wYearQuarter
Month	wYearMonth
Date	Date
Calendar Hierarchy
Level Name	Source Attribute	Description
Year	Calendar Year
Quarter	wCalendarYearQuarter
Month	wCalendarYearMonth
Date	Calendar Date
Week Hierarchy
Level Name	Source Attribute	Description
Year	Week Year
Week	wYearWeek
Date	Date

Project
Attributes
Name	Source	Description
Name	dProject.Name

SalespersonPurchaser
Attributes
Name	Source	Description
Name	dSalespersonPurchaser.Name

Source
Attributes
Name	Source	Description
Description	dSourceCode.Description

Vendor
Attributes
Name	Source	Description
Vendor Number	dVendor.No
Vendor Name	dVendor.Name
Vendor Number and Name	dVendor.NoName
Territory	dTerritory.Name
Country	dCountry.Name
Hierarchies
Vendor Country
Level Name	Source Attribute	Description
Name	Country
Vendor	Vendor Name
Vendor Territory
Level Name	Source Attribute	Description
Name	Territory
Vendor	Vendor Name

Vendor Ledger Entry
Attributes
Name	Source	Description
Number	fVendorLedgerEntry.EntryNo
Description	fVendorLedgerEntry.Description
Document Type	wdJournalDocumentType.Text
Document Number	fVendorLedgerEntry.DocumentNo

Data Transformations

Country (9)	dCountry
Source Field Name	Destination Field Name
Name	Name
Code	Code

Territory (286)	dTerritory
Source Field Name	Destination Field Name
Code	Code
Name	Name

Contact (5002)	dContact
Source Field Name	Destination Field Name
No.	No
Name	Name
Title	Title
Prospect No.	ProspectNo
Job Title	JobTitle
Responsibility Level	ResponsibilityLevel
Salesperson Code	SalespersonCode
Country Code	CountryCode
Job Responsibility Code	JobResponsibilityCode

Salesperson_Purchaser (13)	dSalespersonPurchaser
Source Field Name	Destination Field Name
Code	Code
Name	Name

Gen_ Business Posting Group (250)	dGenBusinessPostingGroup
Source Field Name	Destination Field Name
Code	Code
Description	Description

Gen_ Product Posting Group (251)	dGenProductPostingGroup
Source Field Name	Destination Field Name
Code	Code
Description	Description

Source Code (230)	dSourceCode
Source Field Name	Destination Field Name
Description	Description
Code	Code

G_L Budget Name (95)	dGLBudgetName
Source Field Name	Destination Field Name
Description	Description
Name	Name

G_L Account (15)	dGLAccount
Source Field Name	Destination Field Name
Name	Name
Indentation	Indentation
No.	No
Account Type	AccountType
Income/Balance	IncomeBalance

Work Type (200)	dWorkType
Source Field Name	Destination Field Name
Description	Description
Code	Code

Resource (156)	dResource
Source Field Name	Destination Field Name
No.	No
Name	Name

Customer (18)	dCustomer
Source Field Name	Destination Field Name
No.	No
Name	Name
Territory Code	TerritoryCode
Country Code	CountryCode
Credit Limit (LCY)	CreditLimitLCY
Department Code	DepartmentCode
Project Code	ProjectCode
Payment Terms Code	PaymentTermsCode
Salesperson Code	SalespersonCode

Currency (4)	dCurrency
Source Field Name	Destination Field Name
Code	Code
Description	Description

Item (27)	dItem
Source Field Name	Destination Field Name
No.	No
Description	Description
Base Unit of Measure	BaseUnitOfMeasure
Unit Cost	UnitCost
Standard Cost	StandardCost
Vendor No.	VendorNo
Inventory Posting Group	InventoryPostingGroup

Inventory Posting Group (94)	dInventoryPostingGroup
Source Field Name	Destination Field Name
Code	Code

Location (14)	dLocation
Source Field Name	Destination Field Name
Code	Code
Name	Name

Vendor (23)	dVendor
Source Field Name	Destination Field Name
Name	Name
Territory Code	TerritoryCode
No.	No
Country Code	CountryCode

G_L Entry (17)	fGLEntry
Source Field Name	Destination Field Name
G/L Account No.	GLAccountNo
Posting Date	PostingDate
Document Type	DocumentType
Document No.	DocumentNo
Description	Description
Amount	Amount
Source Code	SourceCode
Job No.	JobNo
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Debit Amount	DebitAmount
Credit Amount	CreditAmount
Entry No.	EntryNo
Department Code	DepartmentCode
Project Code	ProjectCode
Source Type	SourceType
Source No.	SourceNo

G_L Budget Entry (96)	fGLBudgetEntry
Source Field Name	Destination Field Name
Budget Name	BudgetName
G/L Account No.	GLAccountNo
Date	Date
Amount	Amount
Description	Description
Entry No.	EntryNo
Department Code	DepartmentCode
Project Code	ProjectCode

Sales Cr_ Memo Line (115)	fSalesCrMemoLine
Source Field Name	Destination Field Name
Document No.	DocumentNo
Sell-to Customer No.	SellToCustomerNo
Type	Type
No.	No
Quantity	Quantity
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Unit Cost	UnitCost
Line No.	LineNo
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Unit Cost (LCY)	UnitCostLCY
Department Code	DepartmentCode
Project Code	ProjectCode
Shipment Date	ShipmentDate

Sales Cr_ Memo Header (114)	dSalesCrMemoHeader
Source Field Name	Destination Field Name
No.	No
Posting Date	PostingDate
Currency Code	CurrencyCode
Salesperson Code	SalespersonCode
Currency Factor	CurrencyFactor
Sell-to Customer No.	SellToCustomerNo
Source Code	SourceCode
Bill-to Customer No.	BilltoCustomerNo
Ship-to Code	ShiptoCode
Shipment Date	ShipmentDate

Sales Invoice Line (113)	fSalesInvoiceLine
Source Field Name	Destination Field Name
Document No.	DocumentNo
Sell-to Customer No.	SellToCustomerNo
Type	Type
No.	No
Quantity	Quantity
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Unit Cost	UnitCost
Line No.	LineNo
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Department Code	DepartmentCode
Project Code	ProjectCode
Unit Cost (LCY)	UnitCostLCY
Shipment Date	ShipmentDate

Sales Invoice Header (112)	dSalesInvoiceHeader
Source Field Name	Destination Field Name
No.	No
Posting Date	PostingDate
Currency Code	CurrencyCode
Salesperson Code	SalespersonCode
Currency Factor	CurrencyFactor
Sell-to Customer No.	SellToCustomerNo
Source Code	SourceCode
Bill-to Customer No.	BilltoCustomerNo
Ship-to Code	ShiptoCode
Order Date	OrderDate
Shipment Date	ShipmentDate

Item Ledger Entry (32)	fItemLedgerEntry
Source Field Name	Destination Field Name
Item No.	ItemNo
Posting Date	PostingDate
Entry Type	EntryType
Source No.	SourceNo
Location Code	LocationCode
Quantity	Quantity
Transaction Type	TransactionType
Document Date	DocumentDate
Entry No.	EntryNo
Department Code	DepartmentCode
Project Code	ProjectCode
Open	Open
Adjusted Cost (Qty.)	AdjustedCostQty
Adjusted Cost (Invoiced Qty.)	AdjustedCostInvoicedQty
Cost Posted to G/L	CostPostedtoGL
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Amount	Amount
Invoiced Quantity	InvoicedQuantity
Source Type	SourceType
Positive	Positive

Cust_ Ledger Entry (21)	fDetailedCustLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Posting Date	PostingDate
Document Type	DocumentType
Document No.	DocumentNo
Amount	Amount
Amount (LCY)	AmountLCY
Customer No.	CustomerNo
Currency Code	CurrencyCode
Source Code	SourceCode
Debit Amount	DebitAmount
Debit Amount (LCY)	DebitAmountLCY
Credit Amount	CreditAmount
Credit Amount (LCY)	CreditAmountLCY
Closed at Date	wClosedAtDate
Due Date	wDueDate
Open	wOpen
Department Code	DepartmentCode
Project Code	ProjectCode
Remaining Amt. (LCY)	RemainingAmtLCY
Sales (LCY)	SalesLCY
Description	Description

Job Budget Entry (211)	fJobBudgetEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Job Status	JobStatus
Job No.	JobNo
Type	Type
No.	No
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Date	Date
Resource Group No.	ResourceGroupNo
Quantity	Quantity
Total Cost	TotalCost
Total Price	TotalPrice

Phase (161)	dPhase
Source Field Name	Destination Field Name
Code	Code
Description	Description

Resource Group (152)	dResourceGroup
Source Field Name	Destination Field Name
No.	No
Name	Name

Step (163)	dStep
Source Field Name	Destination Field Name
Code	Code
Description	Description

Task (162)	dTask
Source Field Name	Destination Field Name
Code	Code
Description	Description

Job Ledger Entry (169)	fJobLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Job No.	JobNo
Posting Date	PostingDate
Document No.	DocumentNo
Type	Type
No.	No
Description	Description
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost	UnitCost
Total Cost	TotalCost
Unit Price	UnitPrice
Total Price	TotalPrice
Resource Group No.	ResourceGroupNo
Unit of Measure Code	UnitofMeasureCode
Location Code	LocationCode
Work Type Code	WorkTypeCode
Source Code	SourceCode
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Amt. to Post to G/L	AmttoPosttoGL
Amt. Posted to G/L	AmtPostedtoGL
Amt. to Recognize	AmttoRecognize
Amt. Recognized	AmtRecognized
Entry Type	EntryType
Open	Open
Remaining Amount	RemainingAmount
Area	Area
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Department Code	DepartmentCode
Project Code	ProjectCode

Job (167)	dJob
Source Field Name	Destination Field Name
No.	No
Description	Description
Creation Date	CreationDate
Starting Date	StartingDate
Ending Date	EndingDate
Completion Date	CompletionDate
Job Posting Date	JobPostingDate
Completion %	CompletionPct
Status	Status
Person Responsible	PersonResponsible
Bill-to Customer No.	BilltoCustomerNo

Department (11)	dDepartment
Source Field Name	Destination Field Name
Code	Code
Name	Name

Project (12)	dProject
Source Field Name	Destination Field Name
Code	Code
Name	Name

Prospect (5000)	dProspect
Source Field Name	Destination Field Name
No.	No
Name	Name
Territory Code	TerritoryCode
Department Code	DepartmentCode
Project Code	ProjectCode
Salesperson Code	SalespersonCode
Country Code	CountryCode
Customer No.	CustomerNo
Status Code	StatusCode
Vendor No.	VendorNo
No. of Employees	NoofEmployees

Prospect Status (5001)	dProspectStatus
Source Field Name	Destination Field Name
Code	Code
Description	Description

Prospect Trade (5012)	dProspectTrade
Source Field Name	Destination Field Name
Description	Description
Trade Code	TradeCode
Prospect No.	ProspectNo

Activity (5008)	dActivity
Source Field Name	Destination Field Name
Date	Date
Inbound	Inbound
Type	Type
Description	Description
Completed	Completed
Prospect No.	ProspectNo
Contact No.	ContactNo
Campaign No.	CampaignNo
Salesperson Code	SalespersonCode

Activity Type (5009)	dActivityType
Source Field Name	Destination Field Name
Code	Code
Description	Description
Campaign No.	CampaignNo

Campaign (5004)	dCampaign
Source Field Name	Destination Field Name
Description	Description
No.	No
Starting Date	StartingDate
Ending Date	EndingDate
Salesperson Code	SalespersonCode

Contact Job Responsibility (5003)	dContactJobResponsibility
Source Field Name	Destination Field Name
Code	Code
Description	Description

Purch_ Cr_ Memo Hdr_ (124)	dPurchCrMemoHdr
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Posting Date	PostingDate
Currency Factor	CurrencyFactor
Job No.	JobNo
Purchaser Code	PurchaserCode
Source Code	SourceCode
Ship-to Code	ShiptoCode

Purch_ Cr_ Memo Line (125)	fPurchCrMemoLine
Source Field Name	Destination Field Name
Type	Type
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
No.	No
Location Code	LocationCode
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Unit Price (LCY)	UnitPriceLCY
Department Code	DepartmentCode
Project Code	ProjectCode
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Amount	Amount

Purch_ Inv_ Header (122)	dPurchInvHeader
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Posting Date	PostingDate
Purchaser Code	PurchaserCode
Job No.	JobNo
Currency Factor	CurrencyFactor
Source Code	SourceCode
Ship-to Code	ShiptoCode
Order Date	OrderDate

Purch_ Inv_ Line (123)	fPurchInvLine
Source Field Name	Destination Field Name
Type	Type
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
No.	No
Location Code	LocationCode
Posting Group	PostingGroup
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Amount	Amount
Unit Price (LCY)	UnitPriceLCY
Department Code	DepartmentCode
Project Code	ProjectCode
Job No.	JobNo
Phase Code	PhaseCode
Task Code	TaskCode
Step Code	StepCode
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup

Vendor Ledger Entry (25)	fVendorLedgerEntry
Source Field Name	Destination Field Name
Entry No.	EntryNo
Vendor No.	VendorNo
Posting Date	PostingDate
Document Type	DocumentType
Document No.	DocumentNo
Amount	Amount
Remaining Amount	RemainingAmount
Original Amt. (LCY)	OriginalAmtLCY
Remaining Amt. (LCY)	RemainingAmtLCY
Amount (LCY)	AmountLCY
Purchase (LCY)	PurchaseLCY
Inv. Discount (LCY)	InvDiscountLCY
Department Code	DepartmentCode
Project Code	ProjectCode
Purchaser Code	PurchaserCode
Source Code	SourceCode
Due Date	DueDate
Pmt. Discount Date	PmtDiscountDate
Debit Amount (LCY)	DebitAmountLCY
Credit Amount (LCY)	CreditAmountLCY
Open	Open
Closed at Date	ClosedAtDate
Description	Description

Fixed Asset (5600)	dFixedAsset
Source Field Name	Destination Field Name
No.	No
Description	Description

Ship-to Address (222)	dShiptoAddress
Source Field Name	Destination Field Name
Customer No.	CustomerNo
Code	Code
Name	Name
Country Code	CountryCode

Sales Line (37)	fSalesLine
Source Field Name	Destination Field Name
Document Type	DocumentType
Document No.	DocumentNo
Line No.	LineNo
Sell-to Customer No.	SelltoCustomerNo
Type	Type
No.	No
Location Code	LocationCode
Shipment Date	ShipmentDate
Description	Description
Unit of Measure	UnitofMeasure
Quantity	Quantity
Outstanding Quantity	OutstandingQuantity
Qty. to Invoice	QtytoInvoice
Qty. to Ship	QtytoShip
Unit Price	UnitPrice
Unit Cost (LCY)	UnitCostLCY
Line Discount %	LineDiscountPct
Line Discount Amount	LineDiscountAmount
Amount	Amount
Amount Including VAT	AmountIncludingVAT
Job No.	JobNo
Outstanding Amount	OutstandingAmount
Qty. Shipped Not Invoiced	QtyShippedNotInvoiced
Shipped Not Invoiced	ShippedNotInvoiced
Quantity Shipped	QuantityShipped
Quantity Invoiced	QuantityInvoiced
Bill-to Customer No.	BilltoCustomerNo
Inv. Discount Amount	InvDiscountAmount
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Transaction Type	TransactionType
Currency Code	CurrencyCode
Outstanding Amount (LCY)	OutstandingAmountLCY
Shipped Not Invoiced (LCY)	ShippedNotInvoicedLCY
Reserve	Reserve
Unit Cost	UnitCost
Qty. per Unit of Measure	QtyperUnitofMeasure
Planned	Planned
Unit of Measure Code	UnitofMeasureCode
Quantity (Base)	QuantityBase
Outstanding Qty. (Base)	OutstandingQtyBase
Qty. to Invoice (Base)	QtytoInvoiceBase
Qty. to Ship (Base)	QtytoShipBase
Qty. Shipped Not Invd. (Base)	QtyShippedNotInvdBase
Qty. Shipped (Base)	QtyShippedBase
Qty. Invoiced (Base)	QtyInvoicedBase
VAT %	VATPct
Phase Code	PhaseCode
Step Code	StepCode
Task Code	TaskCode
Department Code	DepartmentCode
Project Code	ProjectCode

Sales Header (36)	dSalesHeader
Source Field Name	Destination Field Name
Document Type	DocumentType
No.	No
Sell-to Customer No.	SelltoCustomerNo
Bill-to Customer No.	BilltoCustomerNo
Ship-to Code	ShiptoCode
Order Date	OrderDate
Posting Date	PostingDate
Shipment Date	ShipmentDate
Location Code	LocationCode
Currency Code	CurrencyCode
Currency Factor	CurrencyFactor
Salesperson Code	SalespersonCode
Ship	Ship
Invoice	Invoice
Gen. Bus. Posting Group	GenBusPostingGroup
Document Date	DocumentDate
Reserve	Reserve

Purchase Header (38)	dPurchaseHeader
Source Field Name	Destination Field Name
No.	No
Buy-from Vendor No.	BuyfromVendorNo
Pay-to Vendor No.	PaytoVendorNo
Ship-to Code	ShiptoCode
Order Date	OrderDate
Posting Date	PostingDate
Currency Factor	CurrencyFactor
Purchaser Code	PurchaserCode
Job No.	JobNo

Purchase Line (39)	fPurchaseLine
Source Field Name	Destination Field Name
No.	No
Document No.	DocumentNo
Line No.	LineNo
Buy-from Vendor No.	BuyfromVendorNo
Type	Type
Location Code	LocationCode
Posting Group	PostingGroup
Quantity	Quantity
Direct Unit Cost	DirectUnitCost
Unit Cost (LCY)	UnitCostLCY
Line Discount Amount	LineDiscountAmount
Amount	Amount
Unit Price (LCY)	UnitPriceLCY
Job No.	JobNo
Gen. Bus. Posting Group	GenBusPostingGroup
Gen. Prod. Posting Group	GenProdPostingGroup
Step Code	StepCode
Task Code	TaskCode
Phase Code	PhaseCode
Document Type	DocumentType
Quantity Invoiced	QuantityInvoiced
Department Code	DepartmentCode
Project Code	ProjectCode

Payment Terms (3)	dPaymentTerms
Source Field Name	Destination Field Name
Code	Code
Description	Description