-
Add in "Layout settings" an option for the user to select how to display entity members.
Hello @Product Management Team , I would like to share an idea from a customer that could be helpful for dataviews. I don't think I found another article with the same precise request. Functional requirement and known limitation : Let the "User" visualize the entity members "by row" (or "by column") with a different…
-
Enable Refresh MS Office Files procedure action (disabled from B11)
I would like to recover the Refresh MS Office files that was available in previous Board versions (till B10, it was disabled when B11 was released). This action was used to refresh MS Office files in a specific location in the server, which was very handy to schedule an update of a set of files that contain Board layouts.…
-
Excel Add in - Error Messages
We sometimes get this error message when trying to refresh Excel Layouts: This user is not authorized to access the Board Server. Passwords are case-sensitive. We have found that sometimes this has nothing to do with the user setup/security but that the data model has been updated so the Layout is now out of date and needs…
-
Block Configuration Pane Behavior
Current Issue: After clicking "Save," the pane remains open, requiring developers to click a separate "Close" button to return to the layout. Impact: While this may seem like a minor issue, it results in an extra click each time changes are made. This can accumulate significantly when working on larger layouts. Proposed…
-
Entity Removal in Layout Axis Configuration
In Board's layout axis configuration, removing multiple entities from an axis can be cumbersome due to the inconsistent positioning of the "X" button used for removal. Current Issue: The "X" button is located on the far right of each entity. Its position shifts based on the length of the entity's name, making it tedious to…
-
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…
-
Filter Option in Layout
Has anyone encountered issues with the filter in the layout? I'm tryng to filter with min value >1 in some Cube value but report show all items also with zero value. Thanks
-
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
-
Show certain layout blocks as single column, even with entities by column
Sometimes you'd want a certain block displayed as a single column an others displayed per element in the entities by column. This could for example be a budget for the year and than the actuals by month. The way we have always achieved this is kind of an awkward work-around. For the block that should be a single column we…
-
Hide blank records when Data Blocks alignment is Vertical
Hi Board Team, Normally, we will use the FILTER to hide blank records. But once I changed the Data Block ALIGNMENT to vertically, the filter is not working any more. How can I hide blank records when Data Block alignment is vertical? Thanks My Axis properties are NOT selected as Show all. Thanks a lot
-
B14: Enhance Debugger options
Hi Team, I was used to work with layouts in the debugger the same way as in a DataView Layout on the screen - adjusting column widths, exporting to XLS, searching for cubes to add as block into the layout… This is the behaviour in B12 whereas B14 behaves pretty differently in those cases: You can't export, you can't edit…
-
Improve formatting capabilities for Unbalanced Hierarchies in Row Templates
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Struggle to understand NEXEL
Hi BOARD Team, After reading through the manual, I still cannot understand how NEXEL reference works. In our production system: Active cell is 5.6. Formula is =[@b;-1;*]/AVERAGEIF([@b;-5;*]:[@b;-5;+12],">0"). My understanding: [@b;-1;*] pointing to 7,162. Is it correct? [@b;-5;*]:[@b;-5;+12] pointing to Demand layer for 12…
-
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
-
Custom drilldown layouts not working in B14
I've discovered that the newest version (14.1) appears to not preserve custom drilldown layouts in the same way that B12 did. In B12 I was able to "Drill anywhere" on a column and then edit the layout in the popup, which was very useful for displaying data which was otherwise too big for the original layout (comments,…
-
Grand Total Group by format
Hello, It would be helpful if we could, in a layout, change the format Color and Font) of the Grand Total Group by. For now, it is not possible to identify easily the line (see capture attached) when the groups are collapsed. Thanks
-
Prevent Objects from loading without ATO
Dear Community I have a screen with 3 Data views. First two dataviews show aggregated values. Users can click on these values and afterwards in data view 3 there is a detailed data. Now I want the third dataview only load when an entity has a number that is small enough. Has anyone any Idea how to set it up without ATO? I…
-
Add layout to the Menu object
Dear community, I believe it would be a great addition to Board if the Menu object was improved to allow layouts to be configured on it. Not to display information, but for the layout's blocks to be used in the Dynamic Options of the object. This addition would allow developers to customize the Board solutions, for example…
-
Remove AVG abbreviation in front of the value
Can we remove AVG abbreviation? If user would like to differentiate from the Default "Total" Summary view, user can always use the column head to specify it is AVG. Thanks
-
Layout: add functionality "copy/paste data block"
Hello, As far as i know, it is not currently possible to copy one block of a layout and paste it right away in the same layout. in older versions of Board, "dragging" a block and dropping it on a line below in the same layout was copying the block. I can't find this in Board 14.1. The feature is a time-saving one for Board…
-
How to remove the AVG letter from the table?
Hi BOARD Team, Under Configure Layout, I calculated a data block by using Average. In the table, it will always show the AVG at the front. Anyway I can remove the AVG letter from the table. I only want to display the number, but not those letters. Thanks
-
Show Currency/Unit of Measure next to values
we are having since years requirements that we want to show the currency next to a value or the unit of measure next to a quantity. e.g. Material xy —> purchasing order quantity 1.000 M (meters) No consultant was able to show me a solution so far. But I know this working in other tools (e.g. QlikView).
-
An Extended version of the Board Substitution Formulas
Board offers a diverse array of functionalities and features, positioning it in a prominent and distinctive position within the competitive landscape that spans both Business Intelligence (BI) and Corporate Performance Management (CPM). One of the standout features that distinguishes Board is its Substitutions Formulas,…
-
Add ability to multi-select columns in Block Format
Block formatting individual columns is a very time consuming job, and this would allow you to speed up the process a lot faster. You can currently multi select on the different rows, but it'd be very beneficial to CTRL+Left Click on the columns to format them together too. There are data views with over 100+ columns here…
-
Dynamic and Cube-based Layout Selections
On searching the Idea Exchange there is an old suggestion: "Dynamic Selection within Layout" from 2018 by an Unknown contributor. The Idea received 47 votes - as follows: "A good improvement would be the chance to set up a dynamic selection within Board Layout. This way you should be able to create different infromation…
-
Use of Rules in Layouts
The limitation by using rules in layouts should be elimiated since it limits the use of quick layout massively. In our case we calculate a %-KPI which can not be safed in a cube and must be calculated on the fly. Using the quick layout and having the rule set on the cube not only leads to not calclulated KPI´s but also…
-
Copy/Paste Individual blocks from a layout
Hi, It'd be useful to copy and paste individual blocks from one object's layout to another, carrying forward any block references/functions applied to that particular block. This would remove the need to duplicate the same work across multiple objects requiring that same cube; making it more efficient to develop objects…
-
activate Layout for Panel Container
The Panel Container is great for grouping other Toolbox-items like Label, Button, Dataview and so on. The Expander Container is a good choice to store many items on limited space. Together they are very powerfull. Espacially on admin-screens and Dashboards. I miss the Option to hide a panel container inside a Expander…