-
Analytic function - Mode
Does BOARD implement statistical function Mode into analytical functions?
-
Calculating in rows
Hello everybody, I have a data view with turnover, the order Backlog and the sum of both for every day: Now i want to calculate the differennce from one day to the other in a separate column like this: Are there any Nexel formulas for this? Thank you in advance
-
How to get daily weather forecasts in Board?
Hi, I'm looking for a way to get daily weather forecasts in Board. Thanks in advance
-
Aligning Chart Axis
I am working on mimicking a chart done via excel currently. Without creating a new data cube I can pull the data in multiple charts, however the axis range of each chart is different. The visible layout of the chart is Actuals (Blue), Forecast - Actual (green or red), and Total Year Forecast (White). Depending on the…
-
Dates format EU vs US
Hi Community our server is in Italy, with local settings dates in reports are viewed in the format dd/mm/yyyy Some US users would like to view dates in the format mm/dd/yyyy Is it possible to do something locally, without affecting same reporting when used by EU users? thanks
-
Web-Login Problems Board 10
Hello, from one day to the other i have problems with the Board-Web Login under Firefox. After entering the link to the Server i only get a blue circle and nothing happens. With an other browser like edge it works.... I haven't changed anything in Firefox. Someone an idea? Kindy regards
-
Security
Hi, We use BOARD to offer access to our clients to see dashboard performance stats. The row level security does a great job is only showing each user the data they are allowed to see, however our internal security team have concerns that there is no out of the box option for either two-factor authentication, password…
-
can't run CSV file with Board 11
Hi, Its my first time trying to load a Csv file with Board 11, but after configure the data reader the "RUN" Button is not enabled Whereas its possible to run a sql data reader. Steps: Source - I created an new data reader and connected with the local file (*.csv) which i exported out of excel. Options Csv and delimiter…
-
Does labels using layout, ignore the format define for the displayed block ?
Hello, I need to display percentage in a label but using format to add a symbol after doesn't seems to work. I've got the following setup : The result in the label has the 2 digits unlike if used in a dataview and more important has no % symbol after. Is this combination of two features no supported?
-
Month selection based on a Start Date and End Date
In order to create a Project (i.e. promotion) management function (which allows end users to add and edit promotions in Board), I've created two Date type cubes for a project Start Date and End Date respectively, which contain only one dimension - Project ID. The requirement is after both dates are entered by users, the…
-
How to make 3D Chart
Candra Aji Pamungkas Jadi PEKIK Paul Wyatt - Avison Young UK Hi All, I wonder if someone can tell me, how to make 3D chart like picture below also I got the example below from the demo files (capsule) Thank u, I hope you always be cheerful sorry for my english Cheers A.Malik
-
Prevent DataView from refreshing/redraw when cell is edited
I want to stop the DataView from refreshing/redraw every time a cell is edited since i have a Save button setup for Saving and other functions
-
Digitally Sign for Applocker
We use AppLocker in a whitelist capacity. This means that only certain folders, publishers, etc, can run on our PCs. For obvious reasons, the Appdata folder in local user profile cannot be a folder level exception, as malware commonly writes there. In order to use Board auto-update, we would like to have the…
-
How can I round an input number in the dataview
I have a dataview in which I want sales persons to add the number of quantities that they will sell per month. For this I only want them to be able to enter whole numbers and not decimals. With the validation rule I am already able to set that the number should be zero or higher (so negative numbers are not allowed),…
-
Sort dataview by Decreasing Date
Before I go to too much trouble building in a workaround I thought I'd see if anyone in the Community has found an simple way to Sort a dataview by decreasing date. Below is the issue you get in BOARD when you try to sort on the Day Entity as a block.. The issue is that it doesn't actually sort it as a 'date', but more as…
-
Cancel on interactive selection: how to cancel the procedure ?
Hello everyone, I recently built a procedure for interactive selection, started by trigger on the screen, in order to force the user to restrict his/her selection before loading any data. This is because it would otherwise generate too big reports. So in the procedure there are several interactive selection steps, on…
-
DataView Cubes not shown by columns
Hi all, I'm showing a cube by Ledger account (By Row) and by year (By Column) for some financial figures. In addition to this, I would like to add a text cube for comments based on Rows (Ledger Accounts). My problem is, that the comments cube is shown for each year when I add it into my data view. But I only want to show…
-
How to sort by a value for a axes combination in DataView
As shown in the screenshot below, we have a Sales cube and Budget cube, which have the same dimensions - Item, Area, Month, UoM. We tried to calculate the Severity (i.e. bias) and present the data in a flatten dataview showing Severity in descending order so we can find the most problematic Item/Area combinations as shown…
-
Replicate Entity More than once
Hello Citizens, i'd like to know if we can replicate an entity more than one time , that means that a i have already a replication and i wanna add another one for the same entity. Thank you for your help!
-
BOARD CLIENT ACCESS DENIED
Dear all, do you know how to solve this error? Board version is 10.3.0.51220 and we try to access via Citrix Thanks in advance for your attention.
-
DataView - Update a column when another column is changed
My requirement is the keep the change DateTime in a cube and this is updated when the user changes another column's value. For example - when the user updates column "A" (Linked to Cube A), the column "B" (Linked to Cube B) should get updated with the current date time
-
On Stop Behaviors
Hi, Does anyone have a definitive guide or understanding of how the different procedure 'on stop' behaviors work? I am most interested in understanding the implications of "Must be executed until the end." My current issue is that, if a procedure is running and a data reader kicks off (even in another database), the…
-
Interactive Axes
Hello, I'm looking to build a feature that allows the user to essentially click a button and it provide additional rows of data (almost like a drill down). I've attached two examples. The first screen shot is how the report is built now with all the data rolling up to each of the different accounts. The feature I would…
-
Column Heading
Hello, I have a pager with the Month/Year selected. All of my column headings auto populate with the Month/Year listed. Is there a way to remove the Month/Year from the column heading. I've attached a screen shot for reference.
-
It started out so promising!
After I "tortured" myself with porting some applications from #B10.5 to #B11 for quite some time now, I come to the well-known wisdom: "Never change a runnnig System!" or, as always said in Apple circles: "Never buy Revision 1". Okay, there are some things that are already working to an at least sufficient degree. I also…
-
10.5 CPSX capsule backup
The release notes for 10.5 state the following; "Features that are missing in edit mode can be used in play mode. So, if you have a NEXEL in a screen, you can still use it in play mode with the web client. If you need to develop a new nexel, we suggest to keep an update version of the capsule in the old format ".cpsx".…
-
Restricting users to create the number of entity members
Hi everyone, I want to give the facility to create entity members to my user but with a limitation that he/she can create max 5/6. How to do this ?Gabriele GalloEnrico ManganoOliver BeirneMichele RoscelliAndrea MasieroHelmut Heimann
-
Login Web Issue
HI, I have issue about Login Page in Web Mode. Every login, Screen Login redirect to Logout screen automatically. Can give me suggestion?
-
board 11 key of an entity in a dataview
Hi, In the Board 10 client is it possible to add an entity as a block on a data view and select the option to show the KEY or Description. For example if you want a report with a separate column for the account number and for the account description. In Board 11 (web client) I can not find this function anymore. Does…
-
Is there a way to customize web logon page?
A customer is asking for a way to customize (i.e. Board logo and/or background image) the logon page displayed by Board 10 Web Server: Thanks! Pietro
