Data Entry

Lock Data Entry Total Only and Valid Entry Before Click Save
Hi Team, When we have Data Entry and show row/column total, the total cell will be open for data entry as well. Can we have selection to disable data entry for total ONLY, so force user to enter at detailed level? Can we also have a condition to valid the data entry before click save? For example, all the entry needs add…
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…
Split&Splat functionality extension to even/repeated distribution
Hi, I wish to have the split&splat functionality broadened, so it is not only able to split values according to the existing proportions, but have the ability to repeat the value, or to spread it evenly onto all leaf elements that are open for data entry. It would be excellent if developers could set what kind of…
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…
Copy/Paste Individual blocks from a layout
Hi, It'd be useful to copy and paste individual blocks from one object's layout to another, carrying forward any block references/functions applied to that particular block. This would remove the need to duplicate the same work across multiple objects requiring that same cube; making it more efficient to develop objects…
Unreadable Data entry text due to insufficient ability to configure colors
For Grand Total Data Entry, there are three color settings in use: Grand Total ForegroundData Entry Grand Total ForegroundData Entry Grand Total Background When the data has been changed, the Data Entry Grand Total Foreground and Background are used. Prior to the data being changed, the Grand Total Foreground and Data…
Unable to fully set data entry colors, resulting in unreadable text.
For Grand Total Data Entry, there are three color settings in use: Grand Total Foreground Data Entry Grand Total Foreground Data Entry Grand Total Background When the data has been changed, the Data Entry Grand Total Foreground and Background are used. Prior to the data being changed, the Grand Total Foreground and Data…
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
Data Entry on Total effecting only unlocked months
Hey Guys, I'm just looking for some help on how to optimize this dataview. Right now the view is pretty basic. Block 1: The cube to data enter into, by Account by Month by Cost Center, Locked by Cube in block 2. Block 2: A cube to flag which months to locked, by month. I want to be able to enter a value into the total…
Board Web Data entry error code
Hi, Any idea of what means the cod_ref: 157668...? By the way, Board Web doesn't allow me to enter data in a Grand Total. In Board Client I can do it without problem. Board version just in case: 10.0.3.51220 Thanks in advance
Month Name in Data View Block Title Without Time Axis
I have a data view which needs data entry for a particular month, but I also want to display a trend of data leading to the current month. This is simple enough using the Period Offset function and selecting only the month that is needed for data entry, however, I then cannot put months in the column axis and hence cannot…
Pending Data Entry alert message in Web Client
Hi all, When working in the client, if the user inputs a Data Entry but forgots to save it, an alert message appears asking about saving the pending Data Entry: However, when working from Web Client no question is made, so the user goes to another screen and loses all modified data. Is there a way to configure this alert…
What is the 'Data Entry Simulation' Option?
Hi, While looking at the screen properties in BOARD client, I cam across this option: Can anybody enlighten me as to what this does? Thanks, Stephen
Validation rule: Fixed String + Free Supplement
Hello community, I need a validation rule for data entry. A predetermined string, which must always be present, should be added. Example: Fixed string: Today is --> Must always be present. Supplement: Thursday Data entry: Today is Thursday. Kind regards, Jonas
Drop Down List Functionality in Excel Add-in
I'm wondering if anyone out there has every created a template of sorts within the BOARD Excel add-in that has data entry enabled on a cube (not an entity/relationship) that allows a user to make a selection from a drop down list (member codes) created with the "data validation" functionality within Excel and lose the drop…
Classification or Attributes of Entity-Members
Dear BOARD Users, I am currently facing some problems concerning a new demand to analyse products/materials according to their classification in the SAP system. One material has several entries in the classification "table". And different material groups are referring to different classification groups. All in all I am…
rule
Hi, Looking for a possibility to prevent user from entering decimal values in a data view layout. It's a direct data entry on a double cube, 4D.
How to Activate Data entry log by DB ?
Hi everyone, everything is in the title, I'm wondering if it is possible to activate the Data Entry log for one specific database only ? We have an app that would require a precise follow-up of who enters what, but I fear it would impact significantly all other apps if we activate the data entry log for all the server. Any…
data entry view
Dear Community, we are currently on shifting from Desktop- to Web-Client. Does anybody know here, if the "Edit Block" function which opens the "Data Entry View" popup is also available in the HTML-Client? I haven´t found it there and also no Information in BOARD HELP. I know that the "Calculator" isn´t available in…
Dynamic validation for data entry
I am trying to figure out how I can create a dynamic drop list for data entry on a data view. For example: An Entity gets flagged for the creation of an incident. Once flagged, various input information is required - namely: Incident Type, Incident Category and Incident Sub Category. A user is required to capture this…
can we get checkbox count when data entry enabled without saving into the cube?
I have a layout enabled with data entry. when i select or deselect checkbox till i manually save/undo my backend procedure won't run . what i expected is when i click on checkbox ,my backend procedure should run on the fly and should display my count on how many checkboxes selected. right now count value is 10 and i…
Disabling data entry on totals without disabling the total display
Hi all, Everything is in the title: I'm looking for a way to disable data entry on a total without removing the total itself. The dataview is a basic table to enter data at the physical cube level (no use of split & splat), and we would like to display the total of 3 lines without letting the user modify the total directly…
Data Entry Value Range
Hello community, How can I restrict the data entry that the user can only enter zero or values greater than 50,000? Thank you in advance. Kind Regards Jonas Trompeter
Fine tuning Set-Trigger on DataView
We have a dataview with (for simplicity sake) 3 blocks in the layout. Each block has data entry enabled. Dataview has set-trigger defined - this procedure is executing some logic/flows with the new numbers. The logic in the procedure is assuming the that all 3 blocks have changed and logic needs to be executed for those…

Data Entry

Discussion List