-
How to use advanced SQL statements to Bulk Insert in SQL table
*NEW—Includes video demonstration. Build Along with Board Follow along as we provide a demonstration to further illustrate the basic principles shared in the step-by-step guide outlined below. https://player.vimeo.com/1124042460 Quick view 9:48: Use Case 1—Using Filters 15:50: Use Case 2—Convert Date to Datetime 21:54: Use…
-
Run an SqL data reader on the current selection
Hello, I'm running a data reader from a procedure with the YEAR (called Année) selection. I would like to scope the data based on the current year (selected when the data reader is run). Below the SqL command. I guess I should write something in the "Where" section. I tried with @Année which did not work. Thank you very…
-
Connection Board to Azure fabric - cloud SQL DB
Hi We have Board on Azure cloud supported by Board. We are moving from our old ERP solution to MS Dynamics 365. The data will be moved from Dynamics to the MS data model and to Azure Fabric – cloud. Are there any others that have made the connection from Board to Azure Fabric? We are struggling to get the connection to…
-
Datareader - SQL Connection
Hi All! We are currently implementing a new Data Warehouse with a direct connection to Board. Now, my problem is that the DataReader does not always show the available tables and views from the Data Warehouse. Within the Cloud Portal, I have set up the access correctly, and the test was successful. Sometimes, it works—I…
-
Preview SQL statement should also work with final data reader process
We are using B12 cloud version and are connected to several SQL databases (our data warehouse). I know, best idea and work is that the SQL database has tables and views organised, that fit the need of board - without the need to implement ETL etc. However, life is not alway such easy and to get this, I always need support…
-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Bulk Insert to SQL Table failed!
Hello, I tried running a basic procedure, with an initial selection and a bulk insert step. However, the procedure fails and gives this error: ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. Moreover, it does not recognize the fields in the SQL query. In the log file, all the fields are…
-
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : https://community.board.com/discussion/16889/how-to-manage-mapping-data-entry Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance…
-
How to trigger SQL server actions
1. Abstract This article discusses the possibilities of using ROLAP cubes to write flags into an SQL server, thus triggering actions on the database side, and how to process this flag. 2. Context Usually, data pre-calculations are loaded into Board from a SQL server, but there are times when we need to initiate actions on…