Editing Member Properties in the Simplified Dimension Editor

To access the Edit Member Properties tab in the Simplified dimension editor:

1. From the Home page, click Application, and then click Overview.

2. Click Dimensions, and then click the name of the dimension for which you want to view member properties.

3. Click Edit Member Properties.

4. To edit member properties in the Simplified dimension editor grid, click within a grid cell to edit text or to view a drop-down menu from which you can choose member properties. You can also drag and drop member property values over to rows and columns to fill in properties that are the same.

   See Working with the Simplified Dimension Editor Grid.

The following tables list the default dimension member properties.

For more information on dimension member properties, see Working with Dimensions.

Table 12-2 Account Member Properties

Property	Valid Values	Default Value
Account Type	Expense, Revenue, Asset, Liability, Equity, Saved Assumption	Expense
Variance Reporting	Expense, Non-Expense	Non Expense
Exchange Rate Type	No Rate, Average, Ending, Historical, Historical Rate Override, Historical Amount Override Average and Ending are considered as No Rate.	No Rate
Consol Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Rates Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Consol Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Never Share, Dynamic Calc, Label Only, Shared	Parent Member: Dynamic Calc Child Member: Never Share
Default Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Never Share, Dynamic Calc, Label Only, Shared	Parent Member: Dynamic Calc Child Member: Never Share
Rate Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Never Share, Dynamic Calc, Label Only, Dhared	Parent Member: Dynamic Calc Child Member: Never Share
Two Pass Calculation	No, Yes	No
Smart Lists	None	None
Data Type	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text	Currency
Time Balance	Flow, Balance	Flow
CICTA Redirection Account	None	None
Is CICTA Account	None	None
Intercompany Account	None	None
Plug Account	None	None
Is Plug Account	None	None
Default Movement	None	None
Is Indexed Attribute	None	None
Alias Table	Default	Default
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-3 Consolidation Member Properties

Property	Valid Values	Default Value
Access Granted to Member Creator	Inherit	Inherit
Alias Table	Default	Default
Consol Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Store	Parent Member: Dynamic Calc Child Member: Store
Default Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Store	Parent Member: Dynamic Calc Child Member: Store
Rates Data Storage	Parent Member: Dynamic Calc, Label Only Child Member: Store	Parent Member: Dynamic Calc Child Member: Store
Two Pass Calculation	No	No
Consol Consol op	Addition, Never	Addition
Rate Consol op	Addition, Never	Addition
Data Type	Unspecified	Unspecified
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-4 Currency Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Default Data Storage	Store, Dynamic Calc, Never Share, Label Only	Store
Two Pass Calculation	No, Yes	No
Data Type	Unspecified	Unspecified
Smart Lists	None	None
Symbol	Predefined List	None
Scale	Predefined List	1
Precision	Predefined List	None
Reporting Currency	No, Yes	No
Thousands Separator	Predefined List	None
Decimal	Predefined List	Period
Negative Sign	Predefined List	Prefixed Minus
Negative Color	Black, Red	Black

Table 12-5 Custom Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Consol Data Storage	Never Share, Shared, Dynamic Calc	Never Share
Default Data Storage	Never Share, Shared, Dynamic Calc	Never Share
Rates Data Storage	Never Share, Shared, Dynamic Calc	Never Share
Two Pass Calculation	No	No
Consol Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Data Type	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text	Currency
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-6 DataSource Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Consol Data Storage	Parent Member: Dynamic Calc, Shared, Label Child Member: Shared, Store, Dynamic Calc	Parent Member: Dynamic Calc Child Member: Store
Default Data Storage	Parent Member: Dynamic Calc, Shared, Label Child Member: Shared, Store, Dynamic Calc	Parent Member: Dynamic Calc Child Member: Store
Rates Data Storage	Parent Member: Dynamic Calc, Shared, Label Child Member: Shared, Store, Dynamic Calc	Parent Member: Dynamic Calc Child Member: Store
Two Pass Calculation	No, Yes	No
Consol Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Data Type	Unspecified	Unspecified
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-7 Entity Member Properties

Property	Valid Values	Default Value
Base Currency	Currencies in the Rates Cube (cannot be set to None)	Currencies in the Rates Cube (cannot be set to None)
Consol Data Storage	Never Share, Share	Never Share
Default Data Storage	Never Share, Share	Never Share
Rates Data Storage	Never Share, Share	Never Share
Two Pass Calculation	No, Yes	No
Consol Consol op	Ignore	Ignore
Rates Consol op	Ignore	Ignore
Data Type	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text	Unspecified
Smart Lists	None	None
Intercompany (Attribute Dimension)	Parent Member: None, Yes Child Member: None	Parent Member: None Child Member: None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-8 Intercompany Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Consol Data Storage	Never Share	Never Share
Default Data Storage	Never Share	Never Share
Rates Data Storage	Never Share	Never Share
Two Pass Calculation	No	No
Consol Consol op	Addition	Addition
Data Type	Unspecified	Unspecified
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-9 Movement Member Properties

Property	Default Value	Valid Values
Alias Table	Default	Default
Consol Data Storage	Parent Member: Never Share, Dynamic Calc, Shared, Label Only Child Member: Never Share, Shared, Label Only	Parent Member: Dynamic Calc Child Member: Never Share
Default Data Storage	Parent Member: Never Share, Dynamic Calc, Shared, Label Only Child Member: Never Share, Shared, Label Only	Parent Member: Dynamic Calc Child Member: Never Share
Two Pass Calculation	No	No, Yes
Consol Consol op	Addition	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never
Data Type	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text	Currency
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-10 Period Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Consol Data Storage	Parent Member: Dynamic Calc, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Default Data Storage	Parent Member: Dynamic Calc, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Rates Data Storage	Parent Member: Dynamic Calc, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Two Pass Calculation	No, Yes	No
Data Type	Unspecified	Unspecified
Consol Consol op	Addition	Addition
Rates Consol op	Addition	Addition
Smart Lists	None	None
Enable for Approvals	Parent Member: No Child Member: Yes	Parent Member: No Child Member: Yes

Table 12-11 Scenario Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Start Year This property is not used in Financial Consolidation and Close and should be ignored.	All the years in the application	First Year
Start Period This property is not used in Financial Consolidation and Close and should be ignored.	Select from valid values	Select from valid values
End Year This property is not used in Financial Consolidation and Close and should be ignored.	All the years in the application	Last Year
End Period This property is not used in Financial Consolidation and Close and should be ignored.	Select from valid values	Select from valid values
Include BegBal as Time Period This property is not used in Financial Consolidation and Close and should be ignored.	Yes, No	No
Enable for Approvals	Yes, No	Yes
Exchange Rate Table This property is not used in Financial Consolidation and Close and should be ignored.	None	None
Consol Data Storage	Parent Member: Dynamic Calc, Shared Child Member: Never Share, Shared	Parent Member: Dynamic Calc Child Member: Never Share
Default Data Storage	Parent Member: Dynamic Calc, Shared Child Member: Never Share, Shared	Parent Member: Dynamic Calc Child Member: Never Share
Rates Data Storage	Never Share	Never Share
Two Pass Calculation	Parent Member: No, Yes Child Member: No	Parent Member: No Child Member: No
Consol Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Rates Consol op	Addition, Subtraction, Multiplication, Division, Percent, Ignore, Never	Addition
Data Type	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text	Unspecified
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-12 View Member Properties

Property	Valid Values	Default Value
Alias Table	Default	Default
Enable for Process Management	Yes	Yes
Consol Data Storage	Never Share, Dynamic Calc	Never Share
Rates Data Storage	Never Share	Never Share
Two Pass Calculation	No	No
Consol Consol op.	Ignore	Ignore
Data Type	Unspecified	Unspecified
Smart Lists	None	None
Enable for Dynamic Children	No	No
Number of Possible Dynamic Children	10	10
Access Granted to Member Creator	Inherit	Inherit

Table 12-13 Year Member Properties

Property	Default Value	Valid Values
Alias Table	Default	Default
Consol Data Storage	Parent Member: Dynamic Calc, Store, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Default Data Storage	Parent Member: Dynamic Calc, Store, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Rates Data Storage	Parent Member: Dynamic Calc, Store, Shared Child Member: Store, Shared	Parent Member: Dynamic Calc Child Member: Store
Two Pass Calculation	No	No
Data Type	Unspecified	Currency, Non Currency, Unspecified, Percentage, Smart List, Date, Text
Smart Lists	None	None