-
Entity - Code & Desc Width
Hello community, I’d like to clarify the following scenario: If we create an entity with a code and description length of 20 each, and use a data reader to load data, what happens if some rows have values exceeding 20 characters in either the code or description? Rows with a code longer than 20 characters will be rejected…
-
trigger an ADF pipeline via rest call API in Board
We want to set up a procedure to trigger a pipeline in Azure Data Factory trough Board to refresh our sql tables in the datawarehouse However when checking the log we get the following error: {"ControlFlow":false, "StackTrace":"System.Threading.Tasks.TaskCanceledException: A task was canceled.\r\n at…
-
Entity Definition - Concatenation or not
1. Abstract In complex applications, we often face a situation where we have too many dimensions structuring the cubes. In such cases, it is necessary to evaluate the impacts on the usability of the application, and to measure the risks on the overall performance. In case of performance issues, one of the possible…
-
Dynamically manage calendar settings
1. Abstract In many cases, we will need certain mappings in our Calendar to define specific time frames for reporting and planning purposes. Some of those may be custom time dimensions and others might be created by mapping the standard calendar to specific periods. All those mappings have to be kept up-to-date. That can…
-
Procedure Dataflow
I have a cube at los level and I want to take that cube's values to the planning level of different LOSs. Considering los, sbu, sub sbu and competency are in relation and competency being the smallest and los being the largest. How could i do that
-
When procedures triggered from screens fail you 😯
We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…
-
Delete/Update Entity members
Hi BOARD Team, If we want to change the Max Item for an entity, the best practice is to do it in test environment and then use the Transporter to update the production environment. Question 1: If I need to delete members from the entity, can I do it safely in the production environment? Question 2: I want to reload entity…
-
Creating Versions for Info-Cube
Hi Board Team, I have watched BOARD Academy video about optimizing cube performance by creating different version. Is there any disadvantage / issue for creating versions? Can I create version directly in the production environment? Thanks
-
Data Model Snapshot - Environment Type Incorrect
I noticed when creating snapshots of my data models in the production site that the Environment is listed as "Dev" and not "Platform." The instance is correct for the production site and I confirmed on our admin portal that the Instance Type is Platform, however it's showing as Dev in the Data model snapshot. I can get…
-
Selection of values in a block based on another block
I would like to offer the following functionality and wonder if achieving it in Board is possible. As per below table, for each line item the user would categorise the line item with an object Type in block b. This is a block of type entity where user selects the object type from the dropdown. Based on the selection made…
-
Update pre-existing time entities
I have two questions - Can we update the description of pre-existing time entities using data reader?For example - In BOARD ,day entity has code = 20240919 and description = 19/09/2024.I want to replace description with "Thursday". My Fiscal Year starts from July.I want my weeks counting to start from July instead of…
-
Unable to load unbalanced hierarchy throught datareader
Hi, I have followed the steps mentioned in attached article on how to create unbalanced hierarchy. I have successfully loaded the entity members. Now as I try to define their relationship I am unable to do so. https://community.board.com/discussion/16748/how-to-use-unbalanced-hierarchy I want to assign AC2 as parent of…
-
Setting time range and time entity relationships
Once a year, I plan a task to extend the time range by one year. I tried extending it by a year, which resulted in unexpected changes to the time entity relationships. In the example below, the number of child entities Month for FY=2023 should remain 12, but has become 3. Before the time change After the time change I have…
-
How to define and manage the time range
1. Abstract In Board, the definition of the time range becomes very important because it guides the data that will be loaded and made visible to the end user. When setting the time interval, there are some considerations to bear in mind to avoid running into unpleasant situations during the development phase, where the…
-
Analytical Functions
Hi Board Team, I found the following calculation in one of the procedure. I understand From and To is used define the time range. But I cannot understand what Yearly Rolling Periods and Last Selected Period pointing to. If we use today 9th July 2024 as an example, which month range will the following pointing to? Thanks
-
Transporter Tool
Can we use the transporter tool for transferring the metadata between data models in same server?
-
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…