-
Procedure Step : Apply Selection to Block
Hi, is there an option / idea how to apply Time Selection : "Previous Year" to a block via a procedure? Thanks
-
Update pre-existing time entities
I have two questions - Can we update the description of pre-existing time entities using data reader?For example - In BOARD ,day entity has code = 20240919 and description = 19/09/2024.I want to replace description with "Thursday". My Fiscal Year starts from July.I want my weeks counting to start from July instead of…
-
Google Map Bubble Selection/Drill
We have a google map object with our prospects loaded from our CRM system. In version 12 we had a drill-down where we could view the prospect's contacts and address. Now that we're in version 14, we can't seem to select the bubbles any more when simply clicking on them. It used to act just like a cell in a Dataview object,…
-
How to remove the totals for a Entity Block?
Dear team, Can we remove the total 325 form the column description. Where Description is a Item entity block. We have put it to show the description only.
-
Chart - show lowest performer next to overall performance
Hi I have a question regarding a chart. In the upper chart you can see the overall portfolio performance - In the chart i would like to show the 2 bottom performers any idea how that can be solved?
-
Distributing total value on 12 months ahead
Dear Community I would like to know a way to distribute proportionally a total value on 12 months, starting from an specific date. I have a cube with the dimension "Project", that has the total benefits for each project, and I have to distribute that value on 12 months, the thing is that, each project has different dates,…
-
How to create iteration in financial model in BOARD
Mi, My name is Francesco I’m proficient in MS Excel, but I want to move some models built in Excel to the Board platform. I’m collaborating with a Board Consultant, and together we are working to port these models from Excel to Board. Specifically, I need to solve a task related to creating a financial model for the P&L,…
-
Data Reader Negative Validation
Hi, does anyone have an idea why Valid.Rec . would show a negative value? I also ticked the box the log. however it isn't showing up in the folder. Thanks, Maik
-
Is there any alerting mechanism in BOARD?
Hi there, Apologies if it was obvious and I missed it but is there any alerting mechanism within Board that could be used to , say alert in the event of task failures? Ideally using a webhook or something similar to update a slack or teams channel
-
Drill Down with layout selection in dataview
Hello everyone, I have a dataview with a layout selection and my problem is, that the drill down takes over the selection of the dataview, no matter what I choose in the rows (for ex. I have income and expences in the rows, but if I choose one for the Drill Down, it shows both of them, because I owerwrote the screen…
-
Which Excel sheet is imported with SmartImport?
When I imported an Excel workbook with SmartImport, the rightmost sheet was imported. Is this by design? I need to explain to my customers. Could you please provide a link to the online documentation where this is clearly stated? Thank you in advance.
-
Maintaining same Font across Application
Hello friends Im looking for a way to standardise fonts across the board capsules, is there a way i can do same Rgds Khaleelah
-
Save issue
Dear Friends, On below screen , im trying to save the last completion date when status is updated and Finalised Date when Final is updated The two dates are cubes with same dimensions. A procedure with two dataflows has been written to save the dates as shown below. However, when updating the Final Column, the Last…
-
B14 - where is the option in a data view to select another database
Hi, I have a screen that is configured for multiple databases. In the selectors, I can select which database to use. However, I don't see the option in the data views. How can I select another database? Thanks RJ
-
Flex grid calculation
Hello, I am using the flex grid as below, the Var % is calculated as (78081-75790)/78081 * 100. This is calculated well on each line. However , when i am grouping and aggregating value, the variance is being summed up which is incorrect. It should have taken (10,498,902 - 11,700,011)/ 10,498,902 * 100 = 10 %, on the screen…
-
Screen Layout Design
Greetings everyone, I have this layout design I have not been able to realize. My report has many columns. Grouped and Summed by two columns(print/Cost) Any idea/resource on how to achieve this layout will be appreciated. Thanks
-
[Procedure] - empty all cubes in one times
Hello, Is there a way to empty all cubes in only one step into a procedure?
-
Layout with columns different period of time selected
Hello, I would like to have a layout with same entity with different period selected. Example column 1 with quantity period January December 2023 column 2 with quantity period January June 2023 Best regards, Gabriele
-
Template
Dear, Is it possible to create template which have selectors? Example below has been implemented on a screen. These are interactive selectors with capsule procedures. Now i need to use same on other screens. Is there a possibility to do so. Thanks
-
Hierarchy order
Does the order of the entities matter in a hierarchy?In below example, given sub brand is above Brand, does it affect selectors on screen if i select Brand before sub brand?
-
Gauge
Hello Everybody! Is it possible to put conditional formatting on a gauge? I would like to be able to go from red when we are close to 0 to green when we are close to 100%
-
Selector with only valid entity member but without the setting "show only active members"
Hi I have the following Issue on several entities. here explained with cost center and profit center as i think most of people know these. We have a cost center report with a selector on Profit centers and one on cost centers. Now if i select a profit center, all cost centers are available, even the ones not connected to…
-
Nexel won't write back to cubes on the web?
Hi, I have a layout using Nexel (with Allow Write Inplace highlighted) that commits data into a cube using a single rule. This works great in the client. However, on the web, it does not commit data to the cube when a "Save Data Entry" action is performed. Additionally, unlike in the client, the web does not even have the…
-
Nexel when transitioning to Web Capsules
Hi, I'm having an issue with existing Nexel layouts transitioning capsules from Client to Web (now on Board 10.7) - every time the procedure is ran (which includes 'Save data entry' step) Nexel doesn't save to the cube anymore (it only contains the values we prepopulate the cube with to give us a base). My current work…
-
@datetime not working
Dear, In below algorithm, @datetime returns invalid algorithm any idea abt this issue Thank you
-
Excel - SetSelection
Hello, I am trying to use the SetSelection formula in Excel to control multiple layouts (Board v9). The following formula works: =SetSelection("Finance","Year=2018") but when I try and change the entity to Fiscal Year it fails. I thought it might be because Fiscal Year is technically a custom time entity or because there…
-
Move file to archive directory
Dear, Is it possible to move a file after it has been read by a datareader to an archive folder. Is there a command that can be used in procedure to execute a copy command etc. Thank you
-
One to many Issue
Hello, Given that board recommends only many to one relationship / hierarchy. Consider one to many below Example Item ——— Company Company member 1 is parent to Item number 1 Company member 2 is also parent to item number 1 (Relational DB representation below) Item Company 1 1 1 2 So this scenario is not possible in board.…
-
Labels in Charts
Hi all, has anybody an idea to get this readable? Even when I take out TOTAL it is still not readable. Thanks
-
equivalent of join/where conditions in Board
Hi, Wanted to know if there is any equivalent for where conditions in board. Example let say i want to update a field in a conventional query (simplified for understanding) update table1 set field1value = table2.field1value where table1.feldname1 = table2.fieldname1 in board i cannot do a select on each cell of a cube and…
