Diagrams

Table

Analysis Selected Dimension

DynamicsDocs.comAnalysis Selected Dimension«Table 7159»Analysis Selected DimensionUser ID [PK]Object Type [PK]Object ID [PK]Dimension Code [PK]New Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3]Analysis View Code [PK]Analysis Area; [Sales,Purchase,Invento...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 7152»Item Analysis ViewAnalysis Area; [Sales,Purchase,Invento...Code [PK,NN]NameLast Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedItem FilterLocation FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeInclude BudgetsRefresh When Unblocked<User ID><Analysis View Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 User ID (User ID) Code50
2 Object Type (Object Type) Integer
3 Object ID (Object ID) Integer
4 Dimension Code (Dimension Code) Text30
5 New Dimension Value Code (New Dimension Value Code) Code20
6 Dimension Value Filter (Dimension Value Filter) Code250
7 Level (Level) Option
8 Analysis View Code (Analysis View Code) Code10
9 Analysis Area (Analysis Area) Option

Keys

# Fields
0 User ID,Object Type,Object ID,Analysis Area,Analysis View Code,Dimension Code (User ID,Object Type,Object ID,Analysis Area,Analysis View Code,Dimension Code) Clustered: Yes
1 User ID,Object Type,Object ID,Analysis Area,Analysis View Code,Level,Dimension Code (User ID,Object Type,Object ID,Analysis Area,Analysis View Code,Level,Dimension Code)

Table Relations To Other Tables

Field Related Table Related Field
Analysis View Code (Analysis View Code) Item Analysis View Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field