Profit tax totals cube (RTax25Registers) for Microsoft Dynamics AX 2012 R2 and R3

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

The Profit tax totals cube for Microsoft Dynamics AX provides data that can help you track tax information. This cube can be useful only for Russia because it is based on Russian tables. This article provides details about the cube.

Reference

Deployment

Configuration keys

Tables and views

Measures

Calculated measures

Key performance indicators

Security

Resources

Analytics in Microsoft Dynamics AX

Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3

Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Deployment

The Profit tax totals cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.

Configuration keys

The following configuration keys are required to use all features of the Profit tax totals cube:

  • Registers OLAP totals (RTax25OLAP)

Tables and views

The Profit tax totals cube uses data from the following tables and views:

  • RTax25ProfitTableOLAP view

  • RTax25RegisterTransOLAP view

Measures

The Profit tax totals cube includes the following measure groups.

Balance

This measure group is based on the RTax25RegisterTransOLAP view and includes the following measures.

Measure

Measure field name

Aggregation

Description

Associated dimensions

Balance

RTax25RegisterTransOLAP.ProfitAmount

Sum

Revenue or expense of certain type.

Company

Expense code

Register

Calculated measures

The Profit tax totals cube does not include any calculated measures.

Key performance indicators

The Profit tax totals cube does not include any key performance indicators (KPIs).

Security

The Profit tax totals cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.

  • Accountant

  • Accounting manager

  • Accounting supervisor