Analysis by Dim. Parameters

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

Table Type: Company

Table Name: Analysis by Dim. Parameters
Database Table Name: CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 361

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 by Dim. Parameters can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Analysis View Code]
   ,[Line Dim Option]
   ,[Column Dim Option]
   ,[Date Filter]
   ,[Account Filter]
   ,[Bus_ Unit Filter]
   ,[Cash Flow Forecast Filter]
   ,[Budget Filter]
   ,[Dimension 1 Filter]
   ,[Dimension 2 Filter]
   ,[Dimension 3 Filter]
   ,[Dimension 4 Filter]
   ,[Show Actual_Budgets]
   ,[Show Amount Field]
   ,[Closing Entries]
   ,[Rounding Factor]
   ,[Show In Add_ Currency]
   ,[Show Column Name]
   ,[Show Opposite Sign]
   ,[Period Type]
   ,[Column Set]
   ,[Amount Type]
   ,[Analysis Account Source]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
   [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
      ON
         [Analysis by Dim. Parameters].[Analysis View Code] = [Analysis View].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
      ON
         [Analysis by Dim. Parameters].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
      ON
         [Analysis by Dim. Parameters].[Budget Filter] = [G/L Budget Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis by Dim. Parameters].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Analysis by Dim. Parameters].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Analysis by Dim. Parameters table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Analysis View Code Primary Key SearchAnalysis View CodeNormalCode10Analysis View Codenvarchar(20)
Key to join to the Analysis View table.

Show/hide example query

SELECT
       [Analysis by Dim. Parameters].[Analysis View Code]
       ,[Analysis View].[Code]
FROM
       [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
       [CRONUS UK Ltd_$Analysis View$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Analysis View]
              ON
                     [Analysis by Dim. Parameters].[Analysis View Code] = [Analysis View].[Code]
3Line Dim Option SearchLine Dim OptionNormalOption4Line Dim Optionint
Available options are:
  • “G/L Account”
  • “Period”
  • “Business Unit”
  • “Dimension 1”
  • “Dimension 2”
  • “Dimension 3”
  • “Dimension 4”
  • “Cash Flow Account”
  • “Cash Flow Forecast”
  • “Undefined”
  • “Statistical Account”
4Column Dim Option SearchColumn Dim OptionNormalOption4Column Dim Optionint
Available options are:
  • “G/L Account”
  • “Period”
  • “Business Unit”
  • “Dimension 1”
  • “Dimension 2”
  • “Dimension 3”
  • “Dimension 4”
  • “Cash Flow Account”
  • “Cash Flow Forecast”
  • “Undefined”
  • “Statistical Account”
5Date Filter SearchDate FilterNormalText250Date Filternvarchar(500)
6Account Filter SearchAccount FilterNormalText250Account Filternvarchar(500)
7Bus. Unit Filter SearchBusiness Unit FilterNormalText250Bus_ Unit Filternvarchar(500)
8Cash Flow Forecast Filter SearchCash Flow Forecast FilterNormalText250Cash Flow Forecast Filternvarchar(500)
Key to join to the Cash Flow Forecast table.

Show/hide example query

SELECT
       [Analysis by Dim. Parameters].[Cash Flow Forecast Filter]
       ,[Cash Flow Forecast].[No_]
FROM
       [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
       [CRONUS UK Ltd_$Cash Flow Forecast$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cash Flow Forecast]
              ON
                     [Analysis by Dim. Parameters].[Cash Flow Forecast Filter] = [Cash Flow Forecast].[No_]
9Budget Filter SearchBudget FilterNormalText250Budget Filternvarchar(500)
Key to join to the G/L Budget Name table.

Show/hide example query

SELECT
       [Analysis by Dim. Parameters].[Budget Filter]
       ,[G/L Budget Name].[Name]
FROM
       [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Budget Name]
              ON
                     [Analysis by Dim. Parameters].[Budget Filter] = [G/L Budget Name].[Name]
10Dimension 1 Filter SearchDimension 1 FilterNormalText250Dimension 1 Filternvarchar(500)
11Dimension 2 Filter SearchDimension 2 FilterNormalText250Dimension 2 Filternvarchar(500)
12Dimension 3 Filter SearchDimension 3 FilterNormalText250Dimension 3 Filternvarchar(500)
13Dimension 4 Filter SearchDimension 4 FilterNormalText250Dimension 4 Filternvarchar(500)
20Show Actual/Budgets SearchShowNormalOption4Show Actual_Budgetsint
Available options are:
  • “Actual Amounts”
  • “Budgeted Amounts”
  • “Variance”
  • “Variance%”
  • “Index%”
21Show Amount Field SearchShow Amount FieldNormalOption4Show Amount Fieldint
Available options are:
  • “Amount”
  • “Debit Amount”
  • “Credit Amount”
22Closing Entries SearchClosing EntriesNormalOption4Closing Entriesint
Available options are:
  • “Include”
  • “Exclude”
23Rounding Factor SearchRounding FactorNormalOption4Rounding Factorint
Available options are:
  • “None”
  • “1”
  • “1000”
  • “1000000”
24Show In Add. Currency SearchShow Amounts in Add. Reporting CurrencyNormalBoolean4Show In Add_ Currencytinyint
25Show Column Name SearchShow Column NameNormalBoolean4Show Column Nametinyint
26Show Opposite Sign SearchShow Opposite SignNormalBoolean4Show Opposite Signtinyint
30Period Type SearchView byNormalOption4Period Typeint
Available options are:
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Accounting Period”
31Column Set SearchColumn SetNormalText250Column Setnvarchar(500)
33Amount Type SearchView asNormalOption4Amount Typeint
Available options are:
  • “Net Change”
  • “Balance at Date”
34Analysis Account Source SearchAnalysis Account SourceNormalOption4Analysis Account Sourceint
Available options are:
  • “G/L Account”
  • “Cash Flow Account”
  • “Statistical Account”
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 by Dim. Parameters].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
       [User] AS [User]
              ON
                     [Analysis by Dim. Parameters].[$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 by Dim. Parameters].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Analysis by Dim_ Parameters$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Analysis by Dim. Parameters]
LEFT JOIN
       [User] AS [User]
              ON
                     [Analysis by Dim. Parameters].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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