-
How to see memory consumption of each DB on the server ?
Hello, On our local server, BoardEngine is using 30go of RAM and we have 15 DB How can I see how much memory space is allocated between each DB ? thanks julien
-
Migration to Board 14.1 - Difficulties I found
Hello Community, Lately, I worked on the migration of my main customer's application from Board 12.6 to Board 14.1. Naturally as in any migration, I ran into some issues I would like to share with you. I would also like to know if the rest of the community is also migrating to Board 14.1 and the eventual problems you…
-
Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
-
Flex Grid and wrap text in columns
Hallo everybody, in a Data View it is possible, to wrap the text in a column, so you can use a small columns width. Is this function also available in the new Flex grid object? Best wishes Thomas Schendl
-
AI Integration API with OpenAI
Hi community, To enable and empower my data with AI in board, I am looking for a step by step guide on how to set up an API with OpenAI to analyse my data with the big language model ChatGPT and get the text response in board (text cube). I know it's possible, but I haven't found a guide on the forum on how to set it up.…
-
How to get just the date in ETL on data reader
Hi, I'm trying to find a difference between a date when and item is released and today on my data reader. I have the release date pulling from an API source. I'm using the =today() formula to return a day on an ETL but it's pulling back the date and time stamp like this: Then when I subtract the two I get a really off…
-
Add Filter to a screen
Hi all, I have Screen1 and Screen2, in which i want to apply the same filter for Entity. Through a procedure I managed to apply the same filter (that we can call "Deal") to both Screen1 and Screen2, by selecting it from the Screen1. Keeping in mind that Screen2 is already filtered for "month", when i apply the filter…
-
Configuring Entity Selections to Apply Only to Charts, Not Data View Grid
Hello Team, I have a page with entity selectors, corresponding charts, and a data view. However, I need these selections to apply only to the charts, not to the data view grid. In other words, they should not sync with the grid. How can I implement this?
-
Dynamic Go to Screen on a dataview button
Hi I am using Board 14.1 and having trouble using a data view to select a screen based on a block. I'm looking for the dynamic Screen option but it does not appear for, have I missed a step, they are identical data views. As seen as Board 14.1 As seen in Board 12.5
-
dataflow problem
Hi All, i have a problem with a calculation between 2 cubes First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B. the Algorithm use the cube A and B explained before. The reason of…
-
New capsule not showing in folder security
I created a new data model and capsule in our sandbox environment and moved it over to production via the cloud admin site. I can assign the data model to different user roles and they show up for the user (Powerusers can see it in the data model section). However, the new capsule won't show up under folders for these same…
-
When procedures triggered from screens fail you 😯
We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…
-
Export screen data to xlsx
Hello, I am currently experiencing an issue with exporting the Data View to Excel and would appreciate your assistance. When I select the "Standard Microsoft Excel Workflow" export option, the generated file maintains the exact format of the Data View, which is ideal for my needs. However, I lose the formulas required to…
-
Board logs out automatically when inactive
Hi, we are using Board version 12.6, revision 0.2.88217. Board does not run in the cloud, but on our own server. We use IIS. The following is stored in C:\Program Files\Board\Board Server\BoardEngineParams.xml: <EnableSessionExpiration>false</EnableSessionExpiration>…
-
Adding Comments or Highlights in Data View
Hello, I was wondering if it is possible to add a comment or note to a cell in Data View. Moreover, is there a way to highlight or change the color of a specific number within a cell ? I have been searching for a way to achieve this but have not found any clear instructions or options in the documentation. Thank you in…
-
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?
-
How to export the list of BOARD capsules with folders and screens?
Hi BOARD Team, During our development, we have created too many screens. Now we are trying to do a tidy up and remove unnecessary screens. Is there a way I can export the folders and screens name into an Excel list? Showing Folder and screens under each folder? Thanks
-
Board restarts after a short while
Hello, In our organization we experience that users are kicked out of Board after a short period. It can be both when Board is not in use, and when we are working in a capsule. Board restart and we are thrown out of the capsule/ screen we are in and Board sends us back to the main page in Board. Does anyone have a solution…
-
IIS - What is to dow with an Update to a new Version from Board?
Hello all, we have installed the IIS from MS instead of the Web Server from Board. What is to do for an Update from Board to a new version, e.g. to the new Version 14.1.0.1.233740? RegardsStefan
-
Procedure to populate cube
Hi all, i just want to ask how to do the following thing: basically i have Cube A (1 dimension as Entity ) and Cube B ( Month dimension) i want to create a procedure that can use Cube A to populate Cube B based on a month selection. I hope you can help me with this problem. Best regards, Andrea
-
Total by doesn't work
Hi there, I try to create a data block by country with the Total By setting. Example for Belgium 2 records Total in block C is 79.175 Total by Country block d shows millions. example for Denmark 1 record Totals aren't matching Any idea why?
-
CLEAR RDB-cube?
How does the "Clear " function work on an RDB cube? Will the table be cleared in the data warehouse if we use that function?
-
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
-
Single Sign-On email
When SSO is enabled for users. When adding a user in IDP with SSO authentication do they get an activation email? Best Regards Peter
-
Rule with datapicker by column
I am trying to apply a rule on entity displayed by column. It doesn't work if I use a datapicker in the rule. If I instead use the entity by row, the rule works as expected. The question - can you not use datapicker in a rule if the entity is displayed by column?
-
Closing / Locking and Unlocking Periods
HI, We recently completed the implementation of Board's Consolidation module using the latest version GCR. We run into some issues when closing prior periods wherein it prevents the 'Run Conso" command from executing. The only way around that we found is to unlock all locked periods, run conso and then relock the prior…
-
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
-
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
-
save quarter value in a monthly cube
Hi all, I have a cube with a Quarter dimension, and I want to transfer the value to a Monthly cube, specifically in the last month of each quarter. I tried with the dataflow but each month of quarter will be populated. I hope you can help me Andrea
-
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…
