-
Input by Dropdown issue
Hi, I have set a dropdown input in a cube but I'm not allowed to save the data. Once I've done the input the new selections is displayed but the text is not displayed in red and I can not see the Save check box icon on the Context menu, although it is abilitated. If I click F5 I get the previous value. What I'm missing?…
-
Transporter Tool
Can we use the transporter tool for transferring the metadata between data models in same server?
-
how to trigger a procedure from dataview cell based on another datablock
Hello, I know from the Board manual https://www.boardmanual.com/board14/capsules/screens/objects/data-view/using-a-dataview.htm#data-view-drill-anywhere that i can trigger a procedure from a dataview single cell. Drill-Procedure If a Drill-Procedure has been configured on the Data View, select a cell and click the Drill…
-
Board server cannot start because the user storage is corrupted or not readable.
The question is related to the Board Engine - however it may possibly be related to the User folder. Unfortunately, we are unable to diagnose and can use assistance at this point. Three business days ago, the system administrator freed up 80 gb of data on the server because it was full. He removed old database backups.…
-
dataflow with factor cube having less dimensions than target is not considered in text algorithm
Hello, I try to transfer text comments (no rich text) from one cube to the next one "filtered" by some matrix cube. This picture shows the dataflow factors (two factor cubes, one target cube): The target cube has 8 dimensions. These 8 dimensions are partly present in the factor cubes: cube a: 7 out of 8 dimensions cube b:…
-
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
-
About data view color settings
Hello I would like the text color to be red if the value in the data view is negative, and black if it is greater than or equal to 0.With the settings in the attached image, the 0 character color is gray instead of black, and the negative numbers are also light red and dark red. Ideally, I would like to display numbers…
-
"Timeout expired" error when running a procedure comprising of "Bulk insert to SQL Table" step.
Hi all, I am trying to carry out Bulk insert to SQL Table , but I keep getting a "timeout expired" error message. Here are some details about my setup: I am running this procedure on a Board cloud server which also has SQL database connection set-up. I'm using Microsoft SQL Server. I got the error as shown below in SQL…
-
Drill Anywhere configuration on block in layout in 14.1
Hi, I must be missing where it change in the UX but I can't find how to do the same option as bellow in 14.1 I can find the option for same tab or for Dynamic screen? And my test capsule I've migrated has lost the screen it was referring to and everything is pointing to home.
-
User Locked Out Time
How long are accounts locked out for by default?
-
Showing Total year and ytd values on same screen
I want to create a capsule screen where the user can see total year sales for prior years along side the previous month year to date sales for prior years. I can easily get the total year sales by pulling in a reporting cube by year, and detailing the block by year. I am struggling on the best way to get the previous month…
