-
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 ------------------------------
-
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…
-
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…
-
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…
-
CONNECTION or CUBE to .csv stored in FILE SHARE drive
Dear all, Maybe some of you have met the same issue: i would like to create a connection or a ROLAP cube to a ".csv" file stored in Shared Storage drive (GUI = microsoft azure) provided with full cloud version of Board (currently using 10.6). I could use the Shared Storage with:* Data Reader to load data in a cube (using…
-
Server Command - Batchfile not visible
Hello Togehter, i try to execute a batchfile with server command step. I placed a batchfile in folder /Board/Job, but it is not visible. Is there more configuration needed? Thanks for your Help!
-
Screen fit for various aspect ratios
Hi, Our masks are built with a custom aspect ratio that is close to 16:9 and we are using fit to width in the mask. Some users have ultra-wide monitors (21:9 aspect ratio) and for dashboards the screen renders completely differently and is no longer aligned. Chart labels are shifted over so that they are hidden from view,…
-
Scroll bars - change their colour, make them more defined/visible
Can you see that image above? That's a Board scroll bar. It is very difficult for users to see, it can be frustrating for them, moving their pointer over the screen hoping to find where the scroll bar is. Is there a way to make it more visible? Can the colour be changed? ------------------------------ Michael Gerrard UNHCR…
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Excel and Web log in at same time
Hello, It would be very helpful if we could be logged into Board Excel and Web at the same time. There are many times that I am monitoring users submitting data on the Web and I'm in Excel refreshing files. This causes me to get logged out of the web and go back in, click on the capsule, then screen, then select the…
-
Get cube values for first and last element of selection
Hi, I need to show in a data view a column with the values related to the first element of a selection. I also need a column with the value for the last element. For example, the selection is for the months from January to June. I want the values for January. I used the ANALYTICAL FUNCTIONS > First Value, setting the From…
-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
[IFRS16 APP BLA] Cube Corruption
Hi, We recently had a problem with a procedure because some cubes were corrupted, are there any best practices to follow for to prevent this problem in the futute? The version of the BLA database is 12.1. Thank you in advance for any response, Francesco. ------------------------------ Francesco Tufaro Consultant TECHEDGE…
-
Board 10.6 IIS Kerberos settings login
Hello, we have searched in the KB library and in some post, but we can't find the correct settings to setup the Windows authentication to Board Web via Web Browser . Actually we have setup Board 10.6 Server with the IIS active service and Board client also works great with Windows and Board defined users. Unfortunately…
-
Best practice to add a dimension to existing cubes (Board 12)
Hi, I need to add a new dimension to some existing cubes. These cubes have a dimension related to delivery customers and the new dimension is relative to invoiced customers. Is there a best practice for this scenario? I followed this steps: - Entities creation (Invoiced customer, city, category, ...). - Relationship…
-
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…
-
pattern based allocation - how it works?
Hello all, I'm searching for a description (Doku, Video...) for the function "pattern based allocation". How must it be configured? I hope someone can give me some help. Thanks in advanced. ------------------------------ Stefan Batalia Board Administrator Arntz Optibelt Group Germany ------------------------------
-
Screen fit, Fit to single page changed after restart
Hello all, when I change the settings "Screen fit/Fit to single page" this settings will not be stored. When I reopen the same screen I must do the same again. Is there a possibility to save this setting? ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
Services restart not working consistently
Hi, I restart the services each night via a batch file. According to Task Scheduler, the task is completed every night. Yet, half the time, databases are loaded into memory that have not been accessed since the previous day - indicating that the services did not restart. The main issue is high memory usage before the…
-
Import txt. into multiple columns
Hi, How can i import data from a txt. file into Board? The import file contains 20 columns per row with data. These columns are accounts. In board, i have set these accounts up as an entity with 20 members (account a,b,c..etc.) in it. In the data reader i cannot select each account member (a,b,c..etc.) individually to…
-
Nexel - Calculation
Hi, I'm working with Nexel and have to data views in the screen. The last one I'm using Nexel to hget a value from the first data view by having this formula =["Nettkapital;@f;*;*;Range.Vertical] and this works. The main goal is to multiply the "Nettkapital" (Grid Capital) with 1.01. This do noe work in my data view. It…
-
sum of hours
Hello all. I need your help trying to see how I can model a specific request. I need to create a dataview storing hours (see pictures here below) By row I have the agent, by column the day of the week (m,t,w,t,f,s,s), data are the number of HH:MM the agent worked that day. At a certain point I need to sum all the hours in…
-
Sorting data view with multiple entites
Hello, I have a dataview with two entities by row: - Business - - P&L Line How can I apply a custom sort to the Business entity? It only sorts by Code or by Description, and the Filter -> Sort in data view options only applies to P&L line. ------------------------------ Mark Developer Australia…
-
Profit und Loss Statement: Special Structure of columns
Hallo everybody! I would like to create an P&L Statement with the following structure: Column 1 to 6: Information to actual month Column 7: row structure of the P&L Statement Column 8 to 13: Information to the cumulated value It should be also possible to expand or collapse the row structure. An Example is shown at the…