-
Practice what you learned in Foundations of Building in Board
Customers and partners asked for some review activities as a bridge between Foundations of Building in Board, and the upcoming course in the series, Building a Planning Solution in Board. We're glad you asked and proud to help by offering these exercises to empower success! There are two different activities in Board…
-
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…
-
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: https://on.board.com/3RKaIfL https://on.board.com/46tDoNZ 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…
-
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…
-
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:
-
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…
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
How to show the value of different dimensioned cube only in total line
Here is something I have implemented at a customer, and I would like to share with you. It may be helpful when facing a similiar use case. Use case One cube is on a dimension Article and cotains an Order Value The second cube is on Main Class, which is more aggregated than Article and contains a Limit for the Order Value…
-
Refer a colleague to the Advocacy Program and get points when they join (200 points)
Are you enjoying the Board Advocacy Program? We hope so! We encourage you to spread the experience and joy with your colleagues. For every colleague you invite to the program that successfully joins, you will receive 200 points. Steps for participation: Your colleague will email customer_marketing@board.com with the…
-
The Use of Tab Container
1. Abstract As soon as developers face screen creation, in particular, if we are talking about reports or BI Dashboards, where usually a lot of different data has to be shown, they need to use carefully the layouts to avoid any screen object overflow and, consequently, less impactful data meaning. 2. Context In the…
-
Multiple Cubes or Measure Entity
1. Abstract Using a measure as a dimension in a Cube should always be weighted based on the aim. The balance between the Cube size and Cube proliferation, how the measure will be shown in a layout, and any calculation between different measures. Board exploits a multidimensional and a multi-Cube database. When designing…
-
Data Load Guidelines
1. Abstract While developers are focused on data model creation and data integration, they need to remember that in addition to the data model structure, they have to fill this structure with data. Entities and Cubes have to be filled with meaningful data to be seen by the users. This document provides a standardized…
-
Data Transformation
1. Abstract The data transformation process can be done in three different ways: 1. with SQL transformations directly in the data source or in the Data Reader Object 2. with the out-of-the-box Board ETL function 3. after the data has been imported into Board by using the dataflow engine. The type and number of data sources…
-
Rule Consolidation
1. Abstract The rule is a key functionality that allows on-the-fly calculations between members of the same entity. The consolidation is a further step to physically store the result in the data model. This step is needed only in specific cases, usually when the calculated rows need to be reused as a source for following…
-
API Related Query
Hello everyone! I wanted to know, what is the maximum number of line items that can be transferred using an API. Can anyone provide information or point me in the right direction to find out more? Thank you.