-
Pattern Based Allocation Problem
Hello everyone, I got an issue with Board 12.2 with the Pattern Based Allocation feature. Actually I'm trying to input a Forecast value based on the Actual's allocation. When I try to put a value and click on "Pattern Based Allocation", it does nothing! Before : After : And that knowing that I did the right configuration…
-
Lock down Total & enter Data
Hello Guys, Would like to know if there is a way to display two axes on the rows of a Dataview and enabling Data entry. The idea is to be able to change the repartion of the displayed cube without impacting the DownTotal ( but we may impact the subtotals to adjust ) The business Idea : changing Qty in order to lower the…
-
Locked by on row totals is always applied
Hello, We have one cube, with the month by column and with a "total row". It is in Data Entry mode with a "locked by". This locked by is conditional to a workflow cube: If the current process is validated, then the detail and total must be locked, otherwise the detail and total can be entered and we should be able to use…
-
Unbalance hierarchy : How to disable automatic entity member indentation in dataview ?
Hello, On dataview, is-it possible to disable automatic indentation (formatting) while keeping unbalanced hierarchy calculations active ? Any tips ? Because some unbalanced hierarchies have a lof of levels : World > Area > Country > Region > Activity > City > Shop > Department And for each level, Board is automatically…
-
New training for the Smart Import Objects tool
Board Academy has launched a training program for the Smart Import Object enhancement in conjunction with the 2023 Spring Release. As our customers and partners, you’ll find these courses in the Board Academy alongside your other Board training tools—including training on the REST API, which is also part of the 2023 Spring…
-
Connection to SSAS DB (Tabular) from Board
Hi, Has anyone tried to connect to Microsoft SSAS DB (Tabular) from Board? If yes, please give your inputs on the same. Regards, Vikash ------------------------------ Vikash Gupta Consultant Board Community India ------------------------------
-
Average Down Total
Hello, I have run into an issue where Board seems to be ignoring the 0 values when calculating the down total when I have the summary set to "Average". Is this an issue with my data load?
-
Localized versions of training available in French, German, Italian, and Japanese
The Board Academy has released two training courses available in four additional languages: French, German, Italian, and Japanese. 1. The Foundations of Building in Board— the best source for Board users to understand the tool and begin their journey (The Japanese version will be released by end of February). 2. Leveraging…
-
Pager behaviour
Hello, Unless I'm doing it in a wrong way but it seems the pager behavior in Board V12 has changed compared to my previous version (V10). Example : For two interdependent pagers, the second pager in the v10 first highlights and sorts the entity members that belong to the selection of the first pager. Below this, the…
-
Running Total
How can I calculate a running total in Board? I want to see how our yearly sales are pacing against our yearly forecast. Jan 10 10 Feb 10 20 march 30 50 april 50 100 may 5 105 ------------------------------ Michael Hyder, MBA, CPIM Global VEG Control Tower Process Lead Bayer Crop Science LP United States…
-
iPad Optimization
Has anyone found any screen sizes, settings or tips/tricks that improve the user's experience on iPad's? Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
[Recording] Bulk Insert
Board 2021 Winter release brought several new useful features. Two new Actions (Procedure steps) have been added in the "Extract" actions group in the Procedure designer: Bulk insert to SQL Table and Export Dataset. In this session we will look at how the Bulk Insert feature works, allowing you to insert large volumes of…
-
[Recording] New Data Flow Logic
The Board 2021 release brought several enhancements to the Data Flow logic, making it dramatically faster than Dataflows in previous versions. Data Flow calculations are now executed only on the non-null cells of the DataFlow Layout by default. The Dataflow will process the formula for each combination of members of…
-
Welcome to the reimagined Board Community experience!
The new Board Community experience is here! We’re excited to bring you improved features and functionality to keep you informed, expanded resources to support your daily business operations, and streamlined opportunities to connect and collaborate. As part of the transition, we have thoughtfully migrated content,…
-
Relationship - Scanning for Errors
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…
-
How to Remove Obsolete Entity Members
1. Abstract Are you allowed to delete Entity items? What should you consider when deleting an Entity? There are different options to make deletions, like Entity extract or reload, or assigning to a dedicated dummy parent. It’s important to understand the best way to do it since both solutions have different effects. 2.…
-
How and when is scheduled maintenance managed?
Planned maintenance is performed during a fixed Sunday of each month, from 9am to 12pm (local region time), unless otherwise communicated by Board. The Sunday of the month is determined by the location of the data center selected by the Customer. Customers can change maintenance schedules if this conflicts with key…
-
How can I view the Board logs?
Logs can be viewed and downloaded directly from the Admin Portal. These logs are grouped for argument. Learn more in the Board Manual: The Logs section.
-
How can I move all databases and capsules between environments?
If you require a sync from your sandbox to production, or vice versa, please submit a new case via the Customer Support Portal. With a notice of at least one business day, this request can be completed by our Cloud Support team within a one to two hour window. Note, this request requires a stop/start of the Board Services…
-
How can I move a database or capsule between environments?
You may copy or move databases and capsules from Board cloud to your computer and vice versa: If you need to upload a database to cloud environments, copy the database on the Z: shared drive with the SAS URI and restore it from the BOARD service. If you need to move a database from sandbox to production or vice versa,…
-
How to Change the Entity Order
1. Abstract An Entity sort is a parameter set when you create the Entity, which can be updated during the development phase. It may be necessary to evaluate the addition of new members or re-evaluate the order of the elements. In this case, it’s suggested to use a dynamic sorting mechanism based on a Cube and, in other…
-
Is it possible to request access to the backups taken for disaster recovery purposes?
The backup service provided in the cloud is for infrastructure environment disaster recovery only and is NOT intended to be a replacement of the standard backup plan that must be implemented with standard Board Backup tools. Customers must create and schedule a backup plan on drive Z: with the standard tool provided in the…
-
Is it possible to modify the regional setting and the time zone of the environment?
Typically the regional settings are set to English (United Kingdom) and the time zone is set to the customer time zone, but they can be modified by submitting a support case via the Customer Support Portal. Changes to the regional setting require a reboot of the virtual machine. Changes should be planned with Board as it…
-
How can I check the status of the on-premise connector?
To check the status of the on-premise connector open the "status" tab in the Configuration Tool, and then select “test.” Select “details” for more information. Learn more here: Getting Started with Board Cloud Connector (Hybrid Data Pipeline) – 2023 Update
-
How can I check the free space on shared storage “Z:\”?
You may check the amount of free space available using a new log ""SharedStorageZ.log"" in the folder C:\Board\Dataset. You may also download this log file from the Admin Portal > LOGS > Other logs. Here an example of the content of this log file:
-
Can we use the SFTP protocol to connect to Azure File Share?
Yes, you can request activation of the SFTP service to allow access via this protocol to Azure File Share. To do so, please open a support case to the Cloud Operation Team via the Customer Support Portal. The Cloud Operator will proceed with the activation of the requested service. At the end of the implementation, you…
-
I can no longer connect to Board Azure File Share with the Microsoft Azure Storage Explorer?
Make sure you have the latest version of the product installed: Microsoft Azure Storage Explorer. Then, try re-registering the connection with the SAS URI making sure you have selected the "FILE SHARE" item. As a last resort, uninstall the application, delete the folder, and reinstall the application. If the problem…
-
How can I connect to Board's Azure File Share to upload or download files?
You can use the Microsoft Azure Storage Explorer app using the SAS URI found in the "SHARED STORAGE" section of the Instances Admin Portal to connect to Board's Azure File Share. Alternatively, to perform scheduled file upload tasks, you can use the free downloadable AzCopy command line tool here: Download AzCopy. The…
-
Which Identity Providers are supported to configure Board in SSO?
Potentially all Identity Providers (IdP) that support the SAML 2.0 or Open Id Connect standard are supported to configure Board in SSO, including: Azure AD Google AD Okta ADFS Learn more here: The Identity Provider Federation section
-
Can I restrict access to Azure File Share connected to Board instances?
Yes, to restrict access to the Azure File Share you need to submit a support case indicating the authorized IP and/or subnets. The Cloud Operation support team will reply to your ticker with a link to its calendar where you can schedule a maintenance window during which the activity will be carried out in conjunction with…