Dimension Structures in Sage Intacct

In Sage Intacct; Dimension Structures assists you to organize your dimensional data on financial reports.

In last blog; we created Dimension groups (Customers) with which we were able to categorize our customers by Customer types – Residential, Corporate and Commercial. Now you have a requirement to show the sales by customer types.

In this blog we will create a simple financial report (Sales by Customer types) by using dimension structures.

Dimension structures are built from dimension groups. It is important to understand here that; dimension group dynamically filters the data and dimension structures are setup to represent the dimension data on the rows or columns on financial reports.

Dimension structure type can be flat or hierarchical. Here flat type is essentially a groups with which you can shows the members of a dimension. Whereas with hierarchical structure you can include other dimension structures with which you can show groupings and sub totals on your reports.

To accomplish the reporting example in this blog we will create flat dimension structures (customers).

Here we have created different customer report structures as per customer groups.

See below we created customer report structure called Commercial Customers. In this particular report structure we have assigned customer group – Commercial customers. This will allow the structure to list all the dimension members from the particular dimension group. Similarly create other report structures.

Now let’s create a financial report which will used above created customer report structures.

Setup a new financial report with Report structure as Dimensions.

On the Rows add the required dimension structures (Customers).

On Columns add Account group – Sales. Reporting period is Current year to date.

Finally save and run the report.

As we can see here; the report shows different types of customers. The dimension members are classified and filtered using Dimension group; so we can see relevant dimension members – customers. The next column shows Sales (YTD) by a customer.