-
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…
-
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…
-
How to write data entry back to source database?
We've recently moved to a world of trying to maintain a clean production environment and making all changes in dev and then periodically copying the entire dev database across to live. However..... We've realised that data entry performed in live now gets overwritten. We have some data entry enabled for both entities and…
-
Data entry and layout performance
Dear All, I have 2 questions about Layout. 1. How can enable data entry for the black cells, do i need to fill something in the back cells then they will be enable to edit. 2. When i put 3 different entities ( no relationship between them) in the row of Layout. It takes a lot of time and sometime i can't wait. Does anyone…
-
Deciphering DataEntry.log
The file DataEntry.log in Dataset\Log collects all dataentry values done by the user. It records original value and new value. Each line holds data related to one change. For some Selections I need to figure out what the ACTUAL values of selections are: e.g. the file records "Selections on db <DBName> - Entity: 15,…
-
Creating a History Cube
I have a temp cube which calculates an average usage over a dynamic rolling period. This is recalculated daily. For reporting purposes, I now need to write this entry into a history cube by day, so that I can trend the results. The temp cube is dimensioned purely by "device code" which is the entity it is calculating the…