-
FlexGrid - Date cubes as column labels in pivot mode and automatic time-grouping
Hello, currently FlexGrid does not recognize date cubes when they are used as column labels in pivot mode. This is a date cube (column "Input Date") in flat mode and it is fine: This is the same date cube used as a column label in pivot mode: Even if it is a 'date', it is not recognised as a date and has no native temporal…
-
Changing font color and size on B14 screen.
Hi all, B14 screen shows light grey font in some place. They are small and difficult to read for the user. Would you consider any function to change the font property or dark mode for easy to read depend on the user? Masa,
-
Error handling of "DR" and "Procedure"
Hi all, Please merge this idea if we already have. I cannot find same one. Board cannot detect the odbc/ole error even if SQL Error log we have when error occurred. All most of customer need to error handling for their system. In their system, Board is a part of whole system and they need to retry when they have the error…
-
Analytical Functions
Hi Board Team, I found the following calculation in one of the procedure. I understand From and To is used define the time range. But I cannot understand what Yearly Rolling Periods and Last Selected Period pointing to. If we use today 9th July 2024 as an example, which month range will the following pointing to? Thanks
-
Comeback of role up Cube
Rolap cubes would be a great way to have real time data in your DWH with the advantage that you can have audit trails (timestamp and username can be automatically written into a table), but: Performances for bulk data entry are not acceptable They cannot be used in dataflows reliably These two issues cause the ROLAP cubes…
-
Cloud Admin Portal: Filter scheduled tasks/Export tasks to Excel
Would be great to be able to filter scheduled tasks - as this list gets very large e.g. filter by datamodel, frequency, time (sort by day/time), etc. And/or export the list to excel, so it can be documented or analyzed better.
-
Allow setting "Non-Exit" of procedure when cancelling interactive selection
Hi team! The idea is very simple and practicable for control flow in Board procedures: When using "interactive selections" in procedures, it would be highly beneficial to developers to have the option to intercept a user cancelling on "interactive selections" - in addition to the current default and only option of exiting…
-
Include Temporary Cubes in Impact Analysis or other way to monitor
When trying to reverse-engineer ETL flows developed by someone else or to analyze the impact of a change to your data model, you are not able to reconstruct the full workflow as the temporary cubes are not present in the impact analysis. Please include them. In general, the impact analysis is very heavy to load and on our…
-
Code Interface for procedures
The no-code interface of Board is a limit whenever you need to apply the same changes across multiple procedure or even in the same procedure (if it is a long one). Moreover, advanced users who are familiar with coding would benefit from having access to the code directly. Going forward, AI Copilot-like features that…
-
Loop Function
Currently, there are only convoluted and not user friendly way to loop through a non-time dimension when running a procedure in Board. This is a standard functionality available in almost every other tool that allows ETL by writing one or two line of code. Please create a new procedure step that allows to loop through a…
-
Column Headers To display Year/Month/Quarter
Column Headers To display Year/Month/Quarter they point to when used with Previous Year or Period offset Dataview Functions Scenario Time entity is used on column axis and multiple Cube blocks are added to dataview. Some of them refer to previous or future periods. Often, dataview Functions are used to refer to other time…
-
Cloud config parameters view
Hello, even if it's expected that all parameters are properly managed by Cloud team it would be useful for the customer be aware of current configuration for his installation and related impact. My idea is to have in the cloud admin portal a table reporting current configuration with an explanation of the impact of each…
-
Cloud task Scheduler - timeout option
Hello the task scheduler available in cloud portal administrator have not some options normally available in win task scheduler, like the timeout or the capability to run manually a task. In my on prem environment I can choose to stop a task if not completed after e.g. 30min or 2-2-4-8 hours.. In the cloud this is set as 3…
-
Training Environment Board Platform Access
I set up the training environment today, however seeing this error: Any suggestions on how to get connected to training platform?
-
Office Add-In losing layout
Hi, we are using the office add in, in excel to link some of our reports with board directly onto one or more excel files. These excel files would contain more than one tab with reports connected to board. What we have seen is that at random occations our reports in excel would stop updating. When we try and view the…
-
Flexgrid design customization - Need more options for a compact look
Hi all, Context I'm probably not the only one, but I'm missing some design options in the new Flexgrid object, especially regarding cell sizing. Indeed the default design takes too much space, with very big cell margins above and below the data. Reducing font size does not really solve the problem. Compared to an…
-
Named parameters
IDEA The ability to set up named parameters. These could be numeric / text and be used throughout the application. These parameters are then available to be retrieved using the name of the parameter enclosed in braces/curly brackets {parameter_name}. EXAMPLE A parameter could be set that defines the button background…
-
How to display the results of a text type algorithm right-aligned in a data view.
Hi. The part circled in red below is the result of the text type algorithm. Even though I set the column to be right-aligned, it is displayed left-aligned. Is there a way to display them right-aligned? Thanks in advance.
-
B14 : Layout Editor Small Improvement
In the layout editor, when clicking on "Axes" : It would be nice for the left panel to swtich to "Entites" as it's the only things that you can't drag and drop at that time and at the moment you have to do an extra click. Small annoyance for experienced user and not quite as user friendly as it could be for new users.
-
Custom link pinned improvements
Hello, Actually, we can pin the custom link in the top bar (Administration/Appearance), only at the left of it, near the logo. It would be better to be able to choose the location we want. In addition, being able to choose font and font-size would improve the general appearance and visibility of this link.
-
Level 100
Hello everyone, I need help with data reader. My data reader seems to be reading the data source properly, but the data is not being populated in my entities/cubes. Any hints will help Thanks
-
Wrap Text
Hi, Is there a way to wrap text in a data view? Thanks maik
-
"Export to flat data file" option when using SendTo/Subscribe/Broadcast procedures
Hi, everything is in the title, most of our users export to Excel using the "flat data file" of the board add-in even if they are not using the addin. However this option is not available in the SendTo, Subscribe or Broadcast setups, which is limiting a lot the use of these functions. Can you please add it ? Thanks, Etienne
-
How to hide a button in a Capsule Home screen
Hi, We have some buttons in the Home screen of a Capsule, that need only to be visible to few users. For that we have created a cube, CLC_HLP_0284_User Visibility. Authorized Users show 1 in this cube. This cube has the User dimension which is the user entity in the DataBase. The user of the platform (the logged user) is…
-
How to update GCR version (1.0.2 vs 1.0.3)
1. Abstract The goal of this document is to provide guidance on how to update Board GCR from GCR 1.0.2 to GCR 1.0.3. if you need to upgrade from previous GCR versions take Into account previously released guidelines. 2. Context GCR version update is mostly managed through Board Data Model Transporter Package. below you…
-
Use Broadcasting Actions to email to non-BOARD user email address
Hi Board Team, Can I use this Broadcast to email list Action to send PDF report to non-BOARD user in our organization? If not, then will this Advanced Broadcast work if I create a cube of email list (some emails are not BOARD users, but from the same organization). Thanks
-
Data Picker Tool
Hello, We would like to know more about the Data Picker tool. Specifically as it relates to mapping a gl account to two different categories within another entity. Please see below for a detailed example of what we are looking to achieve using the Data Picker tool: We have 2 related entities at play. One entity is our GL…
-
Data Entry performed - make the information about pending changes available to developers
The trigger action on a DataView can call a procedure to process any changed values—but, this will allways process the information row by row, meaning that the trigger action will be performed for each row in the DataView that has been altered, and this can be pretty time-consuming. You can, of course, use a label or…
-
Smart Input Object: error message
Hi, We have set a Smart Input Object to load data to a cube. When we paste values and click the Save button we get this message in the screen: And although values look fine just like they had been loaded correctly we don't feel confident about it. We can not discard that this causes an issue in the future. Do you know the…
-
How to apply Dynamic selection of yesterday to Layout Block?
Hi BOARD Team, BOARD system had a default entity for Day. How can I use procedure to make a dynamic selection of Yesterday and assign this selection to a Layout Block? Thanks