Editing Member Properties in the Simplified Dimension Editor
To access the Edit Member Properties tab in the Simplified dimension editor:
-
From the Home page, click Application, and then click Overview.
-
Click Dimensions, and then click the name of the dimension for which you want to view member properties.
-
Click Edit Member Properties.
-
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.
The following tables list the default dimension member properties.
For more information on dimension member properties, see Working with Dimensions.
Table 13-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 13-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 13-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 13-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 13-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 13-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 13-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 13-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 13-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 13-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 13-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 |