Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/727
Table Type: Company
Table Name: Analysis by Dim_ User Param_
Database Table Name: CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972
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_ User Param_ can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[User ID]
,[Page ID]
,[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]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Analysis by Dim_ User Param_$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Analysis by Dim_ User Param_ table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User ID  | nvarchar(100) |
| 3 | Page ID | int |
| 4 | Analysis View Code | nvarchar(20) |
| 5 | Line Dim Option | int |
| 6 | Column Dim Option | int |
| 7 | Date Filter | nvarchar(500) |
| 8 | Account Filter | nvarchar(500) |
| 9 | Bus_ Unit Filter | nvarchar(500) |
| 10 | Cash Flow Forecast Filter | nvarchar(500) |
| 11 | Budget Filter | nvarchar(500) |
| 12 | Dimension 1 Filter | nvarchar(500) |
| 13 | Dimension 2 Filter | nvarchar(500) |
| 14 | Dimension 3 Filter | nvarchar(500) |
| 15 | Dimension 4 Filter | nvarchar(500) |
| 16 | Show Actual_Budgets | int |
| 17 | Show Amount Field | int |
| 18 | Closing Entries | int |
| 19 | Rounding Factor | int |
| 20 | Show In Add_ Currency | tinyint |
| 21 | Show Column Name | tinyint |
| 22 | Show Opposite Sign | tinyint |
| 23 | Period Type | int |
| 24 | Column Set | nvarchar(500) |
| 25 | Amount Type | int |
| 26 | $systemId | uniqueidentifier |
| 27 | $systemCreatedAt | datetime |
| 28 | $systemCreatedBy | uniqueidentifier |
| 29 | $systemModifiedAt | datetime |
| 30 | $systemModifiedBy | uniqueidentifier |