-
Not valid characters - how to fix?
Hello in some TXT files used to fed BoardI have some characters that are not recognized. I know that I can do something in the source data but for now I jsut want to fix the issue replacing such characters. Setting a formula in the ETL is seems working but when I run the data reader it does not work see the picture can…
-
Setting Privilege?
Hi All, Can application setting privilege user screen access?
-
Budget data with different dimensionality and granularity
Hi, how can we budget data for measures having different dimensionality and granularity? Consider some commercial and distribution cost calculated based on % or mileage Commission cost, for example, are a % defined by customer (or by product or by aggregate entity like channel or brand) and data entry form should refer to…
-
Date Cube-Calendar function in Web
In the desktop version of board, if you have a cube set to "Date" a small calendar will pop-up when doing data entry. I don't see that calendar in the web client. This isn't a huge deal, but does anyone know if this function is available at all in the web client?
-
blob export
Hi, is there a way to export (download) files which are uploaded in my blob cube into to a specific directory trough a procedure? Regards, Jörn
-
Nexel Calculation Problem
I am trying to use COUNTIF in nexel but it is not giving me what I am expecting. The formula is as follows for each block in the Priority column: - =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;1;*] ) =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;2;*] ) =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;3;*] ) =COUNTIF ( [@f;*;Range(1:7)],…
-
Change capsule database  doesn't work
Hello, I want to duplicate my environment (capsule and database) so I copied and renamed the capsule and the database. Then I opened my new capsule and changed the database to the new one. but it didn't work for me. All screens still pointed to the old database and what I found strange is that some procedures are pointing…
-
BOARD installation support
Hi I'm new and i have recently installed BOARD, but i have a problem. I'm not able to do my first access with the client. Can somebody help me?
-
Data selection Entity filtering
Database security: Data selection Entity filtering, Does anyone know why/how I can use the Exclude button? no matter what I do its always unavailable.
-
How to change where x and y axes meet?
Hello, Excel graphs have the option to change the axis value i.e. where the horizontal axis crosses. How can I achieve the same in Board? I can take off auto-range and set my own but the x-axis value remains as zero. Thanks, Ben
-
Adding an entity as block in layout
Hi all, I've to add multiple entities as blocks because using them in axis is exceeding the limit of around 2 billion rows, which is causing layouts to not load. Dataview has data for 24 months and when I'm adding entity as block, the same is shown separately for each month. I heard we can use 'Detail by' to show it only…
-
Not able to save or create procedures
Hi I am creating procedures and was renaming a few. Then I was suddenly not able to save the one I was working on: "The server is not responding or does not trust your user´s domain. Please check your connection settings" I can not create a new one and I can not delete one either but I can run the procedures and the…
-
Refer-to + rules?
Hi all, is it possible to use the refer-to in the layout and have the cube take the value of the rule that is used in combination? Say I have a cube a, with a rule "measures" (in functions) and also a "refer-to" to a value that is computed in the rule. In my case the result is empty. How'd you do that? BR, Ray
-
Data Picker -
Hello all, today i started to familiarize myself with the topic nexel and data picker. Now I tried to enrich values from one cube with a column from another cube. Here I come also fast to a result, which I cannot explain to myself however. The dimension of the value seems to overflow. Can anyone give me a hint which…
-
Can I deactivate column algorithms calculating "live"?
This may sound weird! But we would like the column algorithm to perform after we have saved the data entry so the figures in one column remain the same while planning
-
Problem of creating new relationship with a new entity
Hello everyone, I have an entity Client that is linked to an hierarchy of entities ( the hierarchy contains 6 successive levels) What I want to do is to link a new entity ( Enseigne) to the third level of this hierarchy the entity Ensiegne is the most detail level in the new relationship. How can I apply this solution in…
-
Time tree
Hello community, I have a question: My time axis is as shown bellow Periode Mois contain M-1,M,M+1. I have created a procedure that we run at the beggining of each month to bind M with the new current month, M-1 with the previous one, M+1 with all the coming ones, but the entity Day is not updated, do I have to create…
-
Mapping in Board
Hi, i'm quite new in Board and i'd like to know if I can create a user interface for mapping a general ledger. The requirement come from a customer that is asking us to mantain a P&L in BOARD. This will require, between others features, the possibility to create and mantain different P&L schema (in Board). Once the schema…
-
Substitution formula with an entity code instead of the description
Hello all, I know that we can use subsitution formulas to obtain the selection of an entity: However, are there subsitution formulas to obtain the same information, but using the code in the formula instead of the description? For example, for the entity: - code: "E_0000000018" - description: "Customer". Today I use the…
-
Unable to install Office Add-In with Microsoft Family and Student 2010 ?
Hello, When installing Office Add-In with Microsoft Family and Student 2010, I got the following error message :"You must have Microsoft Office 2007, 2010 or 2013 installed to use the product" .... How to make it work ? Thank You Patrick Cailly
-
Board Broadcasting as scheduled task
Hello Community, I set up the Broadcast functionality of Board to one of our clients and now we would like to schedule it to run every day. So, I create a bat file using the BoardWinClient.exe syntax. The script works find it sends emails with excel files attached. The problem is when I set it as a scheduled task in…
-
WinZip extraction error !!
* Hello everybody, It is the first time I raise a question .... so I welcome feed-back .... Thank You * I was upgrading to the latest Board version the B10.3.0. Following the download and the ZIP extraction into C / Program Files / Board then I got the error message from WinZip "Impossible to deal with "Setup Client…
-
Exclude item in a selector
Hello! Is it available a feature within a selector that allows to select all items but one? Something like the "Exclude" functionality of the Select function, but available also for the selector. Thanks, Emanuela
-
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 picker value is not being displayed ?!
Hello All, I am not able to display value using Data picker, here are the steps i have done from start, let me know if i am missing on some part to help rectify this. Step 1: Created a new Entity (SalesReport) Step 2: Created a cube name SalesCube (Using SalesReport in structure) Step 3: Created Rule and used Data picker…
-
Dataview on web not Sequential
Hi All, I have some problem about dataview on web version. When I am trying scroll dataview to the right, the data are sequential, but when I turn back to the left, the data are not sequential. Its like suddenly while user trying to scroll, it will jump to random column. Any advise ?? Attach 1 When I scroll this dataview…
-
Reset Database Security Profil
Hi there, accidentally, I added in the database security for the ADMIN profil an data selection script. Now I have no Access to my database. Is there any way to reset the database security profil? Regards, Jörn
-
The auto-update does not work unless the user has admin rights on their PC.  We do not want to
Hi, We have upgraded our board server to 10.1.4.50129. When installing the clients we selected the "#auto update" option. For users that have administrative rights on their workstation, the auto update usually works (but sometimes does not). However, if the user does not have admin rights on their workstation, the auto…
-
I am not able to delete entities/Groups. Deleted Groups and Entities reappears after clicking on Sav
Hello Team I created database using Data Fast track, now i want to delete the Entities and Group but i am not able to delete it 1. I tried Deleting all the entities One-by-One 2. Then I Deleted all groups 3. But as soon as i Clicked on Save Button, All the entities and groups are re-appearing, Can i know how can i solve…
-
Remove Database name from Database Drop-Down list.
Hello Team, I have unloaded a selected Database using Utilities > Unload (Under Database Section) , However it is still appearing in Drop Down list, How can i stop it from showing in the drop-down list OR permanently Delete it ?! Thanks, Malav
