Analysis Selected Dimension

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

Table Type: Company

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

Table Number: 7159

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 Analysis Selected Dimension can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis 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 Area]
   ,[Analysis View Code]
   ,[Dimension Code]
   ,[New Dimension Value Code]
   ,[Dimension Value Filter]
   ,[Level]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis Selected Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Analysis 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 Area Primary Key Searchint
6Analysis View Code Primary Key Searchnvarchar(20)
7Dimension Code Primary Key Searchnvarchar(60)
8New Dimension Value Code Searchnvarchar(40)
9Dimension Value Filter Searchnvarchar(500)
10Level Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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