-
How to overcome the challenges of a Weekly Fiscal Calendar
1. Abstract Managing a Weekly Fiscal Calendar presents a recurring challenge for organizations operating with 52- and 53-week Fiscal Years. The presence of an additional week disrupts like-for-like (LFL) comparisons, distorts year-over-year variance analysis, and complicates budgeting, forecasting, and reporting processes.…
-
Location of the log file when the new entity members added in On-Prem
Hi, Can anyone help me to find the log file that contains the timestamp of the new entity member added in On-prem. Please provide me the exact file name and path of that file. Thank you for your help
-
Enabling Dataset download to a file for User
Hey Everyone, Has anyone ever enabled a user to download a dataset to their system/PC? They are on a cloud instance of Board, and the data is coming from one specific cube, but the extract procedure places it in the shared drive, and I can't use the extract from data view because the cube has too many entities. Would…
-
Custom Time Entity
Hello, I am looking for the best solution to define a custom time entity. For example, I would like to select: last 3 completed months, last 6 months, and last 12 months. The goal is to see the same cube three times in a data view with the respective reference to the 3,6,12 closed months. The whole thing should be…
-
🎓LEARN! GROW! ACHIEVE! We are happy to share some exciting updates and launches in Academy.
📚New Courses launched this month: Solutions Overview About this course: This course introduces Board’s Solutions strategy and explains why it is critical to delivering faster, more consistent customer value. You learned how Board has evolved from a flexible platform to a solutions-driven approach, how Engineering,…
-
Trigger send email notification after running procedure with log
We are triggering Board procedure as part of the nightly process that runs every day to update data. Is there any way we can trigger last step to send out email to recipients about completion of procedure with including log
-
What is the purpose of "Position Changes" in the Data Model Transporter?
We recently executed a backup and restore of our core data model from production to non-production. Everything was aligned momentarily; However, as soon as we developed a couple new objects (cubes, rules, entity formats), the data model comparison tool exploded to show several hundred changes between environments. Of the…
-
Selection in screens with multi-data-models
We have a requirement where a single screen needs to display data views that are based on different data models. The problem is that users have to apply the same selection multiple times (for example: select the year → Data Model 1, and then again select the year → Data Model 2). Is there any workaround for this? One idea…
-
Data Model Missing B12 Level 200 Board Instance
Hello, unfortunately I don’t have a data model in my Board instance for Developer 200. What did I do wrong? The instance was reset once by support. I cannot proceed with step 202 (create db procedure) without the data modell. Did I miss a step? Thank you in advance! Carolin
-
extract the metadata Database Board 14
Hi Everyone, is there anyway to extract the metadata from database and find two files "entities.txt" and "cubes.txt" similarly Board 10 Regards,
-
How to flag periods between two dates
1. Abstract In some cases, calculations are only valid within a defined time period with a specific start and end date. Therefore, it’s crucial to first identify this period to ensure the calculation is applied accurately. 2. Context Many business processes rely on calculations between two dates. For example, calculating…
-
How to join two tables in SQL Datareader in BOARD 14.6
I want to join two tables based on their multiple common fields.How to do that ?
-
How to version a hierarchy
1. Abstract Sometimes as well as holding the current state of a hierarchy, it might be necessary to also retain a history of not just entity values but relationships as well. 2. Context While it’s common to retain history of relationships in Board by breaking hierarchies into standalone entities and using matrices to track…
-
API Integration
We were loading the actual data in our application in BOARD with manual files. Now we want to integrate it with ADW Datalake. Please let me know how we could connect the servers with BOARD to fetch the data instead of loading it with text files.
-
Smart Import Object sample use-cases and functionalities.
Author: Amruta Shaha, Senior Consultant for Board. This article takes a deep dive into the Smart Import Object facility in Board, exploring how and when to use it in place of Data Readers, the different modes of import available, and practical scenarios where formula-based imports can unlock real value. While existing…
-
How to ensure correct rule behavior when using entity sorting
*NEW—includes video demonstration. Build Along with Board Follow along as we provide a demonstration to further illustrate the basic principles shared here. https://player.vimeo.com/1163691677 1. Abstract Rules applied to an Entity are widely used in Board to support aggregation logic within reporting structures. A common…
-
[Complex time hierarchy] : Bimonth + Quarter
Hi everyone, I’m struggling with a time hierarchy design in BOARD and I’m hoping the experts here can help me crack it ! Context : In BOARD, relationship logic is N → 1, which normally works fine… BUT in my case I need to introduce a Bimonth entity (every 2 months). So for a standard calendar year: 12 Months 6 Bimonths…
-
Migrating away from TILDE Datamodel
1. Abstract The use of Tilde ~ databases is a deprecated practice which is incompatible with the Subscription Hub, here we’ll look at the different options for migrating to a modern security configuration. 2. Context Tilde databases allowed the use of very granular user-specific security, however recent versions of Board…
-
200: module 203, Section 8, H - Product Data Reader : not working
Hello all, I hope you are doing well. I am reaching out because I am stuck on my Level 200 module. While following the instructions, on Section 8 part H, I am asked to build Data Reader to load Member and Relationships. I managed to connect to the .csv file, but when I try to set up the mapping, I just can't seem to do it…
-
Is Row Number/Counter Possible in Export DataSet
i am trying to export a report and i want a row number, or else it would be helpful if i can insert the row number/counter values through data reader in etl
-
Unable to calculate Average, Standard Deviation, and Variance for Derived Lead Time Field
I have a dataset with two date fields: Load Date and Delivery Date. I calculate Lead Time as "Delivery date-load date". Now, I need to compute the following statistical measures for this Lead Time:Average (Mean), Standard Deviation,Variance. However, when I try using formulas like Subtotal (sub function code, x,…
-
Board taking so much time for export text cubes and large size mdb cubes , is there any way ?
Board 14.4 is taking almost 2 hrs for extracting a text or large size mdb cube . Is there any way that i can make extract faster. I have tried using extract cube and dataset both , i didnot found a solution yet.
-
The Backup Mentality
1. Abstract Each Board environment should foresee an appropriate backup policy for the existing Data Models, should it be a development, sandbox or production environment. Such backup policy must always be present and it should be developed on top of the standard backup policies implemented by the cloud team for disaster…