-
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)%
-
[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…
-
"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
-
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…
-
In capsule, how to restrict procedure launch for read only user ?
Hello, In BOARD we have a P&L capsule shared between 2 user groups Controlling user that are allowed to launch procedure that may change data like clear data / reload data from ERP / launch allocation Reporting user that should only have read only access. They should not be able to launch procedure. The issue is that "Read…
-
How use an algorithm picture on parents aggregation
Hello, I would like to use my algorithme picture on parents aggregation, When I use it it's working on children but not on parents. Have you a solution to display the picture on parents ? Best, Shanèse Rouabah
-
How to manage three different rules in the same layout
Hi, I'm in the situation described by the title. The rules are based on the same entity, but I want to use them in the same layout due to the type of calculation the user selects. Have you got any tips?
-
Programming language
Hi, which programming language was used to program the Board 12 Engine? C#? And which web framework was used to implement the Board 12 clients for the browser?
