-
Use Nexel to refer to previous line value
Hello, I am trying to use Nexel to work on a dataview but cannot manage to figure out how it works, and the nexel documentation on community is not detailed enough. I am trying to replicate that excel formula in nexel, can someone help ??
-
URL Commands
Hi Community we are on BOARD 12.4. Is it possible to use URL commands to jump into a screen via link with a selection on one entity? THX
-
Smart import object - Upload button
Hi, We have loaded a file using a Smart Import Object. We have pasted values typing CTRL+V. They were about 15K lines and took more than 5min. To improve waiting time we wanted to try the Upload file button but although it is activated as you can see below… It does not show up when we are in the Play mode: What do we have…
-
Showing Labels and Values in a Bar Chart
Hi , Is there a way to show labels and Values in a Bar Chart Thanks, Maik
-
Levell 100; Visualization
I have a cube whose result is 65.30, I want to display this number on a screen as 65.30%. I have tried all the visualization types in board, but still Can't figure this out. Any help will be highly appreciated. Thanks
-
Extend the Time Range
Hi, I need to Extend the To Year and I tried to follow the How to Guide: How to change the Time range in GCR But I don't have or I don't know where to find the different elements you quote in the text: the location where this file should be placed (%Conso_Dataset%\Standard_Entities\Tree Month.txt) and the procedures ADM-…
-
Cubes not populating
Hello everyone, I created a couple of cubes and none seem to have been populated. All have a file size of 0.0kb. I carefully followed all cube creation steps. Any ideas will help. Thans
-
Discrepancy in naming conventions between version 12.6 and 14.1
We have tried creating a data model in both Board 14.1 and Board 12.6 with the configuration as shown below. The FY should start in June. When we look at the naming conventions used for Quarters, there is a discrepancy in how it tags the fiscal year number to the quarter. Secondly, when a fiscal year starts in Jun, the…
-
Capsule Name Auto-Renaming
Hi everyone, We are currently experiencing an issue with our capsules. The problem involves capsules automatically renaming themselves periodically. When this happens, the first letters of words in the names are either capitalized or converted to lowercase randomly. Best regards, André
-
Analytical Functions
Hi Board Team, I found the following calculation in one of the procedure. I understand From and To is used define the time range. But I cannot understand what Yearly Rolling Periods and Last Selected Period pointing to. If we use today 9th July 2024 as an example, which month range will the following pointing to? Thanks
-
How to display the results of a text type algorithm right-aligned in a data view.
Hi. The part circled in red below is the result of the text type algorithm. Even though I set the column to be right-aligned, it is displayed left-aligned. Is there a way to display them right-aligned? Thanks in advance.
-
Level 100
Hello everyone, I need help with data reader. My data reader seems to be reading the data source properly, but the data is not being populated in my entities/cubes. Any hints will help Thanks
-
Wrap Text
Hi, Is there a way to wrap text in a data view? Thanks maik
-
How to hide a button in a Capsule Home screen
Hi, We have some buttons in the Home screen of a Capsule, that need only to be visible to few users. For that we have created a cube, CLC_HLP_0284_User Visibility. Authorized Users show 1 in this cube. This cube has the User dimension which is the user entity in the DataBase. The user of the platform (the logged user) is…
-
Use Broadcasting Actions to email to non-BOARD user email address
Hi Board Team, Can I use this Broadcast to email list Action to send PDF report to non-BOARD user in our organization? If not, then will this Advanced Broadcast work if I create a cube of email list (some emails are not BOARD users, but from the same organization). Thanks
-
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.