-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
Error when pasting Excel range on BOARD Dataview
Hi, We have a Dataview in BOARD, we download it to Excel and we modify a cell of the Table. Then we select and copy the whole table, and when we paste it back to BOARD we get this error message: "An unhandled error occurred (cod_ref:1714663289020)" Do you know what does it mean? How we can do a complete paste of the table…
-
The Font Issue in DynaWrite in Version 12.5 and Lower
Hello, I created a RTF cube and use date entry to edit it and use DynaWrite to display the content of the RTF cube, and it looks like the font for bullet point and numbering are different. If you use bullet point, then the font is set to Time New Roman, and if you use numbering, then font is set to Open Sans which is the…
-
Sorting entity members data reader not working ?
Hello I have an existing entity with 300 members that I woud like to custom sort (currently not sorted) . So I have enabled the custom sort options in entity options. Then I have created a datareader with option "sort entity" and in the file txt file I have sorted the members as expected. After running the datareader,…
-
Error when export Dataview to a flat data table
Hi there, I faced an issue, when exporting a Dataview to a flat data table. When I try to export the table I get the following message: Object reference not set to an instance of an object The reason of this message seems to be that I use a dynamic selection for year, and at the same time I included a pager with the entity…
-
B12 Excel Download - workbook in faulted state
We found that users opening downloaded Excel files (option "Microsoft Excel Workbook for BOARD add-in") always receive an alert that the workbook is in faulted state. The only solution to prevent that, is to install the add-in on the user's PC, even though they are not using BOARD at all. Is this a known bug and will that…
-
Looking up description from parent entity
I'm reading in SKU with a description. A child entity of SKU is "single unit item" since we sell some items individually, and sum in bulk packs that have a separate item number. Our ERP doesn't store a description for this single unit item. How can I read the description from SKU into the description for single unit item?…
-
Export Powerpoint
Hi, when I export a presentation of multiple slides to powerpoint after every slide from the presentation it adds 1 slide for Current select and URL. how can the be turned off?
-
Blocking Data Entry in Grand Total, while leaving data Open for Subtotals in DataView ?
Hello everyone, Any tips on blocking data entry for grand total but keeping it open for subtotals in a DataView? Thanks!
-
Vertical % on Dataview
Hi, can I somehow use vertical % ignoring subtotals on a dataview? Thanks
-
About data view color settings
Hello I would like the text color to be red if the value in the data view is negative, and black if it is greater than or equal to 0.With the settings in the attached image, the 0 character color is gray instead of black, and the negative numbers are also light red and dark red. Ideally, I would like to display numbers…
-
"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…
-
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?
-
Drill Anywhere configuration on block in layout in 14.1
Hi, I must be missing where it change in the UX but I can't find how to do the same option as bellow in 14.1 I can find the option for same tab or for Dynamic screen? And my test capsule I've migrated has lost the screen it was referring to and everything is pointing to home.
-
User Locked Out Time
How long are accounts locked out for by default?
-
Showing Total year and ytd values on same screen
I want to create a capsule screen where the user can see total year sales for prior years along side the previous month year to date sales for prior years. I can easily get the total year sales by pulling in a reporting cube by year, and detailing the block by year. I am struggling on the best way to get the previous month…
-
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