-
Some Problems with BEAM
Hello, I have some questions to anybody, who has already some experience with BEAM. In order to get some practical knowledge about BEAM, I am trying to produce a model forecasting a time series with sales data, but the results are useless, as the model writes the same forecasted value in every future time entity. The value…
-
Import a Budget from Board into Xero
Hi, has anyone come across a need to import budget data from Board into Xero? I know Xero can upload flat files, but can it alos automated the proces with a api? Thanks, Tony
-
Totals on top of a stacked cartesian?
Hi, Our customer would like to see the totals on top of the bars of their cartesian charts. How can I show this for them? Thank you, Krisztina
-
Saving Time Function Forecast in a cube
Hi everyone. I'm interested in using the Forecast function in a cube that contains information about the sales amount until the past month, in order to obtain a prediction for the following ones. Currently I'm applying this Forecast function inside a dataview, the problem is that it takes too long to load the page. Is it…
-
Server command - Batchfiles not visible
Hello Together, i like to use server command to run a batchfile. I inserted a batchfile in C:/Board/Job, but it's not visible. Is there some configuration needed? Thanks for your Help!
-
Dataflows : c=a*b versus c=join(a*b)
Hi everyone, I see in an application developed by consultants here, that some dataflows are using a c=join(a*b) formula, and I can't find the difference with "c=a*b" when I test on my dataflows. In some cases, "JOIN" appears in the db log as the algorithm, and some other time it's HBMP. Does anyone knows what is the…
-
Database profile - Avoid reload of database
Dear all, The database is systematically reloaded after a DB profile modification / creation. On my side I have a very huge DB (160 Gb) and reloading the DB takes a long time (about 20 minutes) and freezes the Board server for end users. So when you have several profiles to modify, we are blocking users for a long time. It…
-
Need installation file 10.6.3.41077
Hi, i need this installation version to work with a client. Could someone send it to me as soon as possible? Thansk
-
D365 F&O Board Integration Configuration
Hi All, We are in the process of implementing Microsoft Dynamics 365 Finance & Operations (F&O) as our group ERP and as a result need to setup an integration with Board. Our Microsoft partners have suggested a few options. It would be good to hear if anyone else uses this as their ERP with Board and has any advice on…
-
Rolap cubes and writeback data from Board cube to SAP/4 HANA database
Hello, i will discuss several points around Rolap cubes here Documentation example for SAP/4 HANA relational table including writeback my questions regarding writeback to relational database Documentation (Board manual) I found only partial information in the board manual regarding RDB cubes and writeback topics in the…
-
DACH Customer Roundtables
Register now for: UPDATE (July 19, 2023) Based on your initial customer feedback, we plan to organize the first set of meetings starting September until the end of 2023 in the following regions or locations: Hamburg Bielefeld/Hannover Frankfurt München/Landsberg By popular demand, we will switch or have more locations with…
-
Potentially corrupting a cube
Hi everybody, asking this question on behalf of a parter. They are removing contracts from a cube in a customers environment and carried out the following steps Took backup of cubes Took backup of tree for contract (ensuring it was well formed) Cleared all contracts Reloaded the tree (after removing the contracts not…
-
Is it possible to change this reverse algorithm logic?
Hello everybody, I would like to know if you have any tip in order to “invert” the update logic behind this dataview and its reverse algorithm. In particular, I have 3 simple columns: Budget Value (a), Quantities sold (c) and Average Price (which is an algorithm a/c). Here the reverse algorithm for block b (avg price) is…
-
Percent of total
I've got a data view where I've broken down sales into several categories. How can I get the percentage of the total sales for each of these categories in an adjacent column?
-
How to hide/ignore columns of an Excel data source when using the Smart Import Object
Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)? In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.
-
Use of Nexel
1. Abstract Nexel is a hugely powerful tool but it has its limitations, it’s important to understand when it’s appropriate to use Nexel and how best to store the original definition screen. 2. Context Use of Nexel can be hugely powerful, and in some cases necessary in order to achieve certain outcomes, however there are…
-
Managing high-volume entities
1. Abstract In complex environments, it happens to manage elements with a high volume. In such cases, it is crucial to identify the possible cascading effects on the rest of the model and what measures need to be taken when loading entities with millions of elements and evaluate in advance the possible impact on cubes,…
-
Insufficient privileges to manage this database
Hi, I am migrating a board 10 datamodel to a board 12 datamodel on a new server with an on-premise installation, I successfuly copied the database file to the board 12 database folder, I restarted the server, but when trying to upgrade the datamodel I get the following error " Insufficient privileges to manage this…
-
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
-
Process Debugger - Open Data View
Hello, In BOARD10.5, inside of the procedure debugger I could just click "Open Data View" for the step that I was on. Now - I have to either manually rebuild the data view that is being processed, or go into the procedure and copy the layout. Can we please have the ability back to simply open the data view for the step we…
-
Translation of screen folders (Localization)
Hi all, we're working with the Localization feature which works great for our purpose as we could translate entities, screen texts, screen names, and entity elements. However, as I was told by the support it is currently not possible to translate screen folders. In our case, as we work with screen folders in the menus,…
-
Divide by - Function
Hi there I have an strange issue: In the following i want to divide the values by 1000. But Board is actually dividing by 100.000:
-
Suggested Value Enhancements
It would be very useful to have some enhancements to the suggested value functionality for data entry. It is difficult to enter data quickly with the current functionality as each cell requires a click and select from a list. It would be extremely helpful for users having to do large amounts of data entry on suggested…
-
Sorting options in a Dataview
I am often missing more options when it comes to sorting the data in a Dataview. What I would love is something similar to Excel, where you can choose several columns for sorting your data. I am aware that you can choose if an entity gets sorted by ID or Description or sort data based on a cube, but there are times when…
-
Remove the capsule concept
Board is now full web solution. Therefor, is the current capsule structure still fitting? It had advantages in a desktop environment. But now, it's now lagging behind compare to other solution it terms of versatility. What we need : Every object currently in a capsule should be attached to a namespace that is store into a…
-
Quick Layout: Ability to determine which blocks can be visible/hidden to users
Hi R&D, The current quick layout configuration allows users to hide/unhide all visible blocks within the layout. I am suggesting that developers should have the option to determine which blocks appear in the quick layout configuration (same concept that exists for entities in the axes configuration). In the particular use…
-
Previous Selection
Hi all, have you also come across the desire to go back to the previous selections? Okay, Board will let you reset the selection on a specific entity and then you can select something else or you can use a vertical list and click on another member. But how cool would it be to be able to go some steps back? Example: I am…
-
Nexel Enhancement - "Auto update algorithms"
Hi fellow community members! Question: Are you using Nexel for planning screens and did you notice that changing the order of blocks in the data layout will not be reflected in the Nexel-formulas? The consequence is, that every layout change will require adjustment of the Nexel-formulas and that can become quite tiresome.…
-
How to compare the same days of a different year
Hello, I need to create a cartesian chart in order to show how much my company has sold this year and how much last year. The main problem is that we sell more on weekends, so if the first day of the year is satuarday, the year before it was friday, and it's obvious that this year performance is better than the last year's…
-
New Object: Process Mining Graph
Hi All, a while ago we at SDG have started to analyze business processes using system log files and different process mining tools. Since process mining has become quite a hype and many of our customers use Board, it would be a huge benefit to have a process graph as a new object within Board. For obvious reasons, I cannot…