Selected Dimension

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/369

Table Type: Company

Table Name: Selected Dimension
Database Table Name: CRONUS UK Ltd_$Selected Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 369

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Selected Dimension can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Selected Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[User ID]
   ,[Object Type]
   ,[Object ID]
   ,[Analysis View Code]
   ,[Dimension Code]
   ,[New Dimension Value Code]
   ,[Dimension Value Filter]
   ,[Level]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Selected Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Selected Dimension table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(100)
3Object Type Primary Key Searchint
4Object ID Primary Key Searchint
5Analysis View Code Primary Key Searchnvarchar(20)
6Dimension Code Primary Key Searchnvarchar(60)
7New Dimension Value Code Searchnvarchar(40)
8Dimension Value Filter Searchnvarchar(500)
9Level Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *