Analysis View

Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis View

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

Table Type: Company

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

Table Number: 363

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 View can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Name]
   ,[Account Source]
   ,[Last Entry No_]
   ,[Last Budget Entry No_]
   ,[Last Date Updated]
   ,[Update on Posting]
   ,[Blocked]
   ,[Account Filter]
   ,[Business Unit Filter]
   ,[Starting Date]
   ,[Date Compression]
   ,[Dimension 1 Code]
   ,[Dimension 2 Code]
   ,[Dimension 3 Code]
   ,[Dimension 4 Code]
   ,[Include Budgets]
   ,[Refresh When Unblocked]
   ,[Reset Needed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis View]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [Analysis View].[Business Unit Filter] = [Business Unit].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Analysis View].[Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Analysis View].[Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Analysis View].[Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Analysis View].[Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Statistical Account$ea130081-c669-460f-a5f4-5dde14f03131] AS [Statistical Account]
      ON
         [Analysis View].[Statistical Account Filter] = [Statistical Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis View].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis View].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Analysis View table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Name SearchNameNormalText50Namenvarchar(100)
3Account Source SearchAccount SourceNormalOption4Account Sourceint
Available options are:
  • “G/L Account”
  • “Cash Flow Account”
  • “Statistical Account”
4Last Entry No. SearchLast Entry No.NormalInteger4Last Entry No_int
5Last Budget Entry No. SearchLast Budget Entry No.NormalInteger4Last Budget Entry No_int
6Last Date Updated SearchLast Date UpdatedNormalDate4Last Date Updateddatetime
7Update on Posting SearchUpdate on PostingNormalBoolean4Update on Postingtinyint
8Blocked SearchBlockedNormalBoolean4Blockedtinyint
9Account Filter SearchAccount FilterNormalCode250Account Filternvarchar(500)
10Business Unit Filter SearchBusiness Unit FilterNormalCode250Business Unit Filternvarchar(500)
Key to join to the Business Unit table.

Show/hide example query

SELECT
       [Analysis View].[Business Unit Filter]
       ,[Business Unit].[Code]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
              ON
                     [Analysis View].[Business Unit Filter] = [Business Unit].[Code]
11Starting Date SearchStarting DateNormalDate4Starting Datedatetime
12Date Compression SearchDate CompressionNormalOption4Date Compressionint
Available options are:
  • “None”
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Period”
13Dimension 1 Code SearchDimension 1 CodeNormalCode20Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Analysis View].[Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Analysis View].[Dimension 1 Code] = [Dimension].[Code]
14Dimension 2 Code SearchDimension 2 CodeNormalCode20Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Analysis View].[Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Analysis View].[Dimension 2 Code] = [Dimension].[Code]
15Dimension 3 Code SearchDimension 3 CodeNormalCode20Dimension 3 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Analysis View].[Dimension 3 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Analysis View].[Dimension 3 Code] = [Dimension].[Code]
16Dimension 4 Code SearchDimension 4 CodeNormalCode20Dimension 4 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Analysis View].[Dimension 4 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Analysis View].[Dimension 4 Code] = [Dimension].[Code]
17Include Budgets SearchInclude BudgetsNormalBoolean4Include Budgetstinyint
18Refresh When Unblocked SearchRefresh When UnblockedNormalBoolean4Refresh When Unblockedtinyint
19Reset Needed SearchData update neededNormalBoolean4Reset Neededtinyint
2625Statistical Account Filter SearchStatistical Account FilterNormalCode250
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Analysis View].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [User] AS [User]
              ON
                     [Analysis View].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Analysis View].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
LEFT JOIN
       [User] AS [User]
              ON
                     [Analysis View].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesAAnalysis View

Leave a Reply

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