-
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?
-
Board course 300 part 1 - 306 Mismatch of results for question 2
Dear all When I run the allocation of the indirect costs and check the results of store FR0001 I don't get the right numbers. I reviewed the various steps according to the manual several times. Any tip how I can solve this issue? All temporary cubes are setup as "double" according to the instructions (as also discussed in…
-
How to: Integration with Dynamics 365 OData APIs
1. Abstract This document illustrates two different methods of connecting Board to Dynamics 365 OData APIs and all aspects related to these configurations, such as authentication, testing and pagination. 2. Context Integrating Board with Microsoft SaaS products is becoming an increasingly frequent ask. One of the most…
-
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…
-
Selectors issue - active members
Dear Friends, When we have a selector on the screen with active members enabled, whenever we need to check other options we need to reset and re- check again. Example: Sub Brand Selector (filtered by another filter Brand) Sub Brand 1 Sub Brand 2 Sub Brand 3 Lets say i choose Sub Brand 1. Now if i need to come and select…
-
B14: Make better use of whitespace in procedure editor--adjust column width
Hi Team, whenever you're editing a procedure in B14—there's so much whitespace in between the columns "Action", "Detail" and "Note" which could be used better. One option would be to make the column widths adjustable (actions usually don't need that much space, but notes do for documentation reasons). Have a look at this…
-
LEVEL300, Module306: Regarding Functional Test Question 2.
Dear Board support team, LEVEL300, Module306: Regarding Functional Test Question 2, I obtained the following results. However, it was marked as incorrect. I am unable to proceed and facing significant difficulty. The setup was performed following the steps outlined in "Build indirect cost planning and allocation." Could…
-
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…
-
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…
-
Improve SQL error log
Hi all, Board has SQL error log like "SQLError_YYYYMMDD.log". We cannot easy to load this log into cube. However, in many cases, customer would like to know what kind of error they have in daily batch. Could you improve to data format of the log as normalized? I have tested it on B14.1. However, it is still same format as…
-
Allow multiple screens to be exported into a single excel
Hi, When we have multiple dataviews under Tab object and run export into excel, they all gets exported into a single excel with multple tabs. Customer is looking for similar functionality but when the export is done for multiple screens. As of now a multiple screen export create individual excel sheets, however they want…
-
FlexGrid - Reset filters (single / all)
Hi all, some of our customers are requesting to add 2 functions on FlexGrid related to filtering: Reset single filter with 1 click: appears on a column or side menu when a filter is applied) Reset all filters at once with 1 click appears on contextual menu when one or more filters are applied on different columns This…
-
Ability to use javascript or Ajax or any scripting language to customize visuals
Ajax or javascript (or similar) scripting languages have evolved over a while and have been used to add dynamicity to visuals or show how screen objects behave when certain actions are performed. In the same context, if we can have the ability to put in some scripting capabilities, we can enhance the screen object and how…
-
Level 300: Module 303 - Functional Test: Question 1
I cannot figure out why my April 2023 sales are not calculating. As a result, I cannot determine the correct answer for question 1 in the functional test. Please help. My Instance: Training Instance:
-
ASCII Flat File DataReader - Move data file after reading
Dear all, I really appreciated the new "Delete file after reading" checkbox in procedures. I guess that, like most of you, our customer(s) require to move the flat file from its folder to another folder after its data was integrated into Board. However, most of the time, keeping the file in order to control the data loaded…
-
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…
-
Entity 'Copy' feature should be made available, apart from the 'Replicate' feature.
Hi, I hope this IDEA finds you all good and helpful. This IDEA concerns a simple feature that is currently not available in the Board application and making this available can help solving many issues related to the Incorrect reports and data. Cause of IDEA: Many users use the 'Replicate' feature, thinking that they are…
-
Method for Organization Bookmarks
Users in our organization have the potential to have a large number of bookmarks. It would be beneficial for users to have some sort of folder structure to enable them to organize their bookmarks to make navigation of the bookmarks easier.
-
Drill Down popup
Hello, Can a drill down popup be configured to show totals found on the main screen dataview . like a summary of the information found on the main dataview for the user not to lose focus on the main information Thanks
-
Unbalanced hierarchies - Lock cells and Data Entry
Hello Team, We noticed a limitation about "Unbalanced hierarchies" and "Cell lock" data entry. Let's say we have : An unbalanced entity (Account) An “A” cube structured by (Month x Account) In fact, when we display a layout containing our A cube (with data entry enabled), and axis by row: Account (which is unbalanced) and…
-
Add the option to vertically align column headers
Hi Team, whenever we build screens for presentation purposes (this applies to other screens as well, but the setting is of much higher value in presentations), we notice the behaviour that column headers for blocks using "detail by" or where the block's heading is set to "@selection" are not vertically centered but rather…
-
B14: Add the possibility to comment on procedure groups
Hi Team, since it is now possible in B14 to collapse/expand groups of procedure steps (which is much appreciated), it would be really helpful if those groups could be commented on as well. This would help in understanding what a specific group is supposed to do even when the group itself is collapsed. Thus, it wouldn't be…
-
B14: Display correct information in If-Then-Else step
Hi Team, whenever an If-Then-Else step is created in a B14 procedure the system doesn't display the information correctly: The display in the list of actions will look like this Please display the information correctly and add the "Else"-information (whenever there is an else-step). Currently, the information is updated…
-
Selector : members keep showing on top when making a search
Hello, For now, when you use a Selector with the option "Grouped at the top" for the "Show active members", when you make a search, members already selected does not keep shown at the top, as shown in the capture. I think it would be convenient to have an option that allows memers to be kept at te top even when we make a…
-
205 Italy not populating
Hello, When I select "Italy" in play mode I get no data, what should I do?
-
Level 300 Part 2, Module 307
Hi Support, I have started Part 2 307, but I don't have access to Subscription Hub, and the other 2 accounts do not have access to the platform. Please help. Thanks.