-
Data Picker Tool
Hello, We would like to know more about the Data Picker tool. Specifically as it relates to mapping a gl account to two different categories within another entity. Please see below for a detailed example of what we are looking to achieve using the Data Picker tool: We have 2 related entities at play. One entity is our GL…
-
Smart Input Object: error message
Hi, We have set a Smart Input Object to load data to a cube. When we paste values and click the Save button we get this message in the screen: And although values look fine just like they had been loaded correctly we don't feel confident about it. We can not discard that this causes an issue in the future. Do you know the…
-
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
-
Detailed by Month for multiple cubes, but not grouping together
Hi BOARD Team, I am not using By COLUMN as month so I can have Block a (SOH) only showing once. I use Detailed by Month for all other block, so other blocks will be detailed and grouped by Month. However, block g (algorithm) and h (blank use as divider) are not grouped by month. Those two blocks are showing at the back of…
-
Export dataset - Remove the quotation marks
Hello everyone, I am facing a constraint with the export dataset feature. I would like to export a large amount of data with more than 4 entities on row without the header and the quotation marks. Currently, when I execute the export dataset, I get the following pattern : "XXX";"XXX";"XXX";"XXX" I would like to get the…
-
Board 14 - user experiences
Dear Board Community, I went through all updates, posted bugs/fixes and feedbacks on Board 14 in the Forums section. Based on my findings the posts, which I had access to, are made from developers from consultant companies, but no end-customers like producers, retailers, etc. Do you have any experience with updating Board…
-
Hiding row total while keeping it activated
Hello board community, For a client engagement I am trying to overcome the following constraint. Thank you for your help on this subject. I have a budget cube structured by year (budget_year) with a value of 1200$. This cube set the value for this use case. I have another budget cube structured by month (budget_month) with…
-
Data Pipeline to Sharepoint
Hello all Has anybody installed a direct Data Pipeline to Sharepoint and could share the informations how to do it? I cannot find any information in board universe how to set up a connection to sharepoint - esp. what credentials have to be filled in data pipeline? Maybe board can provide a "Blaupause"? I think a lot of…
-
About the steps marked "Call procedure" in the procedure
Hello. When I executed a step within a procedure that called another procedure, the message in the attached image appeared and the step was not executed. I put the steps of the procedure I wanted to call in the procedure that was calling it, and the procedure ran without any problems. Why does this error occur? If anyone…
-
Board Excel Add-in not responding after Connecting
After logging on to the Board Excel Add-in, all of the buttons on the Ribbon are not responding other than 'Disconnect' & 'Add-In settings'. I can open another spreadsheet with a connection concurrently and it works correctly. The spreadsheet was working and has suddenly stopped responding (for the Board connection). Has…
-
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,…
-
How to extract entities in code with cube extraction
Hello. I'm currently failing to reload the data because the input data in the cube is extracted with the description rather than the code. I think the problem could be solved if the data could be output in code. I would like some advice as I am currently facing this issue and don't know how to resolve it. I'm sorry that…
-
An unhandled error occurred (cod_ref: 1695366869500)
Hi, I found abnormals numbers in some input cells (see screenshot). And when I try to type a normal number I get this error message: An unhandled error occurred (cod_ref: 1695366869500) Does anybody know what does this mean? And how to correct the input? Thanks in advance
-
How to store data in cube structure:Microsoft PowerPoint
How to store data in cube structure:Microsoft PowerPoint I was able to create a cube, but I don't know how to input the data. If anyone knows how to do this, could you please tell me? Also, if you know how to use cube structure: Microsoft Excel, please let me know.
-
Mapping between entities
Is there any way we can map an entity member to two or more different categories within a separate entity? If so, what would be some methods to achieve this? Thank you.
-
Columns width on a dataview
Hi everyone, I have a problem on a table: my "cost center" indicator is not wide enough (I can't see all of the code and wording). but even if I increase the width size (here 265 pixels), Board does not take it into account. An idea? (Board V12.3) Thank you for your help. Nicolas
-
How to hide screen objects that can't show data?
Hello, I have created a screen with several graphic-objects. Depending on the screen selection, some of them can't show data. Which leads to the picture shown in this screenshot. The most right grapic shows an error-message. Is there a possibility to hide this error message? If the object can't show data, I want it to be…
-
Smart Import using excel with formulas on cells
I have a question, When I have an excel sheet which uses formulas on cells (ex. XLOOKUP…) and I want to import it to Board using SmartImport, Is there a way to import it except change the formula to value (on excel) then do SmartImport? Thanks for some ideas,
-
Presenting LMA data to non-admin users
I'm trying to share some simple logging information with my company based on the LMA data that's being captured. I built a couple of screens in one of our main capsules that use a different data model and I referenced the LMA data model on those screens. However any user who is not set up with view all access gets an…
-
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…
