-
How to calculate as Dinamic
Hi, I have data like this : Safety Stock (Enable Data Entry) Setting Safety Stock : 2 Week : Wc01 Wc02 Wc03 Wc04 Wc05 Wc06 Demand : 10 10 10 10 10 10 Safety Stock : [........] [........] [........] [........] [........] [........] I want calculate Demand to Safety Stock as Dinamic. When I want Calculate Safety Stock,…
-
How to save the current selection (to file/db/cube/...)?
Hello, I'd like to save the user's current selection via a procedure (click on button to save), in order to be able to restore them later (click on button to retrieve and set). This way user's would have their own saved queries (I intend to limit the amount to 5 and have 5 Buttons). What I've tried doing is storing the…
-
I'm trying to add a capsule folder to an existing profile but board shows an error. Does anyone know
hello, I'm working on the security profiles, and I'm trying to add a capsule folder to an existing profile but board shows an error. Does anyone know what the problem might be ? best regards. security profile security
-
Formula Editor - Layout Error
Dear All, I want to use Nexel in My Dataview Layout. But, After Add Block I got error message. What is the purpose of the message in question? Is there a better way to display alert on my layout ? Thanks
-
Can we open multiple screens at the same time while we opening any Capsule ?!
Hello there, I am just curious to know that is there any possibility to open Multiple screens at the same time while opening any capsule, what currently i am facing is while i open any capsule i am just able to see one screen , what i want to do is to get 3 screens open when i open any capsule ( I am aware about containers…
-
Data does not appear to be supported format ?!
Hello There, I am trying to upload data through Data Fast Track > Local file > and my raw data file is in xlsx format , however when i am trying to import data into database its giving me an error stating "The Data doest not appear to be in supported foramt", i tired fixing Data format to YYYYMMDD , also removed blank…
-
Web Client Pager in ATO
Hello, I have a Pager in ATO to create/edit entity members, the pager works fine in the desktop client, whereas in Web client, we can't see the Code field unless we extend the height of the window. Does anyone have this problem ? What can we do to solve it ? Any help would be very appreciated Best regards
-
detail by with data picker
Hello all, It seems that when using the data picker functionality in a layout (using Nexel rather than Rules), that if a detail by is used on a block the entity being detailed by is ignored, and the total is displayed for every item. In a simple example, if I set a single rule for a block to be "=@[V001]" , and then put…
-
export to excel
Hi Community I have a doubt that just to export a dataview to excel also do we need ms office license to board should be true? Thanks in Advance.
-
Changing Header Positions in Layout Selects
Hey there I just want to know if its possible to change the column header positions. I want PLAN to show first and then the second member IST I don´t think thats possible but thanks in advance =) kind regards Toni
-
Combine Cubes with different entities
The goal is to produce to the following structure: Employee / Activity / Hours / ( activity / capacity ) So i have a cube with the employees, activities and hours for each day and i have a cube with the capacity per day per employee. And also the time period will change, so the capacity is a variable. The report can be for…
-
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…
-
Procedure Failing - "Index out of range"
I have a procedure that fails on the overnight schedule but works fine when I run it manually. Error message is "Index was out of range. Must be non-negative and less that the size of the collections. Parameter name: Index" The only time I've seen this message before was when a step of the procedure is for a Data Reader…
-
Get Last Value each 10 Days
Hi everyone, Currently, I had a problem to find a way for getting last value each 10 Days (based on my Aging time). I tried to use Last Value function but didn't work (cause Last Value function characteristic -it won't stop till the time end- ). Is everyone any some suggestions? The example I attached. Thank you. Have a…
-
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…
-
Disable left menu in HTML5 iframe
Hi, when i try to embed a capsule in my website using iframe, the left side menu still appears. Using it, users have access to other screens. Is there a way to view a capsule in my site page without viewing the left sidebar of the BOARD web interface preventing free navigation among screens? Thanks,
-
Keep Header Rows Empty in Excel
Hi Boarders! When I export a table to Excel, Board adds 0's into the empty header rows. In the example attached, "EXPENSES", "Workforce" and "Senior Medical Officers (SMO's)" are empty header rows in the Board data view but they contain 0 in the downloaded Excel sheet. Can I quickly download to an Excel spreadsheet but…
-
Screen Security for Individual User
Hi Boardville, I would like to create a screen, which can only be seen by selected Board Users to an existing capsule, which is used by multiple users. Is this possible via security profiles or will I need to set up an additional folder for these selected individuals? Thanks Mathias
-
Get around go to screen and run procedure on webHTML5
Hello, Looks like there are not the option to have a go to screen or a run procedure linked with a dataview line! How did you get around this? Thank you and best regards Marcel
-
Top N Query in Layout - N should be selectable by the user
Top N Query in Layout - N should be selectable by the user in the screen One of our Clients wants to select variable top N queries in a screen, means that the user should be able to select if the layout is for example a top 10 or a top 15 or a top 20 query. At the moment you have to go into the layout and select the number…
-
Difference Time
Hi, I want to calculate difference year like this, FC Admin - Choose Year(2018-2017=1). How to develop in board?
-
Can I deploy Board items created in v10.3 to a server running on Board v10.1?
Hi Guys Is it possible to deploy Board items created in v10.3 to a server running on Board v10.1? I have upgraded my development environment to 10.3 and want to continue working in it, but there is a chance that I will want to deploy the work to the v10.1 production environment before I can upgrade it to 10.3. Any help…
-
Aging the time/period
Hi All, I'm confused to do an aging of time (that I know Aging use for grouping/mapping about age of sth). This time I'm trying to make Aging for Date. I have Day which is only the Date formate inside so there will be 01 - 31, from that Date I divide by 3 part : First week 10 Days (Date 01-10), Second week 10 Days (Date…
-
How to create a zone map?
Hi all, I was looking a bit around on YouTube for BOARD demos and I stumbled upon following video: Self Service Business Intelligence - BOARD Cube - YouTube As you can see between minutes 10 and 13, the presenter uses a map of the United States, split up in zones with values and colours adjusting interactively based on the…
-
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…
-
Log file for procedure changes
Dear community, Is there any log file on Board server to track procedure changes? I am looking for information like who has changed the procedure and when it has been changed? I will be grateful with your answers. Selvet
-
Problems logging in via client after initial install
Hi, I am following the e-learning steps to install the Board software. This is on a local desktop. I have successfully installed the server, set up the first user and installed the client. However when I try to connect with the client (using Administrator) the dialog box briefly flashes "Connecting..." but then goes…
-
Broadcasting on Cloud Enviroment
Hello, In on premise enviroment the email setting must set on client side. Does anyone knows if it is possible to set the Broadcasting option also on cloud enviroment? Where can i set the Broadcasting parameters? Thanks a lot Lorenzo
-
How Do I Calculate Elapsed Time from 2 Date/Time Stamps Fields?
Greetings, I'm currently trying to capture the elapsed time between two Date/Time stamp fields from a table in SQL and break it out by Days/Hours/Minutes. I've searched the content available on the BOARDville forums and have tried several ETL functions and can successfully calculate the days. However, taking the remainder…
-
Make one cube in a layout time independent
Hi there! I have a simple layout, with two cubes shown in a dataview. One of those cubes should react on the time selection I make, but the other one, should show me all years or to be more precisely, the cube should not react on the time selection. Is that possible? Regards Toni
