-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
Suggestions for Chart and Data View Enhancements
Hi Team, Here are a few suggestions for improvements in the Charts and Data Views: Additionally, when the "Auto-Range" feature is enabled for the axis, the value range adjusts correctly, but in some cases, markers get cropped. It would be helpful to either adjust the auto-range logic to ensure markers remain fully visible…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Adding Blank Rows that Mesh with Block Format
Hello! I'm working to enhance our current P&L report to improve vertical readability. I'm doing this by adding "Blank" members to the entity used in the by row configuration underneath key metric milestones (ex: Total Rev, Total COS, GP, etc.) No problems there; However, the formatting is clashing with block format since…
-
Dynamic Selection on a Layout
Hello everybody, I'm using Board 14.1 and I have a question concerning the dynamic selection. I have 2 flex grid in 2 tabs on my screen and I would like to make a dynamic selection on these 2 flex grid. A dynamic selection on the screen is not an option because the dynamic selection for the 2 flex grid is different. Thank…
-
Entity Editor
Dear all, I would like to have an entity editor and a data view - where I enter assignments between the members of two entities using the data entry function - on the same screen. The entity members that are created in the entity editor should also appear on this data view. However, the problem is that only the members…
-
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…