-
How to show the "%" simbol in Excel Board Add in once exported from the reports?
Hi we are currently exportign reports from Board into excel with the "Microsoft Excel Workbook for BOARD Add-in" option selected. Because this setting does not allow the template to export as well, we cannot see the % signs on spesific rows in the report as we had to add them in using the template functionality. Is there a…
-
Substitution Formulas in destination file path
Hi there, Can I use substitution formulas in the Destination File path?
-
Change order Day and Day of week
Hi there, any idea how i can change the order of Day and Day of week in a data view? at the moment it is sorting the data alphabetical since day of week is the first dimension It doesn't work with drag and drop since day is the lower level than day of week.
-
Output Screens
Can I please get some suggestions on how to develop interactive and eye-catching persona wise and budget workflow output screens in board.
-
How to hide / show a row based on cell condition?
Hi BOARD Team, Is it possible for me to hide the row where all cells are in green? Basically I only want to show rows where there is Orange or Red. The logic for the color alert is If a/b < 0, then it is red. If a/b < 4, then it is Orange. Others are green. I am struggling to come up with a way to only show the row where…
-
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…
-
can't setup Microsoft IIS with Board 14 Web Server until the end
Hello, I have installed Board 14 (Server + IIS WebHTML5) last version 14.1.0.0.150177 on a virtual machine hosted in an Azure subscription. I would like to publish Board under IIS WebHTML5 Website to allow users to access to the Board applications hosted in this virtual machine. I followed the tutorial (last update May…
-
Board starts in a loop after login with Board v14
I just installed Board v14, and when I open Board it pops up the log in screen, after entering my credentials it stars in a loop that never ends, if I downgrade to v12.6 everything turns to normal, any thoughts about it?
-
Cube Structure extension
Hi there, is there a documentation which steps have to be taken to change / add other cube dimensions?
-
How to apply the pervious quarter average to current quarter months?
Hi Is it possible to do the following calculation? The average of market price of the previous quarter will be set as agreed price of each month of current quarter.
-
Error On-screen selection (cont.)
We're facing the same problem as this issue, but I have not been able to solve it with the same workaround. 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. I have certainly created paent-child…
-
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,…