Microsoft Dynamics AX 2009

Cubes

CRM

Bus Matrix

Activity Phase
Activity Type
Business Relation
Campaign
Company
Customer
Employee
Item
Log Action
Posting Period
Project
Quotation
Vendor
Activity Count x x x x x x x x x x x
Log Count x x x x x x x
Quotation Amount x x x x x x x x x x
Quotation Quantity Ordered x x x x x x x x x x
Quotation Quantity Sold x x x x x x x x x x

Measures

Activity Count
Aggregate function Sum
Source fSmmActivities.wCount
Visible to Users True
Quotation Amount
Aggregate function Sum
Source fSalesQuotationLine.LineAmount
Visible to Users True
Quotation Quantity Ordered
Aggregate function Sum
Source fSalesQuotationLine.QtyOrdered
Visible to Users True
Quotation Quantity Sold
Aggregate function Sum
Source fSalesQuotationLine.SalesQty
Visible to Users True
Log Count
Aggregate function Sum
Source fSmmTransLog.wCount
Visible to Users True

Dimensions

Activity Phase
Attributes
Name Source Description
Description dSmmActivityPhaseGroup.Description
Activity Type
Attributes
Name Source Description
Description dSmmActivityTypeGroup.Description
Business Relation
Attributes
Name Source Description
Name dSmmBusRelTable.Name
Type dSmmBusRelTypeGroup.TypeDescription
Hierarchies
Business Relation Hierarchy
Level Name Source Attribute Description
Type Type
Name Name
Campaign
Attributes
Name Source Description
Name dSmmCampaignTable.CampaignName
Hierarchies
Group
Level Name Source Attribute Description
Description Campaign Group Description
Campaign Name
Reason
Level Name Source Attribute Description
Description Campaign Reason Description
Campaign Name
Type
Level Name Source Attribute Description
Description Campaign Type Description
Campaign Name
Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Number fCustTable.AccountNum
Credit Limit Type fCustTable.wCreditLimitID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name Country_Region Name
Customer Name
Employee
Attributes
Name Source Description
Name dEmplTable.Name
Item
Attributes
Name Source Description
Name dInventTable.ItemName
Number dInventTable.ItemID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Item Name
Log Action
Attributes
Name Source Description
Description wdLogAction.LogActionDescription
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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 dProjTable.ProjectIDName
Type wdProjectType.TypeDescription
Quotation
Attributes
Name Source Description
Name dSalesQuotationTable.QuotationName
Hierarchies
Phase
Level Name Source Attribute Description
Description Quotation Phase Description
Quotation Name
Probability
Level Name Source Attribute Description
Description Quotation Probability Description
Quotation Name
Prognosis
Level Name Source Attribute Description
Description Quotation Prognosis Description
Quotation Name
Reason
Level Name Source Attribute Description
Description Quotation Reason Description
Quotation Name
Vendor
Attributes
Name Source Description
Name fVendTable.Name
Number fVendTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Vendor Name

Sales

Bus Matrix

Company
Customer
Customer Invoice
Delivery Period
Employee
Item
Posting Period
Project
Sales Order
Shipping Period
Cost x x x x x x x x x
Direct Order Cost x x x x x x x x x
Margin x x x x x x x x x
Margin % x x x x x x x x x
Order Amount x x x x x x x x x
Order Margin x x x x x x x x x
Order Margin % x x x x x x x x x
Order Quantity x x x x x x x x x
Outstanding Amount x x x x x x x x x
Outstanding Quantity x x x x x x x x x
Posted Order Cost x x x x x x x x x
Quantity x x x x x x x x x
Revenue x x x x x x x x x
Shipped not Invoiced Amount x x x x x x x x x
Shipped not Invoiced Quantity x x x x x x x x x

Measures

Quantity
Aggregate function Sum
Source fCustInvoiceTrans.Qty
Visible to Users True
Revenue
Aggregate function Sum
Source fCustInvoiceTrans.LineAmountMST
Visible to Users True
Cost
Aggregate function Sum
Source fCustInvoiceTrans.wCostAmountPosted
Visible to Users True
Order Quantity
Aggregate function Sum
Source fSalesLine.SalesQty
Visible to Users True
Posted Order Cost
Aggregate function Sum
Source fSalesLine.wCostAmountPosted
Visible to Users True
Outstanding Quantity
Aggregate function Sum
Source fSalesLine.RemainSalesPhysical
Visible to Users True
Outstanding Amount
Aggregate function Sum
Source fSalesLine.wRemainPhysicalMST
Visible to Users True
Shipped not Invoiced Amount
Aggregate function Sum
Source fSalesLine.wRemainFinancialMST
Visible to Users True
Order Amount
Aggregate function Sum
Source fSalesLine.wLineAmountMST
Visible to Users True
Shipped not Invoiced Quantity
Aggregate function Sum
Source fSalesLine.RemainSalesFinancial
Visible to Users True
Direct Order Cost
Aggregate function Sum
Source fSalesLine.wOrderCost
Visible to Users True

Calculations

Margin
Expression [Revenue]-[Cost]
Visible to Users True
Margin %
Expression ([Margin]/[Revenue])*100
Visible to Users True
Order Margin
Expression [Order Amount]-[Direct Order Cost]
Visible to Users True
Order Margin %
Expression ([Order Margin]/[Order Amount])*100
Visible to Users True

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Number fCustTable.AccountNum
Credit Limit Type fCustTable.wCreditLimitID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name Country_Region Name
Customer Name
Customer Invoice
Attributes
Name Source Description
Number dCustInvoiceJour.InvoiceID
Delivery Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Employee
Attributes
Name Source Description
Name dEmplTable.Name
Item
Attributes
Name Source Description
Name dInventTable.ItemName
Number dInventTable.ItemID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Item Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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 dProjTable.ProjectIDName
Type wdProjectType.TypeDescription
Sales Order
Attributes
Name Source Description
Number dSalesTable.SalesID
Shipping Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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

Customer Ledger

Bus Matrix

Aging Bucket
Company
Customer
Posting Period
Transaction Type
Aging Days Overdue x x x x x
Amount x x x x x
Closed Amount x x x x x
Credit Limit Utilization x x
Credit Max x x
Current Balance Due x x x x x
Current Balance Overdue x x x x x
Customer Balance x x x x x
Max Customer Balance x x x x x
Overdue Days x x x x x

Measures

Amount
Aggregate function Sum
Source fCustTrans.AmountMST
Visible to Users True
Aging Days Overdue
Aggregate function Sum
Source fCustTrans.wAgingDaysOverdue
Visible to Users True
Overdue Days
Aggregate function Sum
Source fCustTrans.wOverdueDays
Visible to Users True
Current Balance Due
Aggregate function Sum
Source fCustTrans.wCurrentBalanceDue
Visible to Users True
Current Balance Overdue
Aggregate function Sum
Source fCustTrans.wCurrentBalanceOverDue
Visible to Users True
Closed Amount
Aggregate function Sum
Source fCustTrans.wClosedAmount
Visible to Users True
Credit Max
Aggregate function Sum
Source fCustTable.CreditMax
Visible to Users True

Calculations

Customer Balance
Function End Balance
Expression [Amount]
Visible to Users True
Max Customer Balance
Expression ([Customer].[Credit Limit ID].&[1],[Customer Balance])
Visible to Users True
Credit Limit Utilization
Expression ([Max Customer Balance]/[Credit Max]*100)
Visible to Users True

Dimensions

Aging Bucket
Attributes
Name Source Description
Group wdAgingBucket.Text
Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Number fCustTable.AccountNum
Credit Limit Type fCustTable.wCreditLimitID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name Country_Region Name
Customer Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Transaction Type
Attributes
Name Source Description
Text wdJournalCategory.Text

General Ledger

Bus Matrix

Account
Budget Submodel
Company
Period Code
Posting Period
Transaction Type
Amount Credited x x x x x
Amount Debited x x x x x
Amount Posted x x x x x
Budget Amount x x x x
Budget Index x x x x
Budget Variance x x x x
End Balance x x x x x
Quantity x x x x x
Start Balance x x x x x

Measures

Amount Posted
Aggregate function Sum
Source fLedgerTrans.AmountMST
Visible to Users True
Quantity
Aggregate function Sum
Source fLedgerTrans.Qty
Visible to Users True
Amount Credited
Aggregate function Sum
Source fLedgerTrans.wAmountCreditMST
Visible to Users True
Amount Debited
Aggregate function Sum
Source fLedgerTrans.wAmountDebitMST
Visible to Users True

Calculations

End Balance
Function End Balance
Expression [Amount Posted]
Visible to Users True
Start Balance
Expression [End Balance]-[Amount Posted]
Visible to Users True
Budget Variance
Expression [Amount Posted]-[Budget Amount]
Visible to Users True
Budget Index
Expression ([Amount Posted]/[Budget Amount])*100
Visible to Users True
Budget Amount
Expression sum(filter({descendants([Budget Submodel].[Model Name].currentmember,[Budget Submodel].[Model Name])},isempty([wRecID])=0), [wBudgetAmount]))
Visible to Users True

Dimensions

Account
Attributes
Name Source Description
Hierarchy dLedgerTable.wParentAccountNum
Name dLedgerTable.AccountName
Number dLedgerTable.AccountNum
Number and Name dLedgerTable.AccountNumName
Type wdLedgerAccountType.Text
Budget Model
Attributes
Name Source Description
Budget Model Key dBudgetModelHierarchy.Txt
Parent dBudgetModelHierarchy.ParentID
Budget Submodel
Attributes
Name Source Description
Company Name dDataArea.Name
Model Name dBudgetModel.Txt
Hierarchies
Submodel Hierarchy
Level Name Source Attribute Description
Company Name Company Name
Model Name Model Name
Company
Attributes
Name Source Description
Name dDataArea.Name
Period Code
Attributes
Name Source Description
Code wdPeriodCode.PeriodText
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Transaction Type
Attributes
Name Source Description
Text wdJournalCategory.Text

Vendor Ledger

Bus Matrix

Company
Posting Period
Transaction Type
Vendor
Amount x x x x
Vendor Balance x x x x

Measures

Amount
Aggregate function Sum
Source fVendTrans.AmountMST
Visible to Users True

Calculations

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

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Transaction Type
Attributes
Name Source Description
Text wdJournalCategory.Text
Vendor
Attributes
Name Source Description
Name fVendTable.Name
Number fVendTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Vendor Name

Project

Bus Matrix

Company
Customer
Employee
Invoice Entity
Posting Period
Project
Amount on Account x x x x
Invoice Cost x x x x x
Invoice Profit x x x x x
Invoice Profit % x x x x x
Invoice Quantity x x x x x
Invoice Revenue x x x x x
Project Hour Variance x x x x
Project Hours Actual x x x x x
Project Hours Budget x x x x
Project Hours Index x x x x

Measures

Project Hours Budget
Aggregate function Sum
Source fProjForecastEmplSplit.Qty
Visible to Users True
Project Hours Actual
Aggregate function Sum
Source fProjEmplTrans.Qty
Visible to Users True
Invoice Quantity
Aggregate function Sum
Source fProjInvoiceTrans.Qty
Visible to Users True
Invoice Cost
Aggregate function Sum
Source fProjInvoiceTrans.CostAmount
Visible to Users True
Invoice Revenue
Aggregate function Sum
Source fProjInvoiceTrans.wLineAmountMST
Visible to Users True
Amount on Account
Aggregate function Sum
Source fProjInvoiceOnAcc.AmountMST
Visible to Users True

Calculations

Project Hour Variance
Expression [Project Hours Budget]-[Project Hours Actual]
Visible to Users True
Project Hours Index
Expression ([Project Hours Actual]/[Project Hours Budget])*100
Visible to Users True
Invoice Profit
Expression [Invoice Revenue]-[Invoice Cost]
Visible to Users True
Invoice Profit %
Expression ([Invoice Profit]/[Invoice Revenue])*100
Visible to Users True

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Customer
Attributes
Name Source Description
Name fCustTable.Name
Number fCustTable.AccountNum
Credit Limit Type fCustTable.wCreditLimitID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Customer Name
CountryRegion
Level Name Source Attribute Description
Name Country_Region Name
Customer Name
Employee
Attributes
Name Source Description
Name dEmplTable.Name
Invoice Entity
Attributes
Name Source Description
Type Description wdProjInvoiceType.wInvoiceTypeDescription
Type Name wdProjInvoiceType.wInvoiceTypeName
Hierarchies
Hierarchy
Level Name Source Attribute Description
Type Description Type Description
Type Name Type Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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 dProjTable.ProjectIDName
Type wdProjectType.TypeDescription

Inventory

Bus Matrix

Company
Inventory Location
Inventory Status Type
Item
Posting Period
Vendor
Inventory Value Primo x x x x x x
Inventory Value Ultimo x x x x x x
Net Sales x x x x x x
Posted Inventory Value Primo x x x x x x
Posted Inventory Value Ultimo x x x x x x
Quantity x x x x x x
Quantity Primo x x x x x x
Quantity Ultimo x x x x x x
Speed x x x x x x
Speed per Year x x x x x x

Measures

Calculations

Quantity
Expression [Sum Qty Posted]+ [Sum Qty Physical]+ [Trans Qty Posted]+ [Trans Qty Physical]
Visible to Users True
Inventory Value Ultimo
Function End Balance
Expression [wBalanceInventoryValue]
Visible to Users True
Inventory Value Primo
Expression [Inventory Value Ultimo]-[Inventory Value]
Visible to Users True
Posted Inventory Value Ultimo
Function End Balance
Expression [wBalancePostedInventoryValue]
Visible to Users True
Posted Inventory Value Primo
Expression [Posted Inventory Value Ultimo]-[Posted Inventory Value]
Visible to Users True
Quantity Ultimo
Function End Balance
Expression [wBalanceQuantity]
Visible to Users True
Quantity Primo
Expression [Quantity Ultimo]-[Quantity]
Visible to Users True
Net Sales
Expression -([Inventory Value],[Inventory Trans Type].[Inventory Trans Type Key].&[0])
Visible to Users True
Speed
Expression [Inventory Value Average]>0, [Net Sales]/[Inventory Value Average], 0)
Visible to Users True
Speed per Year
Expression ([Speed]*365)/[Number of Days]
Visible to Users True

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Inventory Location
Attributes
Name Source Description
Name dInventLocation.Name
Inventory Status Type
Attributes
Name Source Description
Direction wdInventoryStatus.DirectionText
Type wdInventoryStatus.StatusText
Hierarchies
Inventory Status Hierarchy
Level Name Source Attribute Description
Direction Direction
Type Type
Item
Attributes
Name Source Description
Name dInventTable.ItemName
Number dInventTable.ItemID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Item Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Vendor
Attributes
Name Source Description
Name fVendTable.Name
Number fVendTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Vendor Name

Purchase

Bus Matrix

Company
Item
Posting Period
Vendor
Average Purchase Price x x x x
Purchase Invoice Amount x x x x
Purchase Invoice Quantity x x x x

Measures

Purchase Invoice Quantity
Aggregate function Sum
Source fVendInvoiceTrans.Qty
Visible to Users True
Purchase Invoice Amount
Aggregate function Sum
Source fVendInvoiceTrans.LineAmountMST
Visible to Users True

Calculations

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

Dimensions

Company
Attributes
Name Source Description
Name dDataArea.Name
Item
Attributes
Name Source Description
Name dInventTable.ItemName
Number dInventTable.ItemID
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Item Name
Posting Period
Attributes
Name Source Description
Date wdPostingPeriod.DateName
Month wdPostingPeriod.MonthName
Quarter wdPostingPeriod.QuarterName
Year wdPostingPeriod.YearName
Calendar Date wdPostingPeriod.DateName
Calendar Month wdPostingPeriod.CalendarMonthName
Calendar Quarter wdPostingPeriod.CalendarQuarterName
Calendar Year wdPostingPeriod.CalendarYearName
Week Year wdPostingPeriod.WeekYearName
Week wdPostingPeriod.WeekName
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
Vendor
Attributes
Name Source Description
Name fVendTable.Name
Number fVendTable.AccountNum
Hierarchies
Group
Level Name Source Attribute Description
Name Group Name
Vendor Name

Data Transformations

Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
TRANSDATE TransDate
VOUCHER Voucher
TXT Txt
AMOUNTMST AmountMST
AMOUNTCUR AmountCUR
CURRENCYCODE CurrencyCode
TRANSTYPE TransType
QTY Qty
CREDITING Crediting
PERIODCODE PeriodCode
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
ACCOUNTNAME AccountName
ACCOUNTPLTYPE AccountPLType
LEDGERCLOSING LedgerClosing
OPENINGACCOUNT OpeningAccount
COMPANYGROUPACCOUNT CompanyGroupAccount
RECID RecID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
TXT Txt
TYPE Type
SUBMODELID SubmodelID
MODELID ModelID
RECID RecID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CUSTGROUP CustGroup
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
NAME Name
CUSTGROUP CustGroup
CREDITMAX CreditMax
COUNTRYREGIONID CountryRegionID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ITEMGROUPID ItemGroupID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ITEMGROUPID ItemGroupID
ITEMID ItemID
ITEMNAME ItemName
ITEMTYPE ItemType
QTYPERLAYER QtyPerLayer
PRIMARYVENDORID PrimaryVendorID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
SALESID SalesID
SALESNAME SalesName
CUSTACCOUNT CustAccount
PROJID ProjID
DATAAREAID DataAreaID
SALESRESPONSIBLE SalesResponsible
DELIVERYDATE DeliveryDate
SALESSTATUS SalesStatus
SALESTYPE SalesType
Source Field Name Destination Field Name
COUNTRYREGIONID CountryRegionID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROBABILITYID ProbabilityID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
NAME Name
VENDGROUP VendGroup
DATAAREAID DataAreaID
Source Field Name Destination Field Name
TYPEID TypeID
TYPEDESCRIPTION TypeDescription
TABLETYPE TableType
DATAAREAID DataAreaID
Source Field Name Destination Field Name
SALESID SalesID
ORDERACCOUNT OrderAccount
INVOICEACCOUNT InvoiceAccount
INVOICEDATE InvoiceDate
DUEDATE DueDate
QTY Qty
INVOICEAMOUNT InvoiceAmount
CURRENCYCODE CurrencyCode
EXCHRATE ExchRate
INVOICEID InvoiceID
LEDGERVOUCHER LedgerVoucher
DOCUMENTNUM DocumentNum
NUMBERSEQUENCEGROUP NumberSequenceGroup
DATAAREAID DataAreaID
SALESADMINISTRATOR SalesAdministrator
Source Field Name Destination Field Name
PROJID ProjID
CATEGORYID CategoryID
TRANSDATE TransDate
TXT Txt
QTY Qty
COSTPRICE CostPrice
SALESPRICE SalesPrice
TRANSID TransID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
INVOICEDATE InvoiceDate
TXT Txt
QTY Qty
COSTAMOUNT CostAmount
SALESPRICE SalesPrice
LINEAMOUNT LineAmount
PROJID ProjID
CATEGORYID CategoryID
TRANSDATE TransDate
TRANSID TransID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
INVOICEDATE InvoiceDate
ITEMID ItemID
COSTVALUE CostValue
SALESPRICE SalesPrice
LINEPERCENT LinePercent
LINEDISC LineDisc
SALESID SalesID
PROJID ProjID
CATEGORYID CategoryID
LINEAMOUNT LineAmount
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJGROUPID ProjGroupID
CURRENCYID CurrencyID
EXCHRATE ExchRate
PROJINVOICEID InvoiceID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJGROUPID ProjGroupID
PROJID ProjID
NAME Name
STARTDATE StartDate
ENDDATE EndDate
CUSTACCOUNT CustAccount
STATUS Status
TYPE Type
JOBID JobID
JOBPAYTYPE JobPayType
PARENTID FatherID
PROJINVOICEPROJID ProjInvoiceProjID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CATEGORYID CategoryID
NAME Name
CATEGORYGROUPID CategoryGroupID
CATEGORYTYPE CategoryType
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CATEGORYGROUPID CategoryGroupID
NAME Name
CATEGORYTYPE CategoryType
DATAAREAID DateAreaID
Source Field Name Destination Field Name
NAME Name
PROJINVOICEPROJID ProjInvoiceProjID
INVOICEACCOUNT InvoiceAccount
PAYMENT Payment
DATAAREAID DataAreaID
Source Field Name Destination Field Name
LEDGERTRANSDATE LedgerTransDate
PROJID ProjID
VOUCHER Voucher
TRANSID TransID
PROJTRANSDATE ProjTransDate
PROJTRANSTYPE ProjTransType
AMOUNTMST AmountMST
COSTSALES CostSales
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJID ProjID
TRANSDATE TransDate
DESCRIPTION Description
AMOUNT Amount
TRANSID TransID
CURRENCYID CurrencyID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PHASEID PhaseID
DESCRIPTION Description
PHASESORTFIELD PhaseSortField
DATAAREAID DataAreaID
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
TYPEID TypeID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
REASONID ReasonID
DESCRIPTION Description
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CAMPAIGNGROUPDESCRIPTION CampaignGroupDescription
CAMPAIGNGROUPID CampaignGroupID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CAMPAIGNTYPEID CampaignTypeID
CAMPAIGNTYPEDESCRIPTION CampaignTypeDescription
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
PHASEID PhaseID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
TYPEID TypeID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
NUM Num
DIMENSIONCODE DimensionCode
DATAAREAID DataAreaID
Source Field Name Destination Field Name
VENDGROUP VendGroup
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PURCHID PurchID
PURCHNAME PurchName
ORDERACCOUNT OrderAccount
INVOICEACCOUNT InvoiceAccount
DATAAREAID DataAreaID
Source Field Name Destination Field Name
INVENTDIMID InventDimID
INVENTBATCHID InventBatchID
WMSLOCATIONID WmsLocationID
WMSPALLETID WmsPalletID
INVENTSERIALID InventSerialID
INVENTLOCATIONID InventLocationID
DATAAREAID DataAreaID
RECID RecID
Source Field Name Destination Field Name
ITEMID ItemID
POSTEDQTY PostedQty
POSTEDVALUE PostedValue
DEDUCTED Deducted
RECEIVED Received
RESERVPHYSICAL ReservPhysical
RESERVORDERED ReservOrdered
ONORDER OnOrder
ORDERED Ordered
QUOTATIONISSUE QuotationIssue
QUOTATIONRECEIPT QuotationReceipt
INVENTDIMID InventDimID
CLOSED Closed
REGISTERED Registered
PICKED Picked
AVAILORDERED AvailOrdered
AVAILPHYSICAL AvailPhysical
PHYSICALVALUE PhysicalValue
ARRIVED Arrived
PHYSICALINVENT PhysicalInvent
CLOSEDQTY ClosedQty
LASTUPDDATEPHYSICAL LastUpdDatePhysical
LASTUPDDATEEXPECTED LastUpdDateExpected
DATAAREAID DataAreaID
RECID RecID
Source Field Name Destination Field Name
ACCOUNTTABLEID AccountTableID
ACCOUNTRECID AccountRecID
FROMACCOUNT FromAccount
TOACCOUNT ToAccount
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DESCRIPTION Description
PROGNOSISID PrognosisID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
QUOTATIONNAME QuotationName
DATAAREAID DataAreaID
CONTACTPERSONID ContactPersonID
QUOTATIONID QuotationID
BUSRELACCOUNT BusRelAccount
QUOTATIONSTATUS QuotationStatus
QUOTATIONEXPIRYDATE QuotationExpiryDate
CAMPAIGNID CampaignID
CUSTACCOUNT CustAccount
SALESRESPONSIBLE SalesResponsible
QUOTATIONTYPE QuotationType
CONFIRMDATE ConfirmDate
DEL_PHASEID PhaseID
QUOTATIONCATEGORY QuotationCategory
DEL_PROGNOSISDATE PrognosisDate
DEL_PROGNOSISID PrognosisID
DEL_PROBABILITYID ProbabilityID
REASONID ReasonID
SALESIDREF SalesIDRef
PROJIDREF ProjIDRef
SALESORIGINID SalesOriginID
PROJINVOICEPROJID ProjInvoiceProjID
ESTIMATE Estimate
INVOICEACCOUNT InvoiceAccount
Source Field Name Destination Field Name
DEL_ACTIVITYID ActivityID
DEL_PROJID ProjID
TXT Txt
DEL_FINISHPERCENT FinishPercent
JOBID JobID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
INVOICEDATE InvoiceDate
TXT Txt
QTY Qty
COSTVALUE CostValue
SALESPRICE SalesPrice
LINEAMOUNT LineAmount
PROJID ProjID
EMPLID EmplID
CATEGORYID CategoryID
TRANSDATE TransDate
DEL_ACTIVITYID ActivityID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJID ProjID
EMPLID EmplID
CATEGORYID CategoryID
QTY Qty
COSTPRICE CostPrice
SALESPRICE SalesPrice
MODELID ModelID
TXT Txt
CURRENCYID CurrencyID
ACTIVE Active
SCHEDTODATE SchedToDate
SCHEDFROMDATE SchedFromDate
DEL_ACTIVITYID ActivityID
SCHEDTIMEHOURS SchedTimeHours
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJID ProjID
EMPLID EmplID
CATEGORYID CategoryID
TRANSDATE TransDate
TXT Txt
QTY Qty
COSTPRICE CostPrice
SALESPRICE SalesPrice
CURRENCYID CurrencyID
DEL_ACTIVITYID ActivityID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CONTACTPERSONID ContactPersonID
DEL_BUSRELACCOUNT BusRelAccount
EMPLOYEE Employee
LOGTYPE LogType
LOGDATETIME LogDateTime
LOGACTION LogAction
PRIMARYDESCRIPTION PrimaryDescription
SALESUNITID SalesUnitID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
NAME Name
CONTACTPERSONID ContactPersonID
TITLE Title
VENDACCOUNT VendAccount
CUSTACCOUNT CustAccount
DATAAREAID DataAreaID
COUNTRYREGIONID CountryRegionID
DEL_BUSRELACCOUNT BusRelAccount
MAINRESPONSIBLE CompanyContactID
Source Field Name Destination Field Name
EMPLID EmplID
DEL_NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CLOSED Closed
DEL_APPOINTMENTSTARTDATE AppointmentStartDate
PURPOSE Purpose
DEL_ENDTIME EndTime
DEL_STARTTIME StartTime
DEL_BUSRELACCOUNT BusRelAccount
RESPONSIBLEEMPLOYEE ResponsibleEmployee
DEL_CONTACTPERSONID ContactPersonID
ACTIVITYNUMBER ActivityNumber
TYPEID TypeID
PHASEID PhaseID
CATEGORY Category
SOURCE Source
TASKPRIORITY TaskPriority
DEL_SALESID SalesID
DEL_QUOTATIONID QuotationID
DEL_CAMPAIGNID CampaignID
DEL_PROJID ProjID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
DEL_VENDACCOUNT VendAccount
DEL_CUSTACCOUNT CustAccount
SALESDISTRICT SalesDistrict
DEL_NREMPLOYEES NrEmployees
SEGMENT Segment
STATUS Status
DEL_ABC ABC
BUSRELACCOUNT BusRelAccount
DEL_RELATIONTYPE RelationType
MAINCONTACT MainContact
SUBSEGMENT SubSegment
NAME Name
BUSRELTYPEID BusRelTypeID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
LINENUM LineNum
ITEMID ItemID
NAME Name
QTYORDERED QtyOrdered
COSTPRICE CostPrice
SALESPRICE SalesPrice
LINEPERCENT LinePercent
LINEDISC LineDisc
LINEAMOUNT LineAmount
SALESQTY SalesQty
PROJCATEGORYID ProjCategoryID
QUOTATIONID QuotationID
QUOTATIONSTATUS QuotationStatus
DATAAREAID DataAreaID
INVENTTRANSID InventTransID
LEDGERACCOUNT LedgerAccount
LINEHEADER LineHeader
SALESGROUP SalesGroup
SALESUNIT SalesUnit
QUOTATIONTYPE QuotationType
CUSTOMERREF CustomerRef
CUSTACCOUNT CustAccount
DEL_PROGNOSISID PrognosisID
DEL_PROBABILITYID ProbabilityID
PROJTRANSTYPE ProjTransType
PROJTRANSCODE ProjTransCode
TRANSDATE TransDate
ACCOUNTTYPE AccountType
COMPANY Ccompany
Source Field Name Destination Field Name
CAMPAIGNID CampaignID
DEL_BUSRELACCOUNT BusRelAccount
CONTACTPERSONID ContactPersonID
RESPONDED Responded
ANSWERFREQUENCY AnswerFrequency
NUMOFTARGETS NumOfTargets
NAMEID NameID
BROADCASTTYPE BroadCastType
CAMPAIGNRESPONSE CampaignResponse
DATAAREAID DataAreaID
Source Field Name Destination Field Name
INVOICEID InvoiceID
INVOICEDATE InvoiceDate
LINENUM LineNum
INVENTTRANSID InventTransID
ITEMID ItemID
CURRENCYCODE CurrencyCode
PRICEUNIT PriceUnit
QTY Qty
PURCHPRICE PurchPrice
DISCPERCENT DiscPercent
DISCAMOUNT DiscAmount
LINEAMOUNT LineAmount
PURCHID PurchID
LINEDISC LineDisc
LINEPERCENT LinePercent
NUMBERSEQUENCEGROUP NumberSequenceGroup
DATAAREAID DataAreaID
LINEAMOUNTMST LineAmountMST
INVENTDIMID InventDimID
INVENTQTY InventQty
Source Field Name Destination Field Name
VENDGROUP VendGroup
PURCHID PurchID
ORDERACCOUNT OrderAccount
INVOICEACCOUNT InvoiceAccount
INVOICEID InvoiceID
INVOICEDATE InvoiceDate
DUEDATE DueDate
QTY Qty
SUMLINEDISC SumLineDisc
CURRENCYCODE CurrencyCode
EXCHRATE ExchRate
DATAAREAID DataAreaID
NUMBERSEQUENCEGROUP NumberSequenceGroup
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
TRANSDATE TransDate
VOUCHER Voucher
INVOICE Invoice
TXT Txt
AMOUNTCUR AmountCUR
SETTLEAMOUNTCUR SettleAmountCUR
AMOUNTMST AmountMST
SETTLEAMOUNTMST SettleAmountMST
CURRENCYCODE CurrencyCode
LASTSETTLEDATE LastSettleDate
CLOSED Closed
TRANSTYPE TransType
DOCUMENTDATE DocumentDate
DATAAREAID DataAreaID
DUEDATE DelDueDate
Source Field Name Destination Field Name
INVENTLOCATIONID InventLocationID
NAME Name
DATAAREAID DataAreaID
Source Field Name Destination Field Name
PROJINVOICEID ProjInvoiceID
PROJID ProjID
AMOUNT Amount
INVOICEDATE InvoiceDate
TXT Txt
CURRENCYID CurrencyID
TRANSDATE TransDate
AMOUNTMST AmountMST
DATAAREAID DataAreaID
Source Field Name Destination Field Name
CAMPAIGNID CampaignID
CAMPAIGNNAME CampaignName
CAMPAIGNDATE CampaignDate
CAMPAIGNENDDATE CampaignEndDate
CAMPAIGNPARENTID CampaignParentID
CAMPAIGNGROUPID CampaignGroupID
CAMPAIGNTYPEID CampaignTypeID
EMPLID EmplID
CAMPAIGNCLOSED CampaignClosed
CAMPAIGNSTATUS CampaignStatus
PROJID ProjID
PROJFATHERID ProjFatherID
CAMPAIGNREASONID CampaignReasonID
DATAAREAID DataAreaID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
STARTDATE StartDate
AMOUNT Amount
CURRENCY Currency
QTY Qty
MODELNUM ModelNum
DATAAREAID DataAreaID
Source Field Name Destination Field Name
INVOICEDATE InvoiceDate
LINENUM LineNum
ITEMID ItemID
CURRENCYCODE CurrencyCode
PRICEUNIT PriceUnit
QTY Qty
SALESPRICE SalesPrice
DISCPERCENT DiscPercent
DISCAMOUNT DiscAmount
LINEAMOUNT LineAmount
QTYPHYSICAL QtyPhysical
LINEDISC LineDisc
LINEPERCENT LinePercent
LINEAMOUNTTAX LineAmountTax
DATAAREAID DataAreaID
SALESID SalesID
INVOICEID InvoiceID
INVENTTRANSID InventTransID
NUMBERSEQUENCEGROUP NumberSequenceGroup
LINEAMOUNTMST LineAmountMST
DLVDATE DlvDate
INVENTQTY InventQty
INVENTDIMID InventDimID
Source Field Name Destination Field Name
ACCOUNTNUM AccountNum
TRANSDATE TransDate
VOUCHER Voucher
INVOICE Invoice
TXT Txt
AMOUNTCUR AmountCUR
SETTLEAMOUNTCUR SettleAmountCUR
AMOUNTMST AmountMST
SETTLEAMOUNTMST SettleAmountMST
CURRENCYCODE CurrencyCode
LASTSETTLEDATE LastSettleDate
CLOSED Closed
TRANSTYPE TransType
SETTLEMENT Settlement
DATAAREAID DataAreaID
DUEDATE DelDueDate
Source Field Name Destination Field Name
ITEMID ItemID
STATUSISSUE StatusIssue
DATEPHYSICAL DatePhysical
COSTAMOUNTPOSTED CostAmountPosted
QTY Qty
CURRENCYCODE CurrencyCode
TRANSTYPE TransType
DATEFINANCIAL DateFinancial
COSTAMOUNTPHYSICAL CostAmountPhysical
DATAAREAID DataAreaID
STATUSRECEIPT StatusReceipt
INVOICEID InvoiceID
VOUCHER Voucher
DATEEXPECTED DateExpected
INVENTTRANSID InventTransID
COSTAMOUNTADJUSTMENT CostAmountAdjustment
QTYSETTLED QtySettled
COSTAMOUNTSETTLED CostAmountSettled
COSTAMOUNTSTD CostAmountStd
PACKINGSLIPRETURNED PackingSlipReturned
INVENTDIMID InventDimID
DIRECTION Direction
Source Field Name Destination Field Name
SALESID SalesID
LINENUM LineNum
ITEMID ItemID
SALESSTATUS SalesStatus
QTYORDERED QtyOrdered
SALESPRICE SalesPrice
CURRENCYCODE CurrencyCode
LINEPERCENT LinePercent
LINEDISC LineDisc
LINEAMOUNT LineAmount
CONFIRMEDDLV ConfirmedDlv
INVENTTRANSID InventTransID
SALESQTY SalesQty
DATAAREAID DataAreaID
NAME Name
REMAINSALESPHYSICAL RemainSalesPhysical
REMAINSALESFINANCIAL RemainSalesFinancial
PRICEUNIT PriceUnit
MULTILNDISC MultiLnDisc
MULTILNPERCENT MultiLnPercent
INVENTREFID InventRefID
RECID RecID
CREATEDDATETIME CreatedDatetime
SHIPPINGDATECONFIRMED ShippingDateConfirmed
SHIPPINGDATEREQUESTED ShippingDateRequested
RECEIPTDATECONFIRMED ReceiptDateConfirmed
RECEIPTDATEREQUESTED ReceiptDateRequested
COSTPRICE CostPrice
INVENTDIMID InventDimID
Source Field Name Destination Field Name
DATAAREAID DataAreaID
EXPRESSEXCHRATE ExpressExchRate
Source Field Name Destination Field Name
FROMDATE FromDate
EXCHRATE ExchRate
TODATE ToDate
CURRENCYCODE CurrencyCode
DATAAREAID DataAreaID
RECID RecID