-
Display Cube Dimensions in Dynamic Selection
Hello Board Team, I’d like to suggest a UX improvement for screens that use dynamic selections based on a cube. 👉 Current limitation: When using a dynamic selection linked to a cube, it’s currently not possible to see which dimensions (entities) are used in that cube from the screen configuration. This makes it harder to…
-
Option to hide automatically lines without values in a dataview
Context Very often in a dataview, we face the following situation: * we want to display a P&L value as a % of sales, in a separate column. * to do this, we configure a hidden columln with a "ReferTo" option on the Sales. * then setup a column with a/b, to display the %. Issue In this kind of situation, if a P&L line is…
-
Simplify Selection of Descendants in Unbalanced Hierarchies
Currently, when working with unbalanced hierarchies in procedures, there is no simple way to select descendants of a parent element in a dynamic way. This limitation creates a lot of extra work during integration and makes maintenance difficult, as developers have to rely on complex and fragile workarounds. A simple and…
-
Automated Email Notifications for Broadcasting Module
Automation is really important these days because it saves time and helps teams work better. That’s why I think it’s sad that customers using the Broadcasting Module in Board can’t get automatic email notifications through API users, Scheduled Jobs, or Batch processes. It would be great to have email alerts sent…
-
Enhancing Generic Entities in Time Range Section
Currently, in the Time Range section of Board, we have the ability to use generic entities to address specific time-related business needs. Some common examples include: YTD (Year-to-Date) Months YTG (Year-to-Go) Months Monthly references such as JAN, FEB, MAR, etc. These generic entities are very useful for standard…
-
đź‘‹ Fixing the article on OpenID for on premise
Hi @Board Community, @Board Support, Is it possible to correct the template openid.config at the end of the article in link bellow ? It's full of typos and not even valid xml (<add /></add>!) and apparently not the right redirect url path too. A ticket was open, but we are currently going by a trails and errors methodology…
-
Add a calendar month entity within the time entity
Hello, I'm trying to add a calendar month entity within the data model properties. Calendar month is an entity which contains (JANUARY, FEBRUARY, MARCH) without the current year written. I mapped all the month to the level below which is Month but the basic relationship functionality does not work properly. I can't select…
-
Restore original screen view after - Apply my screen view -
Hi, any idea who I revert My screen view back to the original screen view? Br, Maik
-
Can we scroll data in bar chart horizontally?
Hi all, I want to know that can we scroll data horizontally in bar chart by limiting the amount of datas let's say total amount of data is 10 data and we want to initiate only 2 data will be shown and the others left we need to scroll it horizontally. Is it possible to do like that? Thank you.
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Drill Through popup : How many rows it can safely handle ?
Hello, Is-there any BOARD tech lead here ? Our users are using the drill through feature towards an SQL server database to see invoice accounting lines on SQL DB. However on some accounts, we have approx. 100 000 lines of invoices to display on the BOARD drill thorugh popup Question : Is the drill-through feature natively…
-
Now is the Time to Build a Centre of Excellence (CoE)
Author: Kevin Gough, Customer Succes Manager at Board and Community Captain Finance teams face increasing pressure to deliver faster closes, sharper forecasts, and deeper insights while managing complex systems like ERP, EPM, RPA tools, and BI platforms. Despite these challenges, many teams still rely on tribal knowledge…
-
FileRead ERROR:File Missing what is the causes of Datareader file missing?
Hi all, I want to know the causes why when I tried to run Datareader manually, FileRead ERROR:File Missing always be shown? I have checked the path is ok. Any ideas about this issue? Thanks.
-
3 Q's with Akrem Abdelhafidh, Senior EPM Consultant
Featuring: Akrem Abdelhafidh, Senior EPM Consultant In this installment of Community 3 Questions, we sat down with Akrem Abdelhafidh of XB4 Consulting to get his thoughts on Board 14 and its exciting features, some pointers on how to ensure success in Board, and Akrem's favorite 'This vs. That' when selecting a formula or…
-
Search function / Excel PlugIn
I want to use the search funktion in the Excel plugin für an entity's ID. Unfortunately, it's 20 characters long. Can I configure the search function so that I get the correct result if I only enter the last digits and not the full 20 digits? Look at the screen shots. 1.) 2.) I get no result :( I'm looking forward to your…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
Getting Started With Board Cloud Connector (Hybrid Data Pipeline)
Abstract Every Board solution relies on connections to external data sources. In this article, we describe step by step how to link Board to an on-premises data source. Context Board Cloud Data Pipeline is a service that allows Board applications to access data from sources that are hosted on a public cloud or on-premises.…
-
Standard colour of label value should have the proper contrast
When creating charts Board automatically takes colours for the different series (which is good, especially as you can also manually change them). However, the values shown from the labels should be coloured in the way that it is visible…in the screenshot below the values in the blue series are not visible - if you hoover…
-
level 200 - module 203 - Build a Screen to visualize the loaded actuals data
Hello, I am having a challenge with previewing data after completing the steps below My preview returns empty. with just product in the first row and total in the second. No other data is present. I suspect that I may have missed a step in the set up of the temp cube, but I struggling to find what it is based on the…
-
UX Improvement Ideas for Selectors
Hi everyone, I wanted to share a valuable piece of feedback from one of my clients regarding the user experience with selectors in Board 14.2 : Item Spacing: The items in dropdown selectors are currently too widely spaced, which limits the number of visible options. A more compact layout would improve readability and…
-
Exclude option on selectors
A little improvement to the selector object would be to always have the exclude button available when the object is on the screen. At the moment, it is only possible to either select (if the including option is enabled) or exclude (if the excluding option is enabled) I would like to decide on the spot if I want to select…
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
-
Representation of a diagram
Hello everyone I have the following initial situation (see also the attachment): I want to create a chart in which I have to expand a cube after an entity, but not the other cubes. I solve this via detail by on the cube in the layout. However, the problem is that I want the values of this expanded cube to be displayed…
-
Java Requirements for Progress On-Premises Connector (OPC)
The Progress On-Premises Connector (OPC) historically included the required Java version bundled within its installer packages. This approach ensured that users had the necessary Java Runtime Environment (JRE) available without needing to manage separate dependencies. However, starting with version 4.6.2, this behavior has…
-
Trigger Broadcasting via API
1) What is your idea? Trigger Broadcasting via an API, using the API User 2) What specific problem are you trying to resolve? We are triggering Board procedure as part of the nightly process that runs every day. The Board procedure loads data from the backend system (that calls procedure via API when the data is ready for…