-
How block in layout display decimal value when tagged as Numeric vs Text
I am working on 14.2 and have come across a strange behaviour how the system is displaying decimal values when a block is tagged as Numeric vs Text. The Layout has YoY Change% displayed as 3 blocks, one is marked as Numeric while the other is marked as text. The block marked as text changes the decimal point to a comma.…
-
Saving @Selection_Ex() result
Hi all, We are working on new functionalities for cost allocations, where we will need to store the explicit selection made by the user. This selection can be done on 1, 2 or 3 different trees, containing up to 30 entities each. I don't want to store the resulting selection at the lowest level of the allocation driver…
-
How to disable on Alert formatting on Total row
Hi BOARD Team, I applied COLOR ALERT on a data block. It works fine on each row. However, it is impacting the number showing in the row total. Anyway I can force the row total as BLACK? Thanks
-
Quick layout : option to include automatically all relevant dimensions
Pain point: currently, configuring the quick layout function requires activating it on the layout, then adding all relevant entities. When a new entity is added to the data model, we need to go in all relevant reports, and add it manually in the quick layout setup. It takes times and it means very often we have consistency…
-
Expanding a column for a drilled Data View
Hi all, after drilling in the main Data View, I'm left with another Data View that has an "collapsed" column (screenshots below) If i manually expand the column and then save, once i go out the layout the column remain half hidden. I don't seem to find any option in the settings to expand the first column. How can i make…
-
Grouping of (data)blocks
Hi all, It would be a great enhancement if we could group blocks of a data view (headers). For example, blocks A to D could be related to MTD (Month-to-Date) and blocks F to I could be related to YTD (Year-to-Date) → instead of using static labels, or enriching the block headers with the Prefix MTD/YTD. This would be very…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Master Layout - Select dependancies
My idea: In the same way you can choose which dataview synchronize with an other for scrollbars : it would be nice if when enabling master layout you could set for every object which dataview is the master. And therefor also enable multiple master object Use case : My customer has a screen split in two visible section,…
-
[B14 Layout] extend multiple block configuration functionality
Hi all, the multiple block configuration functionality in B14 is great. Unfortunately, the options "alert" and "refer to" are not available. They are frequently used in multiple blocks with the same settings, it would be great to have them as available options. In the release notes for 14.1 it says which I would interpret…
-
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…