Viewing Dimensional Accounts
After dimensions are assigned accounts, you select which dimensional accounts to display from the drop-down list in the upper-left corner, and clicking Apply.
Dimensional Input View
When dimensions are first assigned to accounts, Strategic Modeling automatically creates account instances according to the dimensional structure. These accounts are both input and calculated for aggregate values.
For example:
Non-dimensional:
Account | Type |
---|---|
Sales |
Input |
Dimensional:
Account | Type |
---|---|
Sales |
Calc |
Sales/North |
Calc |
Sales/Illinois |
Calc |
Sales/Illinois/Stereos |
Input |
Sales/Illinois/Televisions |
Input |
Sales/Michigan |
Calc |
Sales/Michigan/Stereos |
Input |
Sales/Michigan/Televisions |
Input |
Sales/South |
Calc |
Sales/Florida |
Calc |
Sales/Florida/Stereos |
Input |
Sales/Florida/Televisions |
Input |
Sales/Georgia |
Calc |
Sales/Georgia/Stereos |
Input |
Sales/Georgia/Televisions |
Input |
Dimension Order
To reorder the dimension list:
-
From the Accounts grouping label, and select Dimension, and then Maintenance.
-
Option: From the list, select the member and then click Up Arrow button to move the selected dimension up the order.
-
Option: From the list, select the member and then click Down Arrow button to move the selected dimension down the order.
Accounts display in this order:
Account | Type |
---|---|
Sales |
Calc |
Sales/Stereos |
Calc |
Sales/Stereos/North |
Calc |
Sales/Stereos/Illinois |
Input |
Sales/Stereos/Michigan |
Input |
Sales/Stereos/South |
Calc |
Sales/Stereos/Florida |
Input |
Sales/Stereos/Georgia |
Input |
Sales/Televisions |
Calc |
Sales/Televisions/North |
Calc |
Sales/Televisions/Illinois |
Input |
Sales/Televisions/Michigan |
Input |
Sales/Televisions/South |
Calc |
Sales/Televisions/Florida |
Input |
Sales/Televisions/Georgia |
Input |
Note:
Data for input accounts remains the same, regardless of order.
Dimension Level of Detail
Use dimension settings to display varying levels of detail such a member names, or only specific members. See Selecting Specific Dimension Members.
Account | Type |
---|---|
Sales/Illinois |
Calc |
Sales/Illinois/Stereos |
Input |
Sales/Illinois/Radios |
Input |
Sales/Illinois/Televisions |
Input |
Selecting Specific Dimension Members
If you select <Selected Members>, the Dimension dialog enables you to display multiple members—for example, select North, Illinois, and Michigan, and click Apply to display:
Account | Type |
---|---|
Sales/North |
Calc |
Sales/Illinois |
Calc |
Sales/Illinois/Stereos |
Input |
Sales/Illinois/Radios |
Input |
Sales/Illinois/Televisions |
Input |
Sales/Michigan |
Calc |
Sales/Michigan/Stereos |
Input |
Sales/Michigan/Radios |
Input |
Sales/Michigan/Televisions |
Input |
Dimensional Report View
In report, dimensional children display above aggregate account values, separated by subtotal lines. With All Members of both dimensions showing, the Income Statement appears as follows:
Sales Dimension | 1999 |
---|---|
Sales/Illinois/Stereos |
0.00 |
Sales/Illinois/Radios |
0.00 |
Sales/Illinois/Televisions |
0.00 |
----------- |
|
Sales/Illinois |
0.00 |
Sales/Michigan/Stereos |
0.00 |
Sales/Michigan/Radios |
0.00 |
Sales/Michigan/Televisions |
0.00 |
----------- |
|
Sales/Michigan |
0.00 |
----------- |
|
Sales/North |
0.00 |
Sales/Florida/Stereos |
0.00 |
Sales/Florida/Radios |
0.00 |
Sales/Florida/Televisions |
0.00 |
----------- |
|
Sales/Florida |
0.00 |
Sales/Georgia/Stereos |
0.00 |
Sales/Georgia/Radios |
0.00 |
Sales/Georgia/Televisions |
0.00 |
----------- |
|
Sales/Georgia |
0.00 |
----------- |
|
Sales/South |
0.00 |
----------- |
|
Sales |
0.00 |
Display Order
As on the Accounts spreadsheet, reports enable you to reorder the dimensional structure—for example, switch Product with Region and the report appears as follows:
Sales/Stereos/Illinois | 0.00 |
---|---|
Sales/Stereos/Michigan |
0.00 |
Sales/Stereos/North |
0.00 |
Sales/Stereos/Florida |
0.00 |
Sales/Stereos/Georgia |
0.00 |
----------- |
|
Sales/Stereos/South |
0.00 |
---------- |
|
Sales/Stereos |
0.00 |
Sales/Radios/Illinois |
0.00 |
Sales/Radios/Michigan |
0.00 |
----------- |
|
Sales/Radios/North |
0.00 |
Sales/Radios/Florida |
0.00 |
Sales/Radios/Georgia |
0.00 |
----------- |
|
Sales/Radios/South |
0.00 |
----------- |
|
Sales/Radios |
0.00 |
Sales/Televisions/Illinois |
0.00 |
Sales/Televisions/Michigan |
0.00 |
----------- |
|
Sales/Televisions/North |
0.00 |
Sales/Televisions/Florida |
0.00 |
Sales/Televisions/Georgia |
0.00 |
----------- |
|
Sales/Televisions/South |
0.00 |
----------- |
|
Sales/Televisions |
0.00 |
----------- |
|
Sales |
0.00 |
No Detail Display
You can show no detail on reports—for example, choose Product and Region and the report displays as follows:
Sale | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 |
---|---|---|---|---|---|---|---|
Sales |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
Non-Selected Member Display
Unlike on the Accounts spreadsheet, non-selected dimensional members must be aggregated into the account Other to reconcile the report properly—for example, selecting Illinois in the Region dimension, the report displays as follows:
Sales/Stereos/Illinois | 12.00 |
---|---|
Sales/Radios/Illinois |
6.00 |
Sales/Televisions/Illinois |
18.00 |
Sales/Other |
26.00 |
Sales |
62.00 |
Selected Member Display
If you select <Selected Members>, the Dimension dialog enables you to display multiple members—for example, if you select Illinois and Michigan, the report displays as follows:
Sales/Stereos/Illinois | 12.00 |
---|---|
Sales/Stereos/Michigan |
4.00 |
Sales/Stereos/North |
16.00 |
Sales/Radios/Illinois |
6.00 |
Sales/Radios/Michigan |
2.00 |
----------- |
|
Sales/Radios/North |
8.00 |
Sales/Televisions/Illinois |
18.00 |
Sales/Televisions/Michigan |
7.00 |
----------- |
|
Sales/Televisions/North |
25.00 |
Sales/Other |
13.00 |
----------- |
|
Sales |
62.00 |
All selected members appear in the Sales/Other account to reconcile to Sales.