#Custtrans transtype salesorder ax 2012 serial
#Custtrans transtype salesorder ax 2012 code

Measures with suffix PCY have values in original currency posted. Additional currency measures have suffix ACY. BI4A supports additional currency that is calculated in data warehouse with the information from currency exchange rate data in MS Dynamics A.

General Every measure in a specific OLAP cube can be overviewed over multiple companies and financial dimensions.

#Custtrans transtype salesorder ax 2012 code

Example: Attribute Hierarchy Dimension Document No (100511) Document Sales by Type: Posted Year Month ( ) Sales order (Document Type) Document Sales by Document Type (Sales order) (Posted Year Month) Type Ship-to Code (2031) (Document No) Hierarchy (Document by Type) Sales Attribute (Document No) Measure (Net sales) Document Sales by Type by Net sales Measures can be viewed over different dimensions and their hierarchies or attributes. are hidden by default and can be made visible with modification of properties in BI4A UDM on Microsoft Analysis server. Hierarchies have the possibility to drill down by levels and making business users quickly analyze granular data. Dimension consists of single attributes that are grouped in predefined hierarchy. Every cube is composed of different dimensions and different set of measures. Understanding dimensions and cubes In this chapter, the difference between cubes, dimensions, attributes and hierarchies is presented.

#Custtrans transtype salesorder ax 2012 serial

1 BI4Dynamics A White Paper BI4Dynamics A version Review: 01 Last update: December 2016Дў BI4Dynamics A White paper 1 PREFACE 4 2 CUBES FIED ASSETS GL ANALYSIS INVENTORY ANALYSIS PAYABLES ANALYSIS PRODUCTION ANALYSIS PROJECT ANALYSIS PURCHASE ANALYSIS RECEIVABLES ANALYSIS SALES ANALYSIS SHOP FLOOR CONTROL PERFORMANCE MANAGEMENT CUBE - PROFILER 64 3 DIMENSIONS MULTI-MEASURE TOOL ACCOUNT MANAGER BILL OF LADING BUDGET ALLOCATION METHOD BUDGET TRANSACTION CODE BUDGET TRANSACTION STATUS BUDGET TYPE CHARGES CLOSED PERIOD COMMISSION SALES GROUP COMPANY COMPOSITION CONSUMPTION CONTACT PERSON COST GROUP COUNTRY CURRENCY CUSTOMER DATE DELIVERY MODE DELIVERY REASON CODE DELIVERY TERM DOCUMENT CUSTOMER DOCUMENT CUSTOMER INVOICE DOCUMENT GL DOCUMENT INVENTORY DOCUMENT INVENTORY INVOICE DOCUMENT PROJECT DOCUMENT PURCHASE DOCUMENT PURCHASE ORDER DOCUMENT PURCHASE ORDER LINE DOCUMENT SALES DOCUMENT SALES LINE DOCUMENT SALES OPPORTUNITY DOCUMENT SALES ORDER DOCUMENT SALES ORDER LINE DOCUMENT SALES QUOTATION DOCUMENT VENDOR DOCUMENT VENDOR INVOICE DUE ANALYSIS 88ДЈ BI4Dynamics A White paper Page EMPLOYEE FINANCIAL DIMENSION FORECAST MODEL FIED ASSET FIED ASSETS GROUP FIED ASSETS TRANSACTION TYPE FIED ASSETS LOCATION FIED ASSETS BOOK FIED ASSETS STATUS GENERAL TYPE GL ACCOUNT GL BUDGET INVENTORY BATCH INVENTORY DIMENSIONS INVENTORY SERIAL INVENTORY SIZE GLOBAL DOCUMENT NO ITEM ITEM BUYER GROUP ITEM DIMENSION (1, 2, 3) LEDGER TRANSACTION TYPE LOCATION OUTPUT PACKING SLIP PAYMENT TERM POSTING LAYER POSTING TYPE PROCUREMENT CATEGORY PRODUCTION EMPLOYEE PRODUCTION ERROR PRODUCTION JOB PRODUCTION ORDER PRODUCTION POOL PRODUCTION ROUTE PROJECT PROJECT CATEGORY PROJECT COST CATEGORY PROJECT STATUS PROJECT TRANSACTION TYPE PROJECT TYPE PURCHASE POOL PURCHASE STATUS PURCHASE TYPE QUOTATION REJECT REASON QUOTATION STATUS QUOTATION TYPE REASON CODE RETURN REASON CODE SALES POOL SALES STATUS SALES TYPE VENDOR VENDOR CUSTOMER APPENDI SALES BENEFITS CALCULATION 111Д¤ BI4Dynamics A White paper 1 PREFACE Document describes BI4Dynamics A main analytical areas with corresponding measures and dimensions used in single OLAP cube.