-
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…
-
Substitution formulas in Data Reader path
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Have already existing substitution formulas recognized on the path field of Data Readers. Usage example: By using @database on the Data Reader's path, when duplicating a database, and renaming it, we wouldn't have to…
-
ASCII Data Reader - Load first/last rows
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Add a new setting on the Data Reader "properties" tab that allows developers to specify a certain numer of rows to be loaded, and choosing wether to load the first or last X rows of the file, and ignore the rest of…
-
Filename substitution formula in Data Readers
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: A new substitution formula @filename that returns the name of the file being loaded in the Data Reader. This formula could then be used in the ETL. Usage example: The client's cubes have the dimension "Month of…
-
Database security: Cube visibility
In the "Database Security" section, we have noticed that if we use cube visibility to define user action perimeters, it works everywhere except in dataflows. This behavior, despite being documented in the manual, seems quite illogical because if the functionality helps in profiling security profiles in a faster and more…
-
Procedure steps improvements
We would like to request certain improvements to the "Edit procedure" screen, to have a greater level of detail about each step's configuration and the overall view of the screen. New detail for procedure steps: The "Detail" column in the edit procedure screen shows information regarding certain configurations made inside…
-
Grand Total Group by format
Hello, It would be helpful if we could, in a layout, change the format Color and Font) of the Grand Total Group by. For now, it is not possible to identify easily the line (see capture attached) when the groups are collapsed. Thanks
-
Edit Row Format/Template on Drill Down Window
When configuring a drill-down pop up window, a developer can pre-configure an entirely different layout with a filter applied from the drilled-into row. In our case, we have configured a pop-up to enter comments, saving space within the data entry view. However, when we drill into a member with a Row Template applied,…
-
Quality of life improvements for charts
Pretty sure there are some more points to improve within the chart component but here are 3 proposals to add, as we often see them as requirements in our projects. While it is possible to achieve the desired results with the existing toolset, it could be easier to implement and therefore also easier to explain to customer…
-
Dynamic Replenishment Model: Key Calculations & Formulas
1. Abstract Retail replenishment is the process of counting the inventory you have left in stock and reordering the right amount of stock at the right time. In other words, it's the process of ensuring that you always have sufficient inventory in store to meet customer demand. 2. Content As part of the standard Board…
-
How to Setup Microsoft IIS with Board 14 Web Server
Functionality Board 14 Web Server includes its own HTTP Server, but for multiple reasons, you might want to publish Board under IIS. Publishing Board under IIS may be convenient in these cases: Need to use a certificate and publish the site through HTTPS. Need to publish the same Board Engine through multiple sites with…
-
Select a row template per block to overwrite the row header template
Dear all, It's usual to have a row header format and a column format (for data) that are different. It would be nice to be able to apply to Blocks another format / template than the row headers.
-
metadata-driven modeling with BAML (Board Application Markup Language)
This feature is inspired by BIML (Business Intelligence Markup Language). To develop a board-application you don’t need coding skills. That is really great for beginners! To develop a board-application is mostly to create or alter meta-data. For example create a new entity. Give them a name, group, id length, desc length…
-
Detail By - Column Headers not showing
Hi all, I wonder if anyone has any experience with the detail by column names not appearing? In the example below I am detailing by this entity "Hub Source Stock Location" and the screen has 3/10 selected currently. In my dataview, I am able to view the 4 columns (which is correct, the 3 from the selection and a total…
-
👋 Fixing the article on OpenID for on premise
Hi @Board Community, @Board Support, Is it possible to correct the template openid.config at the end of the article in link bellow ? It's full of typos and not even valid xml (<add /></add>!) and apparently not the right redirect url path too. A ticket was open, but we are currently going by a trails and errors methodology…
-
An uploaded zip file - when the user downloads it, how can we control what the filename will be?
A user can upload a zip file to Board. When they do that, the original filename is lost. The new file name is generated how? Can this be controlled? For example, could the zip file have a reference number derived from where it was uploaded in Board? ------------------------------ Michael Gerrard UNHCR http://www.unhcr.org…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
Allocation with Board
1. Abstract Board is a great platform for building a planning and budgeting model and it accommodates large and complex allocation models. Board can process a lot of data in a short amount of time. The platform is also very flexible and allows the full customization of your allocation model. 2. Context Board is a great…
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Anyone using version / code management software in BOARD projects?
Hey community, I just saw Bob Gill linking his article World Cup 2018 to a repository on GitHub (GitHub - grobertgill/Tournament: BOARD Tournament model setup for World Cup 2018 ). This is something I have been thinking about now and then but have never tried to do. Is anyone of you using such solutions (GitHub, Subersion,…
-
Export to Excel - improved file-naming
It would be useful to enhance the functionality of exports to excel (and pdf) to enable more meaningful filenames to be created. My suggestion is that there should (in Web) be 2 new properties associated with each object, for which export to excel (and pdf) would use as part of exported filenames. This would improve the…
-
BEAM Predictive Analysis (MAE and MAPE)
Can anyone explain on how MAE and MAPE are getting calculated in BEAM Predictive Analytics ? ------------------------------ Vamsi Krishna Associate Software Engineer SIMBUS TECHNOLOGIES PRIVATE LIMITED India ------------------------------
-
chart marker position in webclient
Hello all, does anyone know how I can determine where my marker in a chart is positioned? For Example I like to have the marker above the bar and not within it. Like this: Currently I'm just getting a wrong depiction of it like that: I compared both configurations and they are exactly the same. I can't make out any…
-
All about language settings
Hi community, I'm looking for an overview of all language settings in Board. To be more precise, a documentation of the configuration parameters that influence the language and also the decimal separator (DB language, user profile language ....) in order to make our board environment fit for multilingual use THX for your…
-
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…