-
How to see detailed Totals when you have two dimension on rows
Hi, We have a Dataview where we have two entities on rows: Region and RL, like follows: The Total row adds all the rows, which is OK for the region but has no sense for the RLs. Is there a way that I could have the Total region detailed by RL? Thanks
-
Retrieving the data model from Board into the Power BI
Hello ! Dear community, I would like to ask you about your experiense of retrieving the Board data model to use it after in Power BI. Because, as for now, in the Board manual, I've found the instructions about Power BI add-in, which allows to access to the Board Presentations only. Thank you in advance !
-
VBA integration with BOARD Using the Excel Add-in
Hello, I'm trying tu use VBA to automate a connection with the BOARD tab in Excel. I found a manual with macro code sample, but it doesn't work in my case… Sub DoConnect() Dim addin As Office.comaddin Dim automationObject As Object Set addin = Application.COMAddIns("BoardExcelAddIn") Set automationObject = addin.Object If…
-
V12 - Smart import & max items
Hello everyone, As a neophyte, I am currently experiencing a few problems. Indeed, most of my models are still on a pre-V12 version and I'd like to understand the advantages of the V12 on certain points. Optimization with Smart Import in Board V12: What are the best strategies for taking full advantage of the "smart…
-
Zero values in charts
Dear Community I have a chart with development of KPI over months. The user has the possibility to select different years. The Serie is plotted as a line. Now I have the problem, that when the values of past years is zero, the line has a break in between and the chart is strange. so I want to deactivate the "zero value"…
-
[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")
-
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…
