The data selection in your row definitions, column definitions, and statement versions
must have a commonality of data; otherwise, or some or all of the values of the rows and
columns on the financial statement will be blank. In #u30190842__CACECHHH, the intersection of Row 1 and Column 1 would include
asset account balances for Business Unit 1 in Company 111. However, if Business Unit 1
did not have any asset accounts, then the intersection of Row 1 and Column 1 would be
blank because there is no common data for asset accounts for Business Unit 1. This image
illustrates the statement output if Business Unit 1 had no asset accounts:
Likewise, if Company 111 specified in the data selection for the statement version did
not have Business Units 3-6, then the intersection of both rows and Column 2 would be
blank.
This image illustrates the financial statement output when no commonality of data exists
between the data selection associated with the statement version (Company 111) and the
data selection associated with a column definition:
Caution: Use caution when
specifying your data selection. If you make an error, you might get unexpected
results. For example, suppose that you set up a balance sheet statement and create a
row for Assets and a row of Liabilities and Shareholder Equity. The asset accounts
in your system are accounts 1000-3999, and your liability and shareholder equity
accounts are 4000-4999. You set up the data selection for the Liabilities and
Shareholder Equity row to include the range 4000-4999, and you mistakenly set up the
data selection for the Asset row to include the range 1000-3990. When you run the
statement, your statement will include account balances, but the balances will not
be accurate if you have balances in accounts 3991-3999. Those balances would not be
included in the statement because they were not included in the data
selection.The One View Financial Statements functionality enables you to
review the data selection for your row and column definitions when you add the row
and column definitions to statement definitions. You also have access to the data
selection for the statement's rows and columns; and statement version, in the BI
Publisher Layout Editor. You can create a page with the data selection information
in your layout.See Creating Layouts in the BI Publisher Layout
Editor.
