-
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…
-
Best colour for BOARD data input cells in a DataView?
I'm looking for opinions as to what colours you think are most appropriate for BOARD data input enabled cells in a DataView. As most BOARD users are probably aware, the default is a pale yellow (R255 G250 B205) background with a black text: You can of course change this default within a capsule and copy the formatting…
-
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…
-
Keep some columns visible while the dataview scrolls
Hello, I was wondering if it is possible to freeze the first columns (cube blocks) in a dataview when scrolling ? I Have a cube detailed by month (For 5 years) and I wish to keep the total column visible. Thanks in advance
-
How to use block created in formula editor as a cube ?!
Hello there , I was just wondering if i could use a block created in formula editor like a cube, for example, 1. as shown in image below, i created a Block called SingleRule_Block, 2.Now i went to Layout and created a C block with Column Algorithm as a/b 3. Now when i see in the DataView, block C does not show me any…
-
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…
-
Using selector on dataview with a refer-to
In dataviews where I have used a refer-to to create a sub-selection of a cube (in my example, I'm using a cube of revenue and have a reference for payment method as I want to exclude certain payment methods from my analysis), when I apply a screen selection the column with the refer-to does not have the screen selection…
-
How to make a line chart show data for one data point?
I am currently building a screen with time selection labels that select different periods of time and apply this selection to the data on the screen. The time labels: TODAY, THIS WEEK etc. work as intended however there is one item on the screen that does not show data when the TODAY button is clicked. DAY is on the…
-
Incorrect Algorithm Total on Dataview
Hey Guys, Just looking for some insight on how to solve this issue that i am having. Requirements: Has to show full Fiscal year split by months Has to have different heading for the 'actuals' months and the 'forecast' months. Actuals are locked and are only used for reference when deciding what your forecast months will…
-
How do I embolden the axis column heading in DataView
In a DataView where, say, there is a row for each County (as identified in Layout as an Axes, by row) - there does not appear to be a way of emboldening the axes column heading? Layout data blocks column headings are formatted through Layout\Data\Block\Format. However, Axis entities are not used in blocks, so this option…
-
Dynamix Axes in DataViews
Hello community, Is it possible to change the entities by row with a procedure? We want to make dynamic axis by using buttons. Kind regards Jonas
-
Is there an option to choose whether negative values are bracketed or have '-' prefix?
How, in Web or Desktop, can we as developers choose how to display negative values? I've found that in a DataView layout using an entity in Axis 'By Column', the negative values appear in BRACKETS. Elsewhere, where a DataView layout is using an entity in Axis 'By Row', the negative values appear with '-' prefix. It would…
-
DataView, creating a table help?
Is it possible to make a table as such in BOARD (image attached) Could someone guide me in terms of what I should lookout for the in the development of the dataview. I will have data for the manager, employees, employee targets, current revenue, % target ( which is a column algorithm current revenue / employee target *100)…
-
Save data in ROLAP cube with DataFlow
I get the concept of data being stored in the DBMS vs database through rolap cubes. I have a dense cube linked and the table exist (can we override the default table name with something that is more meaning full to our organization?). Then I define a dataview with this cube and enable data entry. The list of ALL entity…
-
Multiple different selections
I have a few cubes with 5 dimensions . One of the dimensions is Entity_A with members A1 to A12. Screen has three dataviews all showing the same cubes / entities / algorithms. User can click a button (one per dataview) to select the dimension to show - user clicks button for Left and selects for instance A2, user clicks…
-
Defaults for inserting new rows?
Hi folks, I'm working on a new capital planning module and I have a screen where users will be able to request approval for new capital purchases. Is there a way to default some of the fields in the new row when a user creates it? For example, after a user clicks the icon for a new row, I would like the following defaults:…
-
Error: Can not run request analysis
Dear all, I have this error when i display a cube to dataview. But, the reason can't be limitation of rows can be display on layouts, because only one or two rows will be displayed. When i rearrange the structure of the X-Axis, it displays data correctly. The cube has 5 dimensions, the maximum item of first dimentsion is…
-
Blur Other Objects
After reviewing some of the e-learning materials, I noticed how the videos blur the background while text is the focus of the video. From a visual perspective, it draws the eye exactly to the text, removing distractions from view. We already have a property to hide objects, but I would like to be able to focus attention…
-
Integrate drill through results in reports
Hi all, I want to use drill through results in dataviews and charts. If I'm not mistaken the drill through only opens a table with the results from the query. The idea is to integrate relational elements with the board elements as if they were the same. That way I can have a quick analysing tool with a small DB footprint…
-
Custom dataview options and actions
BOARD already uses the design of having users mouse over an object and then see additional options related to that particular object. I would like the ability to add options or actions to particular objects on a screen. Maybe this is already possible, but I don’t know how to do it. If that’s the case, please let me know…
-
Overriding a format template
I have a dataview report very similar in nature to a standard P&L type view, on my rows I have various measures which need formatting differntly for example row 1 is a dollar value to zero decimal places, row two is a percentage to 1 decimal place and row three is a dollar value to 2 decimal places. Column 1 is current…