Reporting on a blank dimension

In dimension based ERPs transactions are often posted without a dimension, or a 'blank' dimension. It's important to be able to report on transactions without a specific dimension to account for all balances in the system. To report accurately on blank dimensions you can type '[]' (one open and one closed bracket) to represent a blank dimension. You can do it on the same row as the range of dimension values that are specified, or a separate row.

The report below shows that you will get the same results if you put a range and a blank row and add them together as a single line. Both account for all transactions in the Cash account, which you can verify by adding the account with no further dimension restrictions. The screen shot also shows that a wildcard will not pick up blank segments, so they do need to be explicitly defined.

The row definition shows the different design options, including the blank on a single line, or on two separate line.

Comments

• Anonymous
  August 05, 2014
  I’m trying to find out that is there any way to use management reporter with dimensions like traditional financial statements in Dynamics AX. There it was easy to create reports with all values of specific dimension set by leaving row definition empty. Is there any way to create row definition for certain dimension (Project) that would include automatically all values. Of course i could create row that includes range that includes all values but I would like to see all project balances as a list in same report without any other dimensions or accounts. For eaxmple if i have 6000 projects and there will be about 100 new Projects every month. Do i need to create row definition or reporting tree again every month if i want to have Project balances list in same report without any other dimensions or accounts. -Fsu*