-
Default Landing Page
Hi Community, Is there a way to default users to a specified screen on opening rather than the default capsule view? Thanks in advance. ☺️ Jon
-
About Grand Total
Q1. I want to change the notation of grand total to, for example, total year. Is there any way? (Yellow part) Q2. Can I apply the rule to Grand Total? (Green part) Now, I have set the following rules. c=(b/a)%, f=(e/d)% I want to set the same rules for grand total, as shown below. i=(h/g)%
-
[Board 12.5.1.1] - Datagridview Nexel convert string to date
Hello, does this type of formula work into datagriview? =TEXT([@b;*;*],"d/MM/yyyy")
-
Session expired (reason: 0x0419)
I encounter periodic session expiration with message "Session expired (reason: 0x0419)". I lose some of unsaved work. What is the reason for this? How I can turn it off?
-
[TECH] Dataflow concurrency in DB with a lot of users
Hello, I have a budgeting datamodel with 300 users (facility manager) where we are sometime facing DB crash / data loss. Since it is a budgeting model, we have a lof of dataflows launched by user to perform calculations. For an unknown reason sometime a BOARD is not able to complete a simple / basic dataflow, so the…
-
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…
-
"Timeout expired" error when running a procedure comprising of "Bulk insert to SQL Table" step.
Hi all, I am trying to carry out Bulk insert to SQL Table , but I keep getting a "timeout expired" error message. Here are some details about my setup: I am running this procedure on a Board cloud server which also has SQL database connection set-up. I'm using Microsoft SQL Server. I got the error as shown below in SQL…
-
"pending data entry" - no alert upon re-opening screen with procedure
Hi, we found that with V12.6, coming from V10, there is no alert for "pending data entry" anymore, in case you re-open a screen using a procedure. Screen close and refresh (F5) is working in terms of producing this alert, but not opening it again via procedure. Is this a known issue and will that be fixed with V14? Thanks…
-
Displaying revenue data for bissextile year with previous year function
Hello, I am facing a challenge with displaying revenue data for bissextile years when using a previous year function. We have a cube by day, and a screen selection on the current fiscal period (March2024-February2025), a dataview that shows the revenue for N and revenue for N-1 values. The issue regards the N-1 column on…
-
Triggering a back end procedure on click
Hello, I have a data entry block through checkboxes. I would like trigger a back end procedure on click (said differently, when I select the checkbox). Another question is about the value when I select the checkbox, as my block as set up as Single, the value equals to 1 when selected and to NUL when unselected. Is there…
-
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) : 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 for your help
-
Use Nexel to refer to previous line value
Hello, I am trying to use Nexel to work on a dataview but cannot manage to figure out how it works, and the nexel documentation on community is not detailed enough. I am trying to replicate that excel formula in nexel, can someone help ??
-
Tree Object
Hi BOARD Team, I created my first Tree Object. The Tree always auto resize itself to the centre of the canvas and make the tree looks small. Is it a way / settings I can force the tree enlarged to fill the canvas ? Thanks Harry
-
Time Conversion🤔
Hello Dear community 👋 In the ETL, how can i convert a date from this format for exemple : /Date(986083200000)/ to this format : 200104 Thank you in Advance 🙂
-
Switch versions
I want to switch from working to final version with just one tap on a label. Can someone suggest me for the same.
-
if-condition in a data entry reverse algorithm
Hi ALL, I would like to write in data entry a value in a column algorithm in the block c and based on the value of the block d I would like block a or block b to become equal to block c. To do this, I enabled data entry on blocks a, b and c. The algorithm in c is "if(d=0,a,b)", and tried entering as reverse algorithm…
-
[BOARD 12.5.1] - Max Entities per row into dataview
Hi, What is the max of Entities per row (par ligne) into a dataview?
-
Data Sources list (latest version)
We are talking with a client who is curious with the data source connectors for Board. All what I know is the picture in attached article(Data Pipeline section) as we can't access to data pipeline due to current license we are using right now. Is there any place or any way that I can find the latest list? Thank you.
-
Is it possible to separate the values of the cube when the same screen is opened in multiple tabs?
Hello. - Hello. As the title says, when the same screen is opened in multiple tabs, Is it possible to separate the cube of selected values used in that screen? Example: "DisplayEntity" member =A,B,C,...,Z,not selected "parent1" member =A~G,H~N,O~U,V~Z,not selected "parent2" member =1,2,not selected Relationship: child…
-
[Board 12] - ETL concat String
Hi, Is there an ETL function to concatenate string data format into the Data reader ETL ?
-
[BOARD 12.5.1] - CREATE DATABASE into CUBE via RDB
Hello, Where can i find a manual to explain how works the button: CREAT DATABASE into the Cube creation via RDB during the Mapping step:
-
[BOARD12] - FastTrack issue with SQL - ODBC
Hello, We receive a page with no data when we try to use Fast Track for MS SQL Server 2017 via ODBC. We did some test with other sources and it works (Ex: csv files). Do you have any idea how can we fix this issue?
-
Connection to Google API
Hello, I wanted to get data via API from a Google form. I set everything up in Google and with postman it works. However, when I try to establish a connection in Board I always get an error. My problem is that I do not know where to place the JWT or which settings need to be taken to get the connection via service account.…
-
[Board 12.5.1] - FastTrack since MSSQL Server View
Hi, Is it possible to do a fast track from a MS SQL view? Il only find all the table into the combo box.
-
Master Layout - reset upon screen refresh
We are currently migrating from Version 10 to 12.6 and found that the master layout is reset upon screen refresh in B12 - which was not happening in B10. As we are using calculations on these screens, the screen refresh is needed in any case. It is quite annoying selecting the same entity member over and over again, after…
-
Move specific screens from one datamodel to other
Hi Is there a way to moye specific screens from one data model to another data model? The data models are on the same server. We have build some screens in a Capsule for data model A and want to move some to capsule for data model B. The capsule snapshot does really do it since in this gave in whats to level B with…
-
Numeric cubes only in double
Hi, A long time ago I received the following advice: only use "double" cubes. Loading values between int and double, or single and double types could be buggy and fail unexpectedly. Is this still advice we should be following? I have been creating all my numeric cubes as double types, even the matrix cubes that are always…
-
Data view formatting
Hi, I want to format the heading of a Dataview and a I don't find how to do it: I want to get all the blue headings from the below screenshot in green. I have tried to do it through the Block Format but I could only modify what it already appears in green. And I also tried to do it thought the Templates but I could only…
-
Unexpected behavior when setting up database security
Hi, We are trying out a new database security setup at a client. For now, we are adding security on one hierarchy, cost center lv0-3. Our security cube has the Lv0 entity, and has user. In the custom selection script, we have Select User = @User. This ensures that the system always only looks at the security set for that…
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…