-
Slow DB loading
Hi, I have a scheduled daily procedure to load the data into Board. I noticed that before running the procedure steps the Board Engine loads the DB in memory. This is correct, since I scheduled the service restart every night. The problem is that the DB loading takes around 2 hours. I can't change the time schedule of the…
-
Cell Formatting
Rich Wojcik, Paola Mason and I are working on a scorecard solution. We would like to refine the formatting to be cell-specific. Consider the following scorecard as our starting point, and I'll describe our challenge. On the above scorecard, we want to be able to identify percentages with a (%), dollars with a ($) and…
-
Community Update June 17, 2022: Merger of Community Forums Completed
Good news, everyone! The Board platform-based forums we mentioned earlier this week have successfully been merged under the Board Platform Forum. Be sure to post all of your Board platform-related questions in this space going forward. Tagging Did you know you can tag your forum posts with applicable terms and labels to…
-
BoardEngine service will not stop
Hi, I'm running Board 12.2.0.0.67608 on-premise. I need to change the diagnostic log level settings in the config files, but when I try to stop the BoardEngine I get an error,Windows could not stop the Board Engine service on Local Computer. Error 1061: The service cannot accept control messages at this time. The service…
-
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…
-
Effective approach to copy data from one version to another
When we need to copy data from one version to another, we usually adopt the temp cube approach. Copy data into temp cube without the version entity and then write it to the original cube into another version. This could be quite a bit of a task if you are required to copy data for all models, there could be a large number…
-
Community Update June 15, 2022: Merger of Community Forums Coming Soon
BoardVille Community Members, I am excited to share that we, the BoardVille Community team, are in the process of making a series of enhancements to the BoardVille Community to improve your community experience, optimize content, bring you more relevant news and updates, and much more! But first, a quick introduction: I’m…
-
Block hidden if
Hello, I have a layout with 3 blocks. All have data entry available. I would like to display the third block only if the user has selected a specific entity. Let's say my entity is the year, I would like to display the block "c" only if the user has selected the year 2022. If the year is not 2022 i would like to see only…
-
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…
-
Hide screen in menu
Hello, I'm starting with the new board (V12.2) and I'm struggling a bit to add a menu. With the previous version (V10.7) I was able to select manually the screens to add in the menu. Unless if I'm wrong, it seems with the new version we cannot exclude some screens ! (it's all or nothing) I have some screens that i want to…
-
Data View with data entry and pre-set values
Hi guys, I have come across this when trying to create a new screen for a revenue centre. What I want to create is a similar function to Vlookup in Excel (see below). Client is existing entity in Board. Class is a data entry cube. And i'd like to have revenue to look at another mapping table. When user entered class as…
-
Corporate Identity Designer in BOARD 12.2
Dear community, We are going to updated from BOARD 10.3 to BOARD 12.3. Currently, we are missing the Corporate Identity Designer in BOARD 12.2 Has anyone seen this feature in BOARD 12.3? Regards, Jörn ------------------------------ Jörn Constabel Controller Braunschweiger Flammenfilter GmbH Germany…
-
BOARD 12.3 - data entry via PASTE has 'changed'
Is there anyone else using 12.3 that has discovered you can no longer 'paste' values into a dataview and have them go across the row? when you paste into a dataview, regardless of what cells you select BOARD now pastes them down the column. Yesterday in 12.2 they went across the row... today after we've upgraded to 12.3…
-
Error: The client application is not known or is not authorized. (B12.2 Rev 0.0.67608)
Hello When I want to log on to BOARD 12 via a fully qualified URL, the message The client application is not known or is not authorized appears. With a simple URL it works. Restarting the engine did not bring any success. What do I have to change in the BOARD server settings? ------------------------------ Matthias Alles…
-
Diagnostic log
Dear all, we are in progress to updated from 10.3 to 12.3 As written in the release notes, a new logging is available in BOARD 12. The diagnostic log. The only documentation I found is this: Other enhancements Does anyone know how to configure the verbosity level of the logging? Regards, Jörn ------------------------------…
-
"Sync to Data model" webinar
I came across a webinar about the "Sync to Data Model" functionality which was released in the 2021 Summer release but unable to find it now. Would anyone have the link to the same or guide me on where can I find it? ------------------------------ Navan Mehra Senior Consultant Board Community Australia…
-
Excel Add in - Setselectionwithrefersh
Hi i have tried "setselectionwithrefresh", and successfully created multiple layouts with auto refresh in one worksheet. however, it seems ""setselectionwithrefresh" apply the selection to all worksheets, how to make the setselectionwithrefresh only working for one worksheet and only, as i need to create different…
-
Workflow
Is there any way to create workflows in Board? For example a user A wants to get authorization signature on a report from user B and after user B authorizes it , the same report has to be sent for authorization from user C. ------------------------------ Kumar Harsh Analyst EY GLOBAL DELIVERY SERVICES INDIA LLP India…
-
NEW Advocacy Program Rewards Catalog
When you join the Board Advocacy Program, you have the opportunity to participate in multiple acts of advocacy, from sharing feedback about Board on social media to presenting your Board success story on a webinar or at an event. You will earn points each time you complete an activity. Over time, your points will…
-
How do I participate in the Board Advocacy Program?
We hope you've seen our recent blog post about the Board Advocacy Program. If not, head on over there for a quick read and introductory video. In designing the program, we wanted to ensure that it would be accessible and provide equal opportunities for customers to join and become Board Superheroes. It is easy to join and…
-
What is the Board Advocacy Program?
We're excited to highlight the Board Advocacy Program - Home of the Board Superheroes! We designed this program to reward customer superheroes like you for participating in specific activities that allow you to share your Board success stories. Examples of activities include collaborating with us on a press release about…
-
Dataflow Aggregation not Working
I have two entity trees: A -> B -> C and, P -> Q -> R I have a cube dimensioned: (Month, C, Q), and I want to populate another cube aggregated by R: (Month, C, R) When I build the layout (Month, C, R) in a dataview it shows the data the way i need it do, but when I run a dataflow to populate a cube with the same layout, it…
-
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…
-
Security Notice: Zero-day CVE-2022-22963 and CVE-2022-22965 (Spring4Shell)
Spring4Shell Security alert 05/04/2022 ====================================== Board is aware of the recently disclosed Zero-Day vulnerabilities CVE-2022-22963 and CVE-2022-22965 (Spring4Shell). We have conducted the necessary analyses to assess the exposure of our systems and services to this vulnerability and can confirm…
-
BOARD Excel Add-in Functions and VBA Integrations.pdf
-
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…
-
How to install BOARD Office Add-In with command line in unattended mode
BOARD Office add-ins can be installed with a Command Line using MSIEXEC To install the, follow the following steps: In the start menu, right-click Command Prompt and choose Run as administrator. Locate the MSI file for the version of the add-in you want to install. This is often in the Downloads folder. Use the following…
-
How To: Set parametric WHERE clause for SAP Connector in a BOARD Procedure
WHERE Clauses can be included in the SAP Query. This implies the edit of the SAP Connector Query as the WHERE condition changes. A different and flexible approach can be taken in case a parametric WHERE clause based on specific user / dataloading conditions is required. 1) While editing the "Where" Clause of the SAP Query,…