-
Validation Rule on Detailed-By Data Entry Not Matching Total from Another Cube
Hi everyone, I’m facing an issue with a validation rule on a data entry that uses a detailed by dimension. I would like to create a validation rule that checks whether the total of this detailed-by data entry is equal to a value coming from another cube within the same layout. I tried adding the cube directly in the form…
-
Level 200, Module 207: Data Entry is not working
I am configuring Sale Planning worksheet within Module 207 task. I am adding a Dataview object for Cube BUD - DE - % Increase, and I put Data Entry option = ON, but after applying and saving the configuration, the fields are not coloured yellow, and Data Entry is not allowed in Play Mode. I would like to know, what…
-
Advanced Smart Import
1. ABSTRACT The Smart Import object facilitates the upload of data (master data, transactional data) to Board. Before, Dataviews with line number entities or CSV blob cubes with export/import procedures were required to upload the data. In addition, a complex check logic (if implemented at all) was required to detect wrong…
-
procedure step > text file datareader > changing filenames: how to manage this
Hello, I want to track manual data-entries done by the users of an application. Therefore i: parse (through Text file data reader and Board ETL) the appropriate file trigger this datareader in a procedure run by the user BUT the procedure step needs a fixed filename whose name is not changing over time. — Details: The…
-
Problem Loading images with Data entry
Hi everybody, I’m currently struggling to upload some images into a BLOB cube. I already have a cube containing different items, and I’d like to associate each item with its corresponding image. To do this, I created a BLOB cube with the same dimensions as the original one. Then, in a Data View, I tried to enable the Data…
-
Lock Period in Data Entry
Hello, Is it possible to lock month periods when using Data Entry but the input is on the year level? I want to enable users to input on the year level and allocate it using split/splat but I also need to lock the 1st half of the year so that the 2nd half is the only one changed by the input.
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
What is the best-practice approach for data entry on multiple years per tab?
Scenario: (Board 12.6) Screen selection 18 months: (October 2025 - March 2027) 3 tabs (2025 / 2026 / 2027), in each of which only the corresponding months should be ready for input Is there an alternative to an algorithm that multiplies the data by a month cube and stores the data input inversely? Cube A (Month): 2025: 1…
-
YoY Growth
I am creating an application where I have to show YoY growth of every expense present in dataview. What's the best approach I can perform to add YoY growth percent below every expense without adding that member in the entity already used. Attaching the screenshot for the reference.
-
YoY Growth Calculation
I want to calculate the YoY growth of every expense mentioned in the cube and want to show it in the dataview. attached the screenshot of the view I want to show in the screen.
-
Upload file
I want to attach the user manual in the screen and also allow the users can also download the file.
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
-
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
-
Alternative of excel add-in
As users have the option to load bulk data using excel add-in but still there are some challenges that users are facing with excel add-in. Is there any alternative of excel add-ins in Board to load bulk data in proper format.
-
Lock data entry row total cell only
Hi BOARD team, I had a data entry table as following. Can I lock data entry for the row total only (allow data entry at the detailed level, but not the total)? Can I add a validation based on the TOTAL? When user make data entry at detailed level, the total must be added to 1, otherwise system pop up an alert and does not…
-
date cube : data entry
Hello everyone, I am facing an issue related to the use of a date cube. In a layout, I have a date cube (structured with only 2 dimensions, including the year) open for input, which allows identifying the start of an allocation on a specific day. The default year displayed is the current year, but I would like to display…
-
Level 200, Module 207: Data Entry is not working
I am configuring Sale Planning worksheet within Module 207 task. I am adding a Dataview object for Cube BUD - DE - % Increase, and I put Data Entry option = ON, but after applying and saving the configuration, the fields are not coloured yellow, and Data Entry is not allowed in Play Mode. I would like to know, what…
-
Smart Import trigger procedure - how to select based on the items present in the import ?
Hi all, I'm faced with an interesting issue when using Smart Import. We have setup an object so that users can import values from an Excel file. This is in addition to a screen where they can enter manually the values. In the basic data entry screen (based on layout then), there is a trigger which executes a currency…
-
Issue with Smart Import file upload.
Hello, I am trying to use the smart import feature and am having some issues with the file upload. Basically when I try and upload a file I'm getting validation errors on my data. However when I do a copy and paste into the import table the data is accepted. The data is around 1750 rows so copying and pasting the data is…
-
Enable Data Entry on Flex Grid
Greetings, A good idea to enable data entry on flex grid. thanks
-
The Font Issue in DynaWrite in Version 12.5 and Lower
Hello, I created a RTF cube and use date entry to edit it and use DynaWrite to display the content of the RTF cube, and it looks like the font for bullet point and numbering are different. If you use bullet point, then the font is set to Time New Roman, and if you use numbering, then font is set to Open Sans which is the…
-
V12 - Smart import & max items
Hello everyone, As a neophyte, I am currently experiencing a few problems. Indeed, most of my models are still on a pre-V12 version and I'd like to understand the advantages of the V12 on certain points. Optimization with Smart Import in Board V12: What are the best strategies for taking full advantage of the "smart…