-
Level 200 Module 213, Sales Upload/Expense Upload empty
Hi, up until now the loading data > publishing data on the Sales Data Upload and Expense Data Upload screens have been working fine, but now when I try to load data those screens are empty, and no data is loaded. The only filters I have on these screens are the country selected. Here are the procedures for both: Thanks
-
Enhance capsule log with Cube physical name
Currently, the capsule log only exports the cube name: In order to import and better analyse this log it would be very helpful if also the physical cube name would be exported (same as for instance in the data-entry log).
-
Level 300- 306 Module Functional testing Q2
Hi Team, I am facing issue in 306 Functional testing Q2 after data entry for [Office salaries, office Technology Software and Hardware, Global marketing Campaign] in Indirect global Expense planning and then navigate to expense planning screen and select the FROOO1 Store but i am getting wrong data .. Office Technology…
-
My data mis matches with data which shows in the functional testing in 306
Hi Team, I was trying to complete Level 300 part 1, Currently I am facing an issue in the functional testing of 306 module. I was missing Office Technology: Software, Office Technology: Hardware, Officer salaries in Expenses Planning screen even though i have done the data entry for these items wages in Indirect global…
-
[Procedure] - empty all cubes in one times
Hello, Is there a way to empty all cubes in only one step into a procedure?
-
My training environment keeps having issues
Hello, My training environment has a lot of issues, is this due to the latest update? thanks
-
Level 200 Module 205 Sales Actual GBP are Incorrect
Hi All! i just finish the module 205 and in the Functional test requires this result for GBP: In my screen i have this result: The variance is the same but the totals are different, furthermore if i select the LC Tab i get the same result of the Functional Test: Can you help me please? i don't understand what is the…
-
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
-
Board 11 Sunset
Board International made a commitment to provide extended product support for Board 11 when it was released over 5 years ago. Since 2019, Board has launched 2 new generations of software. The latest version (as of the publication of this article) is the Board 14.1 release, which represents a milestone in the evolution of…
-
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?
-
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…