Platform Q&A
This forum is dedicated to Board platform questions, generally applicable to all members.
Please select 'Yes' if a response answers your question to better identify possible resolutions.
-
Error that table borders are not displayed
Hello. I have a problem where some of the borders on the left side of the data view I am creating are not visible. Please see the attached image for details. The left border is not displayed for industries colored in yellow. In another data view with the same template and settings, the borders are displayed correctly. For…
-
Font Selection
Hi, how can I adjust Board to use font Arial instead of Open Sans by default? Thanks Maik
-
Show all values in chart labels
Hey, is there any chance, that we can tell the chart to show all the values of each series regardless of its size? Here is an example:
-
About block type
If not a single column is displayed, the header color set in the block expression is not applied. Note that the header rules set in block style are applied. I want to apply the header color that is set in the block formula even when not a single column is displayed. The red frame in the image below reflects the green color…
-
Need to compute percentiles. How to do this in Board?
Hello, For a given set of values we need to know the percentile which corresponds to each value. Cumulated Vertical % does not seem to help but I could be missing something. Say I want to know whether a given cube value is in 75th percentile or better? Thank you
-
Is there an ETL function for counting row?
Hi, I've got a cube that requires a line reference number as a dimension (from the load table) - I'd like to add a row counter to the ETL in the data reader where this cube is populated, but I'm not sure what the function would be (or if one exists). Does anyone know what the function is or a workaround? Thanks!
-
Yearly Cumulated Value + Detail by Year in block
Version 12.6 We have a MTD cube, with a selector of generic fiscal period (1-Jul, 2-Aug, 3-Sep…12-Jun). I have a block with MTD value with "detail by fiscal year" set and "Tme function>Yearly Cumulated Value (fiscal years checked)". No time entity in rows or columns. The MTD cube contains 6 years - all years are 0 amount…
-
Input in Thousands - Decimal issue
Hi, We have a Dataview to input plan in Thousands. The column on the right is the input one. And the left one, which usually is hidden, is a the real amount. The right one is the left /1000. And has an invers algorithm, the left is the right x 1000. The issue which we don't understand is the following: we add 10 units on…
-
Error On-screen selection
Hello, I am having trouble because even though I have narrowed down the entities displayed by screen selection, entities that are not selected in the data view are also displayed. There is more than one user experiencing this phenomenon, and even within the same capsule there are DataViews with and without this phenomenon.…
-
Split and Splat doubt
Hi, I have a dataview where Quarters are displayed in columns. In Q2 only two months are open. This dataview has a locking condition based on a cube that points the months that are open I have realized that when I do a input on Total Year the amount is spread on the weight of full Q2 and then this amount is spread on the…
-
Error when changing entity relationships
Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings. ① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.) ②I created another entity named "Last…
-
Error when pasting Excel range on BOARD Dataview
Hi, We have a Dataview in BOARD, we download it to Excel and we modify a cell of the Table. Then we select and copy the whole table, and when we paste it back to BOARD we get this error message: "An unhandled error occurred (cod_ref:1714663289020)" Do you know what does it mean? How we can do a complete paste of the table…
-
The Font Issue in DynaWrite in Version 12.5 and Lower
Hello, I created a RTF cube and use date entry to edit it and use DynaWrite to display the content of the RTF cube, and it looks like the font for bullet point and numbering are different. If you use bullet point, then the font is set to Time New Roman, and if you use numbering, then font is set to Open Sans which is the…
-
Sorting entity members data reader not working ?
Hello I have an existing entity with 300 members that I woud like to custom sort (currently not sorted) . So I have enabled the custom sort options in entity options. Then I have created a datareader with option "sort entity" and in the file txt file I have sorted the members as expected. After running the datareader,…
-
Error when export Dataview to a flat data table
Hi there, I faced an issue, when exporting a Dataview to a flat data table. When I try to export the table I get the following message: Object reference not set to an instance of an object The reason of this message seems to be that I use a dynamic selection for year, and at the same time I included a pager with the entity…
-
B12 Excel Download - workbook in faulted state
We found that users opening downloaded Excel files (option "Microsoft Excel Workbook for BOARD add-in") always receive an alert that the workbook is in faulted state. The only solution to prevent that, is to install the add-in on the user's PC, even though they are not using BOARD at all. Is this a known bug and will that…
-
Looking up description from parent entity
I'm reading in SKU with a description. A child entity of SKU is "single unit item" since we sell some items individually, and sum in bulk packs that have a separate item number. Our ERP doesn't store a description for this single unit item. How can I read the description from SKU into the description for single unit item?…
-
Export Powerpoint
Hi, when I export a presentation of multiple slides to powerpoint after every slide from the presentation it adds 1 slide for Current select and URL. how can the be turned off?
-
Blocking Data Entry in Grand Total, while leaving data Open for Subtotals in DataView ?
Hello everyone, Any tips on blocking data entry for grand total but keeping it open for subtotals in a DataView? Thanks!
-
Vertical % on Dataview
Hi, can I somehow use vertical % ignoring subtotals on a dataview? Thanks